Re: couldn't perform di edit because ...

["Shulzhenko Vasyl" <vasilis@softline.kiev.ua>]

Hi Marco!

The problem is in a way how Delphi identify key for the records in the live
queries. It just simply use something like "UPDATE table1 SET field1 = value1
WHERE field1 = oldvalue1 AND ..... AND fieldN = oldvalueN".
Better use TUpdateSQL to identify records for update either by ROWID either by
Primary Key.

--
Ivan Lyakhovenko, project manager, xTech Ltd.
Novosibirsk, Russia.
mailto:van@xTech.ru
http://www.xTech.ru

Marco ОХЬЕР Б ЯННАЫЕМХХ <36B02778.143C96E2@kernex.it> ...
>Hi all,
>I'm new to Informix and I have this silly problem.
>I developed an application using Delphi 3 as front-end and IDS 7.3 as
>database server.
>The interface is connected to the database server via Infromix Client
>2.8
>The database server runs on an NT Workstation machine.
>Each user logs into the server with the same login and same password,
>but when a user tries to edit or delete something inserted by another
>user I always get the error
>COULDN'T PERFORM THE EDIT BECAUSE ANOTHER USER CHANGED THE RECORD.
>I tried to grant dba privileges to public, but nothing appened.
>Can anybody help me?.
>
>Thanks in advance
>Marco
>
>
>mailto:dellegi@kernex.it
>