Pages: 1

#1 2012-08-31 05:50:27

wienani
Member
Registered: 2012-08-31
Posts: 29

ID always return 0 (using SynDBFIBPlus.. :D)

Hi Arnaud,

I try to make connection to Firebird using FIBPlus component, so I make SynDBFIBPlus.pas based on SynDBOracle.pas. As far I can save record and read back. But I'm stuck that ID always returning 0. Please give me a hint to trace it. Thanks

Sorry my bad English

Last edited by wienani (2012-08-31 05:52:18)

Offline

#2 2012-08-31 07:05:08

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,657
Website

Re: ID always return 0 (using SynDBFIBPlus.. :D)

It is difficult to guess what is wrong, without any source code...
You can email me something at webcontact01 at synopse dot info

This is very interesting to have direct FireBird access.
But perhaps worth integrating the client layer directly within SynDB, without any dependency on other components.
A first working code is always welcome!
Then I will perhaps re-factor it to meet mORMot "way", e.g. do not depend on DB.pas or other units.
I do not have experiment with FireBird, I guess the stand-alone engine could be used for dev and testing.
Then if you can help about debugging and real-world testing, this could be great!

Thanks for your interest!

Offline

#3 2012-09-02 10:03:05

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,657
Website

Re: ID always return 0 (using SynDBFIBPlus.. :D)

I took a look at your code.

Sounds to be fine, at first glance.
The ID column should be retrieved normally, as with other engines.
Or perhaps your testing code is wrong: you do not have to publish by yourself an ID: integer field in your TSQLRecord. It is defined in the parent, in a special way.
I do not have any FireBird DB at hand to test it. So I was unable to reproduce the issue.

But I do not like the fact that the FIBPlus components are not Open Source.
It could not be included as-this in our source code repository: re-factoring will be needed.

Offline

#4 2012-09-10 05:37:59

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

After a lot of tracing, i found "GetVirtualTableSQLCreate" not create ID INTEGER for "function vt_Create", so I realize i cannot use WHERE ID=1, always raise an error : "ESQLite3Exception: no such column: ID" at "TSQLRequest.Prepare". Please help me Arnaud, maybe i miss something about creating ID INTEGER ?

Thanks.

Last edited by wienani (2012-09-16 06:51:25)

Offline

#5 2012-09-10 06:01:32

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

ab wrote:

But I do not like the fact that the FIBPlus components are not Open Source.
It could not be included as-this in our source code repository: re-factoring will be needed.

big_smile I understand Arnoud, but my reason made SynDBFIBPlus because I feel still need long time for your framework support Firebird and second I feel your ORM have great basic design to communicate with other DB direct component (sure i need extra time to coding) like OCI.

So I wish if you add "Simple" interfacing framework and guidance to others DB direct component rather than your default DB connection. I think that make your ORM more ready with all type of database with everyone have own SynDBxxx.

I'm sorry about English sad  maybe my idea is from DevExpress QuantumGrid's ProviderMode framework, so i can use my own datasource (XML, Stringlist, JSON etc) not depend from TDataset only.

Offline

#6 2012-09-10 06:06:09

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

ab wrote:

perhaps your testing code is wrong: you do not have to publish by yourself an ID: integer field in your TSQLRecord. It is defined in the parent, in a special way.

No i cannot publish an ID, because your code already block it : "TSQLxx should not include a ID published property"

Offline

#7 2012-09-16 12:39:24

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

Hi Arnaud,

I try using TOleDBJetConnectionProperties, raise same error "ESQLite3Exception: no such column: ID"


*** For Server ***

procedure TfmMainServer.enStartClick(Sender: TObject);
begin
//    FB := TSQLFIBConnectionProperties.Create('', 'D:\TestMormot\Test.fdb', 'sysdba', 'masterkey');
    FB := TOleDBJetConnectionProperties.Create('D:\TestMormot\Test.mdb', '', 'Admin', '');

    Model := TSQLModel.Create([TSQLSys_UserProfile]);

    VirtualTableExternalRegister(Model, TSQLSys_UserProfile, FB, 'Sys_UserProfile');

    DB := TSQLRestServerDB.Create(Model, ChangeFileExt(paramstr(0),'.data'), true);
    DB.CreateMissingTables(0);
    DB.CreateSQLIndex(TSQLSys_UserProfile, 'USERLOGIN', True, 'IX_SYS_USERPROFILE_USERLOGIN');

    Server := TSQLite3HttpServer.Create('9000', [DB]);
