Talk:SqlDBHowto
Prepare
Thanks for the recent edits, but:
- We are talking about the db server parsing/preparing the query, not so much (or at all) sqldb.
- IIRC, the server prepares at first run if .Prepare hasn't been called manually. Please indicate the relevant sqldb code if that's not the case
- Unprepare should be called by .close. If that is not done, it's a bug.
- If a db server does not support parameters, sqldb will emulate them. So no need to go into which dbs support what
Thanks, --BigChimp 10:26, 24 October 2014 (CEST)
Updates to Example Code
Mid 2017 I noticed that several (so far) of the example codes seem to contain substantial errors. I suspect they were written without being tested, perhaps should be regarded as pseudo code ? I am updating them, one by one, each should be compilable under FPC or as a console app from within Lazarus. I have taken the liberty of changing the database used in the examples to sqlite3 rather than IB. Thats because I have an install of SQLite3 and, perhaps, consider it likely that the average new user will find SQLite3 easier to install and manage than IB. IB (or other "server based" databases) will require the Connection be told about hostname, user name and password.
CreateTable - earlier in 2017
ShowTable - June 26 2017
EditData - June 27 2017
Added a section about handling Run Time Errors
Hope I have not offended anyone, my intention is to make sure a reader sees compilable, runable code. Think thats important.