Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread EDBUpdateSQL
Wed, Jan 10 2007 12:52 PMPermanent Link

Allan Brocklehurst
Hello;
 2 items of interest

1)
Is the syntax correct for this statement

UPDATE "Trust.Transactions" SET [ClientName] = 'Jones, Sally' WHERE
[ClientName] = 'Smith,  James  Camerion';

When I execute this EDBUpdateSQL I get an error "database Name is missing"

Also with EDBUpdateSQL
 I have to include the Updatekind as a parameter for the properites  of
ModifySQL.
..
e.g. QryUpdateTrans.ExecSQL(ukModify);

Is this redundant in that I did select ModifySQL?

Allan
Wed, Jan 10 2007 12:53 PMPermanent Link

This message was cancelled from within Mozilla.
Wed, Jan 10 2007 2:21 PMPermanent Link

This message was cancelled from within Mozilla.
Image