SQLite3 RowID not visible to Zeos?

[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?

[miab3]

@ToodleDoo,

select rowid,* from table

Michal

[ToodleDoo]

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.

[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