[thelist] CF: Determining which DB used.

rudy r937 at interlog.com
Wed Sep 12 11:24:03 CDT 2001

> the simplest way is to only use sql that will run on all platforms.  
> this is next to impossible to achieve though.

sad but true

one strategy that deserves consideration is to create
table views that isolate specific database syntax
and allow you to deal with "standard" result values that
you determine to be the easiest or simplest to deal with

for example, you could write a microsoft access query

   select   IIf(foo='Yes',1,0) as foo

in order to transform the access Yes/No values to 1/0
and then query this query (which is the way you "implement"
a view in access)

nevertheless, it seems to me that this is barking up the
wrong tree

for one thing, INSERTs will be hell to implement this way

the effort that you put into making your sql database-proof
(i.e. generic enough to be used in the app no matter which
database you're running against) could probably be better
invested in designing the tables to be platform-agnostic
in the first place

for example, sure booleans are great, but a small integer
serves just as well

i realize this is small comfort if you are already working
with an established database design

stick as close to the sql standard as possible, and the
ripple effect should be minimal


More information about the thelist mailing list