On Thursday, May 12, 2011 01:23:28 pm Paul McNett wrote: > On 5/12/11 1:03 PM, Paul McNett wrote: > > Set DataStructure explicitly. > > Oops, you are talking about datasets not cursors. dDataSet uses a different > method to track types. Try this patch and post the output to see if my > hunch is correct (function assumes that the types of the first record are > the types of the remaining records, but doesn't handle NULL/None): > > Index: dDataSet.py > =================================================================== > --- dDataSet.py (revision 6589) > +++ dDataSet.py (working copy) > @@ -281,7 +281,9 @@ > retList.append("%s %s" % (safekey, > ds._typeDict[typ])) > except KeyError: > retList.append(safekey) > - return "create table %s (%s)" % (alias, ", ".join(retList)) > + ret = "create table %s (%s)" % (alias, ", ".join(retList)) > + print ret > + return ret > > > def _populate(self, ds, alias=None): > > > Paul
Below is the output - Why are some of the fields datatypes are noted but others are not? And of course the mustenrollby has no datatype? create table dataset (sqlstmt text, sql_limit text, pkid integer, lk_filter, tablename text, datatype text, colcount integer, txtboxid, hlist text, lookupfld text, regid text, sql_orderby text, prikey text, retfield text) create table dataset (abbrev text, depart integer, restitution_tobedeter, comsvcworked decimal, course_pay_sched text, clientid integer, topic text, yntbd text, rereferred, inactive, enrollid integer, state_1 text, paid_amt decimal, clientname text, hrs_attended, topicid, datepaid date, agency text, dej, caseno text, lname text, restitution_paid decimal, program text, nxt_class date, missed_cnt integer, status text, community_tobedeter, fname text, ccode text, terminated, completed, paid decimal, loc2 text, phone text, loc1 text, hrs_req integer, comsvcreq integer, rest_amt decimal, course_cost decimal, ret_to_court date, agencyid integer, language text, loc3 text, hold_until, ref_no text, programid integer, mustenrollby, me_ltr_sent, enrolled date, referred date) create table bd (paid_amt decimal, course_cost decimal, enrolleeid text) Johnf _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/201105121416.41367.jo...@jfcomputer.com