To connect to a remote mysql server in the following way,

SQLQuery1 - DataSetProvider1 - ClientDataSet1 - DataSource1 - dbgrid

Execute the following code, how can't dbgrid data update

SQLQuery1. SQL. The Clear;
SQLQuery1. SQL. Text:="insert into student (id, name) values (11, 3) '.
SQLQuery1. ExecSQL ()

CodePudding user response:

After ClientDataSet1. Close;
ClientDataSet1. Open;

Run go wrong again return error: Cursor not returned from the Query -...

CodePudding user response:

Insert the delete the update does not return a result set