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>!
Error message - NOT an error??
Re: Error message - NOT an error??
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.
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.