On Thursday, May 12, 2011 01:21:42 pm K Peters wrote:
> On Thu, May 12, 2011 at 12:00 PM, John Fabiani <jo...@jfcomputer.com> 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: 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/201105121200.46068.jo...@jfcomputer.com
>
> 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
>From what I have been reading I would agree. However, in this case the
datatype actually changes. And the fact that it changes is dependent on the
contents of the first record in the dataset I'm working with. If the first
record contains a Null the Dabo routine returns a text (string) - if it's a
date it returns dates.
This was completely unexpected and I believe it's a Dabo bug. I'm not sure
how to fix it but it needs fixing.
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/201105130630.50848.jo...@jfcomputer.com
