Insert error mysql

[omejiasq]

Hi, i im trying of insert one row in mysql and i get one error. I have Delphi XE4 and i im testing one iphone application. When i run my program, this connect correctly to remote mysql, but when i do one insert this return in iphone simulator this error: (Access violation at address 00A944D0, accessing adress 0000028C)

I have this lines when i do insert and i get error:

Query.SQLInsert.Text := 'INSERT INTO products VALUES (0)';
Query.Execute;

Please can anybody help me?

Thank you.

[DemetrionQ]

Hello.

The TUniQuery.SQLInsert property sets an SQL query that will be executed when inserting a record to an open dataset (more details about the SQLInsert property can be found at http://www.devart.com/unidac/docs/index ... insert.htm ). If you need to run a SQL query directly, use the TUniQuery.SQL property, for example:

Code: Select all

Query.SQL.Text := 'INSERT INTO products VALUES (0)';
Query.Execute;

We have checked the described behaviour - there is no access violation. Please let us know the exact version of your IDE (for example, RAD Studio XE4 Version 18.0.4905.60485) and the exact version of UniDAC (for example, UniDAC 5.0.2).