sqlite Problems

camin920 · Post by **camin920** » Mon 12 Mar 2012 07:36

CREATE TABLE "main"."NewTable" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
"fname" nvarchar(100) NOT NULL,
"fno" nvarchar(20)
)

uniquery.sql.add('select * from NewTable');
uniquery.open
uniquery.insert;
uniquery.FieldValues['fname']:='jack';
uniquery.FieldValues['fno']:='10';
uniquery.post;

Problems
strid:string;

strid:=uniquery.FieldValues['id'];

strid is null

AlexP · Post by **AlexP** » Mon 12 Mar 2012 10:09

Hello,

We have checked the autoincrement field completion when inserting a new record - after calling the Post method, the new retrieved value is filled in correctly. Please specify your exact UniDAC version. We checked this behaviour on the latest UniDAC version 4.1.5

camin920 · Post by **camin920** » Tue 13 Mar 2012 08:59

AlexP wrote:Hello,

We have checked the autoincrement field completion when inserting a new record - after calling the Post method, the new retrieved value is filled in correctly. Please specify your exact UniDAC version. We checked this behaviour on the latest UniDAC version 4.1.5

============================================
i test on the latest UniDAC version 4.1.5

If the table name in Chinese ，when inserting a new record - after calling the Post method ,autoincrement field is null

If the table name in ascii ，when inserting a new record - after calling the Post method ,autoincrement field correctly

i Test uniDAC 3.70 No problem！
sorry ！！！English is poor

AlexP · Post by **AlexP** » Tue 13 Mar 2012 12:31

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.