Devart Forums

Hello,
when a SQLite table is created with quotes ( create table "aaa" (field1 varchar(30) ....... ), there is problem whenever I want edit fields. After post record an error message is shown 'near ".":syntax error '
After change table name to without quotes, all works ok.
Please do you know any solution ? (sorry for bad english)

Hello,

I cannot reproduce the problem.
Please try to execute the following code:

if the problem doesn't arise, please modify the code to reproduce the problem, and send it me.

Also please specify the exact version of UniDAC and SQLite.

Hi Alex,

thank you for answer. Please use another table name (see code). I got that table by another application. Although table name is not standard, in sqlite managers it works properly

UniConnection := TUniConnection.Create(nil);
UniConnection.ProviderName := 'SQLite';
UniConnection.Database := ' ';
UniConnection.LoginPrompt := false;
UniConnection.Connect;

UniConnection.ExecSQL('CREATE TABLE IF NOT EXISTS "TCP-IP_6.0" (field1 VARCHAR(30)) ',[]);

UniQuery := TUniQuery.Create(nil);
UniQuery.Connection := UniConnection;
UniQuery.SQL.Text := 'Select field1 from "TCP-IP_6.0"';// or UniQuery.SQL.Text := 'Select field1 from aaa';

UniQuery.Open;

UniQuery.Append;
UniQuery.FieldByName('field1').AsString := 'test';
UniQuery.Post;

appendix:
Unidac version 3.60.0.15, sqlite3.dll

Now I have notified, that the dot character in the table name causes the problem

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.

thank you

Hello,

We have fixed the problem.
This fix will be included in the next build.
The next build will be available next week.