Page 1 of 1
sqlite Problems
Posted: Mon 12 Mar 2012 07:36
by camin920
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
Posted: Mon 12 Mar 2012 10:09
by AlexP
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
Posted: Tue 13 Mar 2012 08:59
by camin920
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
Posted: Tue 13 Mar 2012 12:31
by AlexP
Hello,
Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.