Error message - NOT an error??

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jft
Posts: 7
Joined: Wed 08 Nov 2006 03:22

Error message - NOT an error??

Post by jft » Sun 20 Jan 2013 13:42

An interesting feature - an error message to tell you that you have NOT made an error?
To set up your database (SQLite3 in this case & UniDAC version 4.1.4), build a script holding all your table create statements, terminated with semi-colons as required. To make it easier for you to read the script yourself, make a dividing line of repeated "-" characters (as its a comment in SQLite3) and copy this dividing line between each table definition and also at the start and end of your script.
Test this by running it through the command line SQLite3.exe application - it should work without a problem.

Create a new VCL application, add a data module and to that add a TUniConnection component, a TSQLiteUniProvider component and a TUniScript component & hook them up to each other and the database. Double-click on the UniScript1 component and load your script into the SQL tab. Then, in code, run the DataModule1.UniConnection1.Open and DataModule1.UniScript1.Execute statements.

Your script will run, all the "comment" dividing lines will be ignored (as they should) and all the tables will be created. But if the last line of your script is one of these dividing lines, you will also get a DialogMsg type error box, complete with a bold red button with a white cross on it and the intrigueing message <quote> not an error </quote>!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error message - NOT an error??

Post by AlexP » Mon 21 Jan 2013 11:02

Hello,

We cannot reproduce the problem on the latest UniDAC version 4.6.11. Please try installing this UniDAC version and reproduce the problem once more. If the problem can be reproduced, please send us the script causing the problem.

Post Reply