Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread (no subject)
Wed, Jan 10 2007 12:49 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:51 PMPermanent Link

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

This message was cancelled from within Mozilla.
Wed, Jan 10 2007 12:52 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