Page 1 of 1
SQLite3 RowID not visible to Zeos?
Posted: 15.02.2017, 18:54
by ToodleDoo
Hi,
For a variety of reasons I cannot use an AutoInc field so want to use the inbuilt RowID of SQLite as I need a unique Record-identifier.
I tried using tblLocate('RowID',aRowID,[]); but it returns an error and crashes.
How can I use that RowID?
Re: SQLite3 RowID not visible to Zeos?
Posted: 15.02.2017, 21:18
by miab3
@ToodleDoo,
select rowid,* from table
Michal
Re: SQLite3 RowID not visible to Zeos?
Posted: 15.02.2017, 22:21
by ToodleDoo
miab3 wrote:select rowid,* from table
Thanks, but I am converting some Delphi stuff over and it was all written using Dataware and almost no real SQL stuff. I'd have to rewrite tons of stuff.
Doing it free for a friend so do not wan to spend a several days on it.
Re: SQLite3 RowID not visible to Zeos?
Posted: 16.02.2017, 00:22
by marsupilami
Hello ToodleDoo,
as far as I know the RowID column is a more or less hidden column that you only can get access to by explicitly selecting it. Zeos will not automatically change your SQL for you. So either you find some option in sqlite to enable returning RowID at all times or you live without RowID or you modify your code to explicitly select it when you need it.
Best regards,
Jan