end;


*** For Client ***

  Model := TSQLModel.Create([TSQLSys_UserProfile]);

  Database := TSQLite3HttpClient.Create('127.0.0.1','9000', Model);
  TSQLite3HttpClient(Database).SetUser('User','synopse');

  ShowMessage('Ready To Fetch');

//   Rec := TSQLSys_UserProfile.Create(Database, 'UserLogin=?', [StringToUTF8(enHost.Text)]);   // ==> Success, but ID always 0
   Rec := TSQLSys_UserProfile.Create(Database, 'ID=?', [StringToUTF8(enHost.Text)]);            // ==> FAILED "ESQLite3Exception: no such column: ID"  

  showmessage('ID=' + IntToStr(Rec.ID) + ' - ' + Rec.GetSQLSet);


*** For Model ***

  TSQLSys_UserProfile = class(TSQLRecord)
  protected
    fSiteID: integer;
    fRoleID: integer;
    fEmployeeID: integer;
    fUserName: RawUTF8;
    fUserLogin: RawUTF8;
    fUserPassword: RawUTF8;
    fRecoveryEmail: RawUTF8;
    fNumOfLogin: integer;
    fDeposit: currency;
    fNotes: RawUTF8;
    fStatus: integer;
    fCreateDate: TDateTime;
    fCreateUserID: integer;
    fEditDate: TDateTime;
    fEditUserID: integer;
    fDataSource: integer;

  published
    property SiteID: integer read fSiteID write fSiteID;
    property RoleID: integer read fRoleID write fRoleID;
    property EmployeeID: integer read fEmployeeID write fEmployeeID;
    property UserName: RawUTF8 index 20 read fUserName write fUserName;
    property UserLogin: RawUTF8 index 20 read fUserLogin write fUserLogin;
    property UserPassword: RawUTF8 index 32 read fUserPassword write fUserPassword;
    property RecoveryEmail: RawUTF8 index 128 read fRecoveryEmail write fRecoveryEmail;
    property NumOfLogin: integer read fNumOfLogin write fNumOfLogin;
    property Deposit: currency read fDeposit write fDeposit;
    property Notes: RawUTF8 read fNotes write fNotes;
    property Status: integer read fStatus write fStatus;
    property CreateDate: TDateTime read fCreateDate write fCreateDate;
    property CreateUserID: integer read fCreateUserID write fCreateUserID;
    property EditDate: TDateTime read fEditDate write fEditDate;
    property EditUserID: integer read fEditUserID write fEditUserID;
    property DataSource: integer read fDataSource write fDataSource;
  end;

Offline

#8 2012-09-16 20:34:12

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,657
Website

Re: ID always return 0 (using SynDBFIBPlus.. :D)

how is the data in your db?
there should be an ID column in the table.
also please report the exact error message and code line.

there was now issue with jet on our tests about a missing column.

column ID is an integer, and you should use the corresponding create  instead of manual id=? query.

I'll check the code tomorrow..

Offline

#9 2012-09-18 15:02:15

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

ab wrote:

how is the data in your db?
there should be an ID column in the table.

Yes, there is an ID in the .mdb table

ab wrote:

also please report the exact error message and code line.

there was now issue with jet on our tests about a missing column.

column ID is an integer, and you should use the corresponding create  instead of manual id=? query.

I'll check the code tomorrow..

D:\Bledec\Projects\BledecXEServer.exe 1.0.0.0 (2012-09-18 21:41:24)
Host=HANNY-NB User=Hanny Wibisono CPU=8*0-6-10759 OS=12.1=6.1.7601 Wow64=0 Freq=1948740
TSynLog 1.17 2012-09-18T21:43:04

