Hi everyone, I've somehow managed to get Sybase ASE running, but I think Sybase tried real hard to introduce incompatibilities (hopefully not :P ) between Sybase ASE and Sybase ASA ( in which I tested much of my kexi code :( )
Auto-increment column is available in Sybase ASA as both `AUTOINCREMENT` and `IDENTITY`. But in Sybase ASE there's only `IDENTITY` ( as afar as I could find ). Now, the interesting thing about this column is explained in the following (tinied) link: http://tinyurl.com/25ltr9 There is a similar option, identity_update which needs to be set/reset before updating an IDENTITY column. Now, the issues : 1. It needs the field list to be specified in every INSERT statement which inserts an explicit value into the IDENTITY column. This is currently not done in Kexi for some `INSERT INTO` queries. Trivial to add,I assume. Shall I ? 2. I need to set/unset the options, `identity_insert` and `identity_update`, before Inserting / Updating respectively, and turn them off immediately after the respective query. ( these options need to be set per table). Given the fact, that I only have the SQL query string, when I get one of these `execute` queries in the driver code, I guess the right way to proceed is to use the KexiDB::Parser class for getting the operation, tableschema etc. . (or is there a better method ? ). Thanks in advance for any suggestions :) Cheers and Merry Christmas to one and all :) Sharan Rao _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
