A simple choice sentence, I am new, the language is not very familiar, please look at it with a master, thank you

17157018

Sql: = 'update ZW.BZ set workdate =' '' + DateToStr (Self.DateTimePicker1.Date) + '' ', BANZU =' '' + Trim (ComboBox1.Text) + '' ', car =' '' + Trim (Edit1.Text) + '' 'where banzu =' + (Query1.FieldByName ('banzu'). AsString);

This sentence doesn't pass. I don't know if it's wrong. I don't have a book at hand. Thank you for your help.

endman

Sql: = 'update ZW.BZ set workdate =' '' + DateToStr (Self.DateTimePicker1.Date) + '' '+', BANZU = '' '+ Trim (ComboBox1.Text) +' '' + ', car = '' '+ Trim (Edit1.Text) +' '' where banzu = '+ (Query1.FieldByName (' banzu '). AsString);
-------------------------------------------------- --------------------

It's a bit messy to write this way;
sql: = format ('update zw.bz set workdate = ``% s' ', Banzu = ``% s' ', car = ``% s' 'where banzu = ``% s' '', [DateToStr (Self.DateTimePicker1.Date), Trim (ComboBox1.Text), Trim (Edit1.Text), Query1.FieldByName ('banzu'). AsString]);

endman

If you have to write it like this: Or it should be written like this:
Sql: = 'update ZW.BZ set workdate =' '' + DateToStr (Self.DateTimePicker1.Date) + '' ', BANZU =' '' + Trim (ComboBox1.Text) + '' ', car =' '' + Trim (Edit1.Text) + '' 'where banzu =' '' + (Query1.FieldByName ('banzu'). AsString) + '' ';

stevevai

The reason for not passing, you can check this statement when executing the SQL statement. To see if it is correct, I think the problem mainly occurs in the type matching, it may be the wrong type
Recommended parameters
E.g:
Sql: = 'update ZW.BZ set workdate =: workdate, BANZU =: BANZU, car =: Car where banzu =: banzu2'
// cmd represents the data set execution component
// If the field workdate is a date field
cmd.Parameters.ParamByName ('workdate') .Value: = DateTimePicker1.Date;
Other similar

17157018

It can pass now, but the data item that always jumps out of banzu appears SQL6022N. It is invalid in the context of using it. What could be the problem? ?

17157018

Wrong is 0206N