Doubt about query in Delphi 7

Question

I have a certain problem when trying to run an update query in my database, Delphi gives error as incorrect syntax, but I could not find the problem. Could someone please help me ?

Follows prints:

Answer 1

Try:

'UPDATE Tbl_aluno SET nome = '+QuotedStr(edit_nome.text)+'
WHERE PRONTUARIO ='+QuotedStr(.....)

Quotedstr ensures that the parameter is enclosed in quotes, for example: name='AUGUSTO'

Answer 2

Error occurred because your query has no quotes in the text fields.

There are a few ways to quote a string in Delphi:

1. Function Quotedstr('string'):

   ShowMessage(QuotedStr('teste'));
   

2. Use three single quotes:

   ShowMessage('''teste''');
   

3. Concatenate with code ASI39

   ShowMessage(#39+'teste'+#39);
   

   or

   ShowMessage(Chr(39)+'teste'+Chr(39));