on 6/18/01 2:11 AM, "Danny Angus" <[EMAIL PROTECTED]> wrote:
>
>> Questions:
>>
>> #1. How are you going to handle the fact that every database out
>> there has a
>> different set of needs for getting ID's for inserts?
>> #2. How are you going to handle the fact that every database out
>> there has a
>> different idea of how SQL should be written?
>
> By using only ANSI SQL, and by having an XML conf file containing the SQL
> for any variations from ANSI (outlined a wee while ago on this list)
>
> no?
>
> d.
If you are using integer id's as your primary key, then ANSI FOO doesn't
help you at all because every database generates those id's in their own
way. MySQL uses autoincrement, Oracle uses sequences.
In the case of James, that isn't an issue. I was brining up the questions
because I'm not familiar with James' schema and I wanted to make sure all of
the bases were covered.
-jon
--
"Open source is not available to commercial companies."
-Steve Ballmer, CEO Microsoft
<http://www.suntimes.com/output/tech/cst-fin-micro01.html>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