20120918 21430448 EXC   ESQLite3Exception ("no such column: ID") at 0056B467  stack trace 00556B70 005E111A 005E066D 005DFE6C 00459999 004080C2 7784ED6C 77B9377B 77B9374E 
D:\Bledec\Projects\BledecXEServer.exe 1.0.0.0 (2012-09-18 21:41:24)
Host=HANNY-NB User=Hanny Wibisono CPU=8*0-6-10759 OS=12.1=6.1.7601 Wow64=0 Freq=1948740
TSynLog 1.17 2012-09-18T21:42:59

20120918 21425901 DB    CreateDatabase for "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TestMormot\Bledec.mdb;User Id=Admin;Password=;" returned 1
20120918 21425906  +    00569E85 
20120918 21425906  -    0056A2F5  00.000.811
20120918 21425906  +    TSQLDatabase(01E26A80).00569792 
20120918 21425906 SQL   	SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';
20120918 21425906  -    TSQLDatabase(01E26A80).00569809  00.000.631
20120918 21425906 debug TSQLDatabase(01E26A80) TableNames=[]
20120918 21425906  +    TSQLDatabase(01E26A80).00569684 
20120918 21425906 SQL   	BEGIN TRANSACTION;
20120918 21425906  -    TSQLDatabase(01E26A80).005696F4  00.000.017
20120918 21425906  +    TSQLDatabase(01E26A80).00569684 
20120918 21425906 SQL   	CREATE VIRTUAL TABLE Sys_UserProfile USING External(SiteID INTEGER, RoleID INTEGER, EmployeeID INTEGER, UserName TEXT COLLATE SYSTEMNOCASE, UserLogin TEXT COLLATE SYSTEMNOCASE, UserPassword TEXT COLLATE SYSTEMNOCASE, RecoveryEmail TEXT COLLATE SYSTEMNOCASE, NumOfLogin INTEGER, Deposit FLOAT, Notes TEXT COLLATE SYSTEMNOCASE, Status INTEGER, CreateDate TEXT COLLATE ISO8601, CreateUserID INTEGER, EditDate TEXT COLLATE ISO8601, EditUserID INTEGER, DataSource INTEGER);
20120918 21425906  +    	TOleDBConnection(01E26C78).006863E6 
20120918 21425906 info  		null
20120918 21425906  -    	TOleDBConnection(01E26C78).0068648F  00.000.008
20120918 21425906  +    	TOleDBConnection(01E26C78).00686140 
20120918 21425907  -    	TOleDBConnection(01E26C78).0068630D  00.005.815
20120918 21425907  +    	TOleDBStatement(01DC87D0).CreateAccessor
20120918 21425907  -    	TOleDBStatement(01DC87D0).CreateAccessor 00.000.026
20120918 21425907  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425907 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425907  -    	TOleDBStatement(01DC87D0).006857AF  00.000.007
20120918 21425907  +    	TOleDBStatement(01DC87D0).CreateAccessor
20120918 21425907  -    	TOleDBStatement(01DC87D0).CreateAccessor 00.000.014
20120918 21425907  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425907 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425907  -    	TOleDBStatement(01DC87D0).006857AF  00.000.005
20120918 21425907  +    	TOleDBStatement(01DC87D0).00684B1F 
20120918 21425907 SQL   		TOleDBStatement(01DC87D0) CREATE TABLE Sys_UserProfile (ID  Decimal(19,0) PRIMARY KEY, SiteID Decimal(19,0),RoleID Decimal(19,0),EmployeeID Decimal(19,0),UserName VarChar(20),UserLogin VarChar(20),UserPassword VarChar(32),RecoveryEmail VarChar(128),NumOfLogin Decimal(19,0),Deposit Currency,Notes LongText,Status Decimal(19,0),CreateDate DateTime,CreateUserID Decimal(19,0),EditDate DateTime,EditUserID Decimal(19,0),DataSource Decimal(19,0))
20120918 21425909  -    	TOleDBStatement(01DC87D0).006850BE  00.042.365
20120918 21425909  +    	TOleDBStatement(01DC88A0).CreateAccessor
20120918 21425910  -    	TOleDBStatement(01DC88A0).CreateAccessor 00.005.661
20120918 21425910  +    	TOleDBStatement(01DC88A0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC88A0) Total rows = 17
20120918 21425910  -    	TOleDBStatement(01DC88A0).006857AF  00.000.009
20120918 21425910  +    	TOleDBStatement(01DC88A0).CreateAccessor
20120918 21425910  -    	TOleDBStatement(01DC88A0).CreateAccessor 00.000.065
20120918 21425910  +    	TOleDBStatement(01DC88A0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC88A0) Total rows = 1
20120918 21425910  -    	TOleDBStatement(01DC88A0).006857AF  00.000.005
20120918 21425910  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425910  -    	TOleDBStatement(01DC87D0).006857AF  00.000.027
D:\Bledec\Projects\BledecXEServer.exe 1.0.0.0 (2012-09-18 21:41:24)
Host=HANNY-NB User=Hanny Wibisono CPU=8*0-6-10759 OS=12.1=6.1.7601 Wow64=0 Freq=1948740
TSynLog 1.17 2012-09-18T21:42:59

