Zeoslib Portal

that's right, as the ZTable component doesn't know the value of the autoincrement field of the record that was added, is has to refresh the data to retrieve the inserted value. the new record has to be posted without a value for the autoincrement field when working with a TDBGrid, for example.

autoincrement works fine with fb and zeos in firebird you create a generator and a trigger: for e.g. table 'acties' and autoincrement field 'idnummer' (with unique index): (SET TERM ^; ) CREATE GENERATOR "GEN_ACTIES_IDNUMMER"^ SET GENERATOR "GEN_ACTIES_IDNUMMER" TO 0^ CREATE TRIG...

seawolf, with lazarus and fb 2.1.2 and zeos 6.6.5 I couldn't open a resultset without the change, so insert with returning did not work, just because the insert statement is executed with FRowsAffected := Statement.ExecuteUpdatePrepared; which does not fetch a resultset. ZQuery.Open does not work ei...

Mark,
concerning the test suite : I found the buildingtests.pdf in the doc subdir of zeos665. I have no delphi license (only delphi 2), so I suppose I cannot set up the test suite. Unless there is a port to Lazarus?
Guido

You are probably right about the memory leak, FResultset isn't freed nor nilled in TZAbstractRODataset, but maybe that might be solved in the destructor with an if<>nil. On the other hand, in ZDbcInterbase6ResultSet.pas, line 139 [quote] { TZInterbase6ResultSet } {** Releases this <code>ResultSet</c...

no idea, don't know anything about oracle
(and almost nothing about firebird, to be honest)

ok, before you executedirect() you should make the connection with
Connect_DB.connect;

try Connect_DB.ExecuteDirect() instead of ZConnection.ExecuteDirect()
guido

defining an sql string by means of DateTimeToStr() is tricky.
better is passing datetime as parameter
guido

well, you're right, it happens on the server, but zeos checks for errors an passes them through ; I tried it ( zeos 6.6.5; lazarus 0.9.26.2, xp) i get a dialog with : SQL error : conversion error from string "31/04/2010". Error code : -413. Overflow occured during data type conversion. (.....

after all, after the editing the records are sorted on field1, but in descending order (r,p,h,g).... before the editing, the records are not sorted on field1 (r,g,h,p)
isn't that what is should do?
guido

In any case there must be a conversion of string to datetime that will raise an exception...
guido

akli_agha,
No, you have to put your sql in the ExecuteDirect('string'), not in the 'properties'. It is implemented as a executeUpdate statement, returning an integer representing the number of affected rows.
guido

signals,
you should give some more information. what is the table definition, how do you insert, which platform, what versions?...
guido

Dewie,
you can assign any procedure that handles exceptions to the
application.onexception property

Guido