Talk:SqlDBHowto

From Lazarus wiki
Revision as of 12:51, 27 June 2017 by Dbannon (talk | contribs) (Added an explanation of what I've been doing to main page.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

--Dbannon (talk) 13:48, 26 June 2017 (CEST)