On Thu, May 12, 2011 at 12:00 PM, John Fabiani <[email protected]> wrote: > Hi, > > If I do something like the following a datatype is changed from date to string > depending on the first record of the dataset. > > fields: > mustenrollby = date > referral = date > > first record > mustenrollby = Null > referral = '2011-04-10'::date > > second record > mustenrollby = '2011-04-24'::date > referral = '2011-04-10'::date > > aliasDict = {"bd":dsBalanceDue} # contains only 3 fields not mustenrollby > dsNew = ds.execute("""select dataset.*, bd.course_cost as bd_course_cost, > bd.paid_amt as bd_paid_amt > from dataset join bd on dataset.enrollid = bd.enrolleeid order by > dataset.lname""", cursorDict=aliasDict) > > after executing the above the data type for the second record - mustenrollby > is now a string. > > or u'2011-04-24' > > If the first record contains a real date the change does not happen??? > > Johnf > _______________________________________________ > Post Messages to: [email protected] > 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/[email protected] >
John, SQLite is *very* different from other SQL databases in that it uses manifest typing (see http://sqlite.org/different.html) which can cause the effects you have been observing; I would assume that Dabo takes whatever SQLite reports as data type for fields and it goes from there. Cheers, Kai _______________________________________________ Post Messages to: [email protected] 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/[email protected]
