Michael Bell wrote:
Oracle was the first who supports sequences :) PostgreSQL copies the stuff from Oracle. DB2 actually supports sequences.i know, that they support this, i was just thinking, about how they realize this internal... thats all ;)
This is what I'm doing actually but I need more than one SQL statement for this today :(yes, i will have some looks to the scripting capabilities of mysql, since we most probably will use the newer versions (for innodb) and transaction support... so maybe we can realize this whitch one call
and the database does the 'rest'
what came into my mind to - most probably this should also work with mysqlmax (sapdb) they should support transactions there too... don't they? havn't checked this, but innodb is supported longer i think, so this may be the best option for mysql
SQL does not allow "insert into abc (keyname) VALUES (NULL)". Perhaps MySQL supports this but I don't like such risks. Therefore I use a column dummy.ah, yes thats true, but a
"insert into abc (keyname, nokeycolumn) VALUES (NULL, 0)" doesn't makes it any better in my eyes ;)
- since "key - NULL" is the real 'problem', but maybe this call its safer... i think its not more standard compatible then before
ah k, where just wondering, didn't look into the code, just checked the cvs mails, so i didn't see any comments to thisall: SEQUENCE_EXIST and SEQUENCE_NEXT are the same commands? for all dbs... - i thought exist checks if an sequence exists? or what does it mean?
Actually yes, but some better database guys than I can implement this with the internal system catalogs.
greetings dalini
------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
