SQLite - Library used incorrectly error

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

SQLite - Library used incorrectly error

Post by ertank » Tue 11 Oct 2016 18:40

Hi,

Using Delphi 10.1 Update 1 Starter Edition, UniDAC 6.4.14,
Database is SQLite, Direct set to True, and encrypted.

I was trying some SQL results in a UniQuery in my system. In order to not to forget them, I use MSSQL style remarks (double dash at the beginning of the line "--")

After a while I started to get error saying "Library used incorrectly"

Problem is, running same query with all remarks and everything on DB Browser for SQLite application has no errors. However, DB Browser for SQLite has a remark at the bottom saying "not an error" and listing some of the remarks in the SQL executed.

I have prepared a small sample project in below link for your convenience. Database with some sample records is included in the sample. You can just click on Run Query button.

Link: library_used_incorrectly.rar

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: SQLite - Library used incorrectly error

Post by MaximG » Thu 13 Oct 2016 13:04

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Post Reply