This is gettig irritating. 'statement is not accepted'
Is that the error message? 'statement not accepted' You can't expect us to keep answering this kind of questions. An why all these quotes arount the field names? Does that even compile? And read this, before you sent another question: www.catb.org/~esr/faqs/smart-questions.html On Wed, 2006-03-15 at 21:14 +0000, Panagiotis Sidiropoulos wrote: > 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 > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
