Re: ADOQuery Command Text does not return a result set


"Leposava Knez" <leposava.knez@xxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:4836b68d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi
I have this code
ADOQ2.Active:=False;
ADOQ2.Close;
ADOQ2.SQL.Clear;
sqlFill := '';
sqlFill := ('UPDATE Izpisi ');
sqlFill := sqlFill+(' Set DATA =
'''+AdoTable1.FieldByName('data').AsString+'''' );
sqlFill := sqlFill+('WHERE IZPISTIP = 1');
ADOQ2.SQL.Add(sqlFill);
ADOQ2.ExecSQL;
ADOQ2.Active:=True;


and I get this error message: Command Text does not return a result set

what is the problem?
1. It is strongly advised to use Parameters or at least QuotedStr function
for supplying values into SQL
2. Remove "ADOQ2.Active:=True;" since ADOQ2 holds Update query but not
Select query.


.

Relevant Pages