[Opensource] Using DBObjects on tables that have keywords as field names

Dcomeau at xenos.com Dcomeau at xenos.com
Tue Mar 4 17:29:44 PST 2003


Hi All,

The Expresso app I'm writing is a component of suite of "executables" where
my Expresso app writes to the database tables and other components read from
it to perform business logic.

I have very little control over the format of the database as it was handed
to me along with the requirements for my component.  And for some reason the
guys who built the tables decided to use SQL Server keywords for some of
their field names (ex: Column, Position, Section, Value).

And I just discovered that this is not doesn't go over too well when using
DBObjects.


I read this thread:

  http://mail.jcorporate.com/pipermail/opensource/2001-November/009413.html

...but is there a way I can get around this with some Expresso parameters
rather than fighting to get the fields changed?  

I'm way outnumbered and they've been plagued with tons of database changes
already as it is...they are writing a conversion utility to import data for
clients running a previous version of the product and are forced to modify
it each time there is a table change.

I have my fingers crossed but something tells me I'm not gonna like what I
hear! :P


Cheers
Dave



More information about the Opensource mailing list