TADOQUERY update

From: Kurt Callebaut (Kurt.Callebaut_at_AucxisTrading.com)
Date: 04/29/04

Next message: Bill N: "Stored Procedure, Parameters.Add and Delphi Syntax"
Previous message: Jeremy Collins: "Re: Design a table"
Next in thread: Brian Bushay TeamB: "Re: TADOQUERY update"
Reply: Brian Bushay TeamB: "Re: TADOQUERY update"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Thu, 29 Apr 2004 17:15:38 +0200

Hi,

I have used an TADOQuery.edit and post to change some data on the SQL2000
database, but when the recoird on the database has been changed by another
application, the application hangs.

Is there a property that can be set, so the update only checks if the key
exists or has been changed? It seems all the field must be the same the
update the record.

I can remeber some other components who can set a propertie to
updatewhereall, updatewherekey...

Thanks

Kurt

Next message: Bill N: "Stored Procedure, Parameters.Add and Delphi Syntax"
Previous message: Jeremy Collins: "Re: Design a table"
Next in thread: Brian Bushay TeamB: "Re: TADOQUERY update"
Reply: Brian Bushay TeamB: "Re: TADOQUERY update"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: Logical filename
... Kurt ... > file names, if you want to revise them for any purpose, SQL Server 2000 ... >> When a make a backup of a database and restore it to a new database, ... >> then i have to change the fysical filename, ...
(microsoft.public.sqlserver.programming)
Re: Logical filename
... Kurt ... >> When a make a backup of a database and restore it to a new database, ... >> then i have to change the fysical filename, ...
(microsoft.public.sqlserver.programming)
Re: Approval Question
... Kurt, ... I don't know of anyway to tiea digital signature to a field. ... > I have a access 2003 database that is comprised of different forms to do ... > signature to validate that a particular person approved the data in the ...
(microsoft.public.access.security)