> SQLQuery.SQL.Add( 'update `ids-aa`' ); > SQLQuery.SQL.Add( 'set `ids-licenses-left`=1' ); > SQLQuery.SQL.Add( 'where `ids-internet-id`="aa-123456789012345678"' );
"ids-aa", "ids-licenses-left", "ids-internet-id" are field names into "ids-aa" table. "aa-123456789012345678" is content of record in "ids-internet-id" filed which should be apdated. Thank you for your time. Panagiotis Στις 15-03-2006, ημέρα Τετ, και ώρα 11:55 -0800, ο/η johnf έγραψε: > On Wednesday 15 March 2006 13:36, Panagiotis Sidiropoulos wrote: > > Additionaly to my original post, this query is executed under Linux > > using sqldb components TSQLQuery, TSQLtransaction and > > TMySQL41Connection. If any additional information is required please > > just task. > > > > Στις 15-03-2006, ημέρα Τετ, και ώρα 21:14 +0000, ο/η Panagiotis > > > > Sidiropoulos έγραψε: > > > I use following code to update a table. Connection is succesfuly carried > > > out and before this, Select statement executed succesfuly. Problem is > > > that this statement is not accepted. I checked this same statement > > > through an MySQL client and it was executed properly. Can anyone please > > > advise? > > > > > > SQLQuery.Close; > > > SQLQuery.SQL.Clear; > > > SQLQuery.SQL.Add( 'update `ids-aa`' ); > > > SQLQuery.SQL.Add( 'set `ids-licenses-left`=1' ); > > > SQLQuery.SQL.Add( 'where `ids-internet-id`="aa-123456789012345678"' ); > > > showmessage( SQLQuery.SQL.Text ); > > > SQLQuery.Open; > > > > > > I also tested this statement a one line setting this to .text property. > > > > > > Panagiotis > > First is 'aa' a variable that you are attempting to pass? > Also I believe you do not need all the quotes. > sqlquery.text ='update ids-aa set ids-licenses-left = 1 where ids-internet-id > =aa - 123456789012345678'. Of couse I don't know what 'aa' is all about. > John > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
