> > Afaik Zeos manages to abstract this for all these dbs by having a > > sequence object. > > I fail to see how it can do that. E.g. the mechanism by > Martin is just a trick to update > a field value after an insert/update. That's a fine/useful > mechanism, but not what I'd call > 'abstracting'. > > But never mind. I think the trick is useful, and we should > look into getting it in SQLDB. >
Zeos TZSequence is only supported for Oracle, IB and PostGreSql, ie. the databases using sequences. AFAIK, the use of TZSequence is also mutually exclusive with a trigger that uses that sequence. When using a trigger the RETURNING clause is the solution to use. A very limited abstraction... Ludo _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal