I tried 'id' and 'ID' because SQL is case insensitive. The sqlite command line interface accepts any case for field names. If it is getting passed to the interpreter correctly, the case shouldn't matter.
I see the same behavior (FieldNotFoundException) with 'rowid', which is an SQLite alias for the PRIMARY KEY field. Any idea on why Dabo doesn't like it? Thanks, Richard Esplin On Wednesday 01 October 2008 19:26:13 Ed Leafe <[EMAIL PROTECTED]> wrote: > On Oct 1, 2008, at 7:34 PM, Richard Esplin wrote: <snip> > > 3. The other aliases for the id field are still not seen by the > > interpreter: > > dabo.dException.FieldNotFoundException: Field 'ID' does not exist in > > the data > > set > > Python is case-sensitive; "id" != "ID". > > "id" is a perfectly valid name for a database column, and thus > perfectly valid for a DataField. I'll have a fix ASAP. > > -- Ed Leafe _______________________________________________ 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]
