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