crdbgrid problem

crownfield · Post by **crownfield** » Mon 17 Jan 2011 02:51

I enter a new record, and then, advancing to the next record, I get a SQL error message because the SQL set uses the format set (fieldlist) values (valueslist).

valuelist matches the crdbgrid order, but the SQL (fieldlist) order does not match the valuelist order. how can they be different?

fields and columns are not persistent, and the dataset is opened in the show form event. I expect the grid to know both fields and values in the same order.

Delphi 5, data access components for mysql.

AndreyZ · Post by **AndreyZ** » Mon 17 Jan 2011 12:51

Hello,

I cannot reproduce the problem. Please specify the following:
- the exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- the exact version of MySQL server and client. You can see it in the Info sheet of TMyConnection Editor.
- the SQL code (if you use TMyQuery);
- the table structure (script).