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 > > _________________________________________________________________ > 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
