UniQuery??
Posted: Tue 12 Oct 2010 00:27
Hi, I encounter one problem.
I have a UniQuery1 in my application, it can retrieve the data from the MySQL server by excuting a simple SQL "select * from table_xyz". The results feed to a datasource VCL and further directed to a TMSdbAdvGrid.
It works fine to this step, however, when I fill in a cell with text and triger following code,
UniQuery1.Edit;
UniQuery1.FieldByName('Info_type').AsString:=AdvGrid.Cell[x,y];
UniQuery1.post;
The target table_xyz does not update with the new data.
I traced the code, each line has been executed without any error, however, your DBmonitor did not show any SQL command has been executed.
Does it mean , I can not use UniQuery with Mixed SQL and Table-like mode? Or I missed sth before doing the Table-like update?
Thanks
I have a UniQuery1 in my application, it can retrieve the data from the MySQL server by excuting a simple SQL "select * from table_xyz". The results feed to a datasource VCL and further directed to a TMSdbAdvGrid.
It works fine to this step, however, when I fill in a cell with text and triger following code,
UniQuery1.Edit;
UniQuery1.FieldByName('Info_type').AsString:=AdvGrid.Cell[x,y];
UniQuery1.post;
The target table_xyz does not update with the new data.
I traced the code, each line has been executed without any error, however, your DBmonitor did not show any SQL command has been executed.
Does it mean , I can not use UniQuery with Mixed SQL and Table-like mode? Or I missed sth before doing the Table-like update?
Thanks