20120918 21425901 DB    CreateDatabase for "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TestMormot\Bledec.mdb;User Id=Admin;Password=;" returned 1
20120918 21425906  +    00569E85 
20120918 21425906  -    0056A2F5  00.000.811
20120918 21425906  +    TSQLDatabase(01E26A80).00569792 
20120918 21425906 SQL   	SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';
20120918 21425906  -    TSQLDatabase(01E26A80).00569809  00.000.631
20120918 21425906 debug TSQLDatabase(01E26A80) TableNames=[]
20120918 21425906  +    TSQLDatabase(01E26A80).00569684 
20120918 21425906 SQL   	BEGIN TRANSACTION;
20120918 21425906  -    TSQLDatabase(01E26A80).005696F4  00.000.017
20120918 21425906  +    TSQLDatabase(01E26A80).00569684 
20120918 21425906 SQL   	CREATE VIRTUAL TABLE Sys_UserProfile USING External(SiteID INTEGER, RoleID INTEGER, EmployeeID INTEGER, UserName TEXT COLLATE SYSTEMNOCASE, UserLogin TEXT COLLATE SYSTEMNOCASE, UserPassword TEXT COLLATE SYSTEMNOCASE, RecoveryEmail TEXT COLLATE SYSTEMNOCASE, NumOfLogin INTEGER, Deposit FLOAT, Notes TEXT COLLATE SYSTEMNOCASE, Status INTEGER, CreateDate TEXT COLLATE ISO8601, CreateUserID INTEGER, EditDate TEXT COLLATE ISO8601, EditUserID INTEGER, DataSource INTEGER);
20120918 21425906  +    	TOleDBConnection(01E26C78).006863E6 
20120918 21425906 info  		null
20120918 21425906  -    	TOleDBConnection(01E26C78).0068648F  00.000.008
20120918 21425906  +    	TOleDBConnection(01E26C78).00686140 
20120918 21425907  -    	TOleDBConnection(01E26C78).0068630D  00.005.815
20120918 21425907  +    	TOleDBStatement(01DC87D0).CreateAccessor
20120918 21425907  -    	TOleDBStatement(01DC87D0).CreateAccessor 00.000.026
20120918 21425907  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425907 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425907  -    	TOleDBStatement(01DC87D0).006857AF  00.000.007
20120918 21425907  +    	TOleDBStatement(01DC87D0).CreateAccessor
20120918 21425907  -    	TOleDBStatement(01DC87D0).CreateAccessor 00.000.014
20120918 21425907  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425907 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425907  -    	TOleDBStatement(01DC87D0).006857AF  00.000.005
20120918 21425907  +    	TOleDBStatement(01DC87D0).00684B1F 
20120918 21425907 SQL   		TOleDBStatement(01DC87D0) CREATE TABLE Sys_UserProfile (ID  Decimal(19,0) PRIMARY KEY, SiteID Decimal(19,0),RoleID Decimal(19,0),EmployeeID Decimal(19,0),UserName VarChar(20),UserLogin VarChar(20),UserPassword VarChar(32),RecoveryEmail VarChar(128),NumOfLogin Decimal(19,0),Deposit Currency,Notes LongText,Status Decimal(19,0),CreateDate DateTime,CreateUserID Decimal(19,0),EditDate DateTime,EditUserID Decimal(19,0),DataSource Decimal(19,0))
20120918 21425909  -    	TOleDBStatement(01DC87D0).006850BE  00.042.365
20120918 21425909  +    	TOleDBStatement(01DC88A0).CreateAccessor
20120918 21425910  -    	TOleDBStatement(01DC88A0).CreateAccessor 00.005.661
20120918 21425910  +    	TOleDBStatement(01DC88A0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC88A0) Total rows = 17
20120918 21425910  -    	TOleDBStatement(01DC88A0).006857AF  00.000.009
20120918 21425910  +    	TOleDBStatement(01DC88A0).CreateAccessor
20120918 21425910  -    	TOleDBStatement(01DC88A0).CreateAccessor 00.000.065
20120918 21425910  +    	TOleDBStatement(01DC88A0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC88A0) Total rows = 1
20120918 21425910  -    	TOleDBStatement(01DC88A0).006857AF  00.000.005
20120918 21425910  +    	TOleDBStatement(01DC87D0).00685729 
20120918 21425910 DB    		TOleDBStatement(01DC87D0) Total rows = 0
20120918 21425910  -    	TOleDBStatement(01DC87D0).006857AF  00.000.027
20120918 21425910  -    TSQLDatabase(01E26A80).005696F4  00.058.711
20120918 21425910  +    TSQLDatabase(01E26A80).00569684 
20120918 21425910 SQL   	CREATE TABLE AuthUser(ID INTEGER PRIMARY KEY AUTOINCREMENT, LogonName TEXT COLLATE SYSTEMNOCASE UNIQUE, DisplayName TEXT COLLATE SYSTEMNOCASE, PasswordHashHexa TEXT COLLATE SYSTEMNOCASE, GroupRights INTEGER, Data BLOB);
20120918 21425910  -    TSQLDatabase(01E26A80).005696F4  00.000.552
20120918 21425910  +    TSQLDatabase(01E26A80).00569684 
20120918 21425910 SQL   	CREATE TABLE AuthGroup(ID INTEGER PRIMARY KEY AUTOINCREMENT, Ident TEXT COLLATE SYSTEMNOCASE UNIQUE, SessionTimeout INTEGER, AccessRights TEXT COLLATE SYSTEMNOCASE);
20120918 21425910  -    TSQLDatabase(01E26A80).005696F4  00.000.308
20120918 21425910  +    TSQLDatabase(01E26A80).005695BC 
20120918 21425910 SQL   	CREATE INDEX IF NOT EXISTS IndexAuthUserGroupRights ON AuthUser(GroupRights);
20120918 21425910  -    TSQLDatabase(01E26A80).0056962E  00.000.196
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (:('Admin'):,:(10):,:('11,1,2,3,4,5,6,7,8,9,10,11,12,... cut ... ,253,254,255,256,0'):); prepared as INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (?,?,?); with 3 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=1
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (:('Supervisor'):,:(60):,:('10,1,2,3,4,5,6,7,8,9,10,11,12,... cut ... ,,254,255,256,0'):); prepared as INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (?,?,?); with 3 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=2
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (:('User'):,:(60):,:('10,1,4,5,6,7,8,9,10,11,12... cut ... ,,254,255,256,0'):); prepared as INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (?,?,?); with 3 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=3
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (:('Guest'):,:(60):,:('0,1,4,5,6,7,8,9,10,11,12,... cut ... ,,254,255,256,0,,,'):); prepared as INSERT INTO AuthGroup (Ident,SessionTimeout,AccessRights) VALUES (?,?,?); with 3 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=4
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (:('Admin'):,:('Admin'):,:('67aeea294e1cb515236fd7829c55ec820ef888e8e221814d24d83b3dc4d825dd'):,:(1):); prepared as INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (?,?,?,?); with 4 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=1
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (:('Supervisor'):,:('Supervisor'):,:('67aeea294e1cb515236fd7829c55ec820ef888e8e221814d24d83b3dc4d825dd'):,:(2):); prepared as INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (?,?,?,?); with 4 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=2
20120918 21425910 SQL   TSQLRestServerDB(01D445C0) INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (:('User'):,:('User'):,:('67aeea294e1cb515236fd7829c55ec820ef888e8e221814d24d83b3dc4d825dd'):,:(3):); prepared as INSERT INTO AuthUser (LogonName,DisplayName,PasswordHashHexa,GroupRights) VALUES (?,?,?,?); with 4 param
20120918 21425910 DB    TSQLDatabase(01E26A80) LastInsertRowID=3
20120918 21425910  +    TSQLDatabase(01E26A80).00569684 
20120918 21425910 SQL   	COMMIT TRANSACTION;
20120918 21425910  -    TSQLDatabase(01E26A80).005696F4  00.007.085
20120918 21425910  +    TOleDBStatement(01DC8CB0).00684B1F 
20120918 21425910 SQL   	TOleDBStatement(01DC8CB0) CREATE UNIQUE INDEX IX_SYS_USERPROFILE_USERLOGIN ON Sys_UserProfile(USERLOGIN)
20120918 21425910  -    TOleDBStatement(01DC8CB0).006850BE  00.001.054
20120918 21425910  +    TOleDBStatement(01DC8CB0).00685729 
20120918 21425910 DB    	TOleDBStatement(01DC8CB0) Total rows = 0
20120918 21425910  -    TOleDBStatement(01DC8CB0).006857AF  00.000.028
20120918 21430319 cache TSQLDatabase(01E26A80) not in cache
20120918 21430319 SQL   TSQLRestServerDB(01D445C0) SELECT ID,LogonName,DisplayName,PasswordHashHexa,GroupRights FROM AuthUser WHERE LogonName=:('User'): LIMIT 1; prepared as SELECT ID,LogonName,DisplayName,PasswordHashHexa,GroupRights FROM AuthUser WHERE LogonName=? LIMIT 1; with 1 param
20120918 21430319 res   TSQLDatabase(01E26A80) [{"ID":3,"LogonName":"User","DisplayName":"User","PasswordHashHexa":"67aeea294e1cb515236fd7829c55ec820ef888e8e221814d24d83b3dc4d825dd","GroupRights":3}] 
20120918 21430319 cache TSQLDatabase(01E26A80) not in cache
20120918 21430319 SQL   TSQLRestServerDB(01D445C0) SELECT * FROM AuthGroup WHERE RowID=:(3):; prepared as SELECT * FROM AuthGroup WHERE RowID=?; with 1 param
20120918 21430319 res   TSQLDatabase(01E26A80) [{"ID":3,"Ident":"User","SessionTimeout":60,"AccessRights":"10,1,4,5,6,7,8,9,10,11,12,... cut ... ,,254,255,256,0"}] 
20120918 21430448 cache TSQLDatabase(01E26A80) not in cache
20120918 21430448 SQL   TSQLRestServerDB(01D445C0) SELECT * FROM Sys_UserProfile WHERE ID=:('1'): LIMIT 1; prepared as SELECT * FROM Sys_UserProfile WHERE ID=? LIMIT 1; with 1 param
20120918 21430448 res   null
20120918 21431300  +    00569D83 
20120918 21431300  -    00569E0F  00.005.699
20120918 21431300 ERROR Missing TOleDBConnection.Destroy call = 1 stack trace API 005404B0 00687E63 00407BE0 00407FAA 7784ED6C 77B9377B 77B9374E

Last edited by wienani (2012-09-18 15:05:20)

Offline

#10 2012-09-18 15:46:46

wienani
Member
Registered: 2012-08-31
Posts: 29

Re: ID always return 0 (using SynDBFIBPlus.. :D)

Hi Arnaud,

After upgrade to 1.18, No such Column:ID error is gone now. But using my SynDBFIBPlus still error No such Column:ID. But at least i have reference now. Thx you.

Offline

Pages: 1

Board footer

Powered by FluxBB