Sybase ODBC Driver problem?


2004-07-12 07:39:52 PM
off-topic4
Hi,
i use Sybase ASA 8.02 with ODBC driver & BDE. i use TDatabase & TQuery
(RequestLive := True).
my tables have autoincrement field. When i use master-detail records, our
program doesn't retrive autoincrement value. i set AutoGenerateValue :=
arAutoInc then my program retrive autoincrement field's value but when i
insert new record detail table, i couldn't see the record. i have to close
and open the query.
Master Query : RequestLive (open), AutoGenerateValue (arAutoInc), first
field (autoincrement & PK)
Detail Query : RequestLive (open), AutoGenerateValue (arAutoInc), first
field (integer), second field (autoincrement), 1-2 fields (P.K.)
How can i solve this?
P.S. i try same situation with BDE & paradox tables, everything is OK.
Best Regards.