Prof. Paulo Amaral wrote:
The problem is that these examples use "select" for ends of exhibition
and navigation of data in forms with dbedits, dbnavigator, etc. The
"update" or "insert" use with DbAware controls does not have example
showing. When you edit and write a register using dbnavigator,
datasource, it is written in the ram memory (in cache). However, for
example, in the Delphi, using TClienteDataset, you write (commit) with
"applyupdates" in the event "afterpost", so that cache is recorded in
database. Using Sqldb components (TPQConnection, TSQLQuery,
TSQLTransaction) I can't make this. However, I saw in web forum the
following example:
"begin
{ The SQLQuery in Lazarus does work with parameters yet, so }
{ we build the SQL statement completely. }
Parameter support is available in at least some of the sqldb components. I
implemented it in odbcconn, and it was already implemented in IB and PQ iirc.
The SQL parser that scans for parameter markers in the query which I built for
odbcconn was moved to TParams.ParseSQL by Joost (see e.g.
http://www.freepascal.org/cgi-bin/viewcvs.cgi/trunk/fcl/db/dsparams.inc?rev=1656&view=log).
It supports :ParamName and ? type parameters. Database components should use
TParams.ParseSQL, so the parsing is kept centralised.
Note: ODBCConn currently lacks support for BLOBs, hence string fields are
limited (i.e. truncated) to db.dsMaxStringSize = 8192;
Note2: currently the latter can cause a crash when a varchar field contains
more than 8192 characters; a patch will be available soon.
Regards,
Bram
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
