mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

Error SQLITE_ERROR (1) no such column: ID

I get this error using CreateAndFillPrepare without providing FieldCSV

The Query executed on Server is like select ID, f1, f1, ... where f1=? on Server.

The mysterous thing is: there is a column id in the table. If i execute the Query (copied from debugger) in SynDBExplorer it works ?!

As Workaround i provided the needed Fields.

I think there is something wrong with RowID and ID.

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,664

Website

Re: Error SQLITE_ERROR (1) no such column: ID

I am not able to reproduce the issue.

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

Re: Error SQLITE_ERROR (1) no such column: ID

I'll try to make a sample

---

Rad Studio 12.1 Santorini