[fpc-devel] odbcconn.pas
LacaK
lacak at zoznam.sk
Thu Mar 13 14:55:16 CET 2014
Nathan Wild wrote / napĂsal(a):
>
> I have been transitioning my work over from Delphi to Lazarus. For
> the most part it has been smooth and satisfying experience. I'm
> loving Lazarus and FPC and being unburdened by closed source
> proprietary stuff in general.
>
> The majority of the work I do requires connections to a Pervasive
> database (from Btrieve v6 all the way up to the most current). I
> should be able to do this via ODBC. I have no problem reading data,
> executing queries, etc. but as soon I try and act on a TSQLQuery using
> methods like .Delete(), .Append(), etc. everything appears to work
> fine, but as soon as the dataset refreshes my changes disappear. I
> can write to the same tables using INSERT, DELETE and UPDATE queries
> without issue.
Do you use TSQLQuery.ApplyUpdates followed by TSQLTransaction.Commit or
CommitRetaining ?
-lacak.
More information about the fpc-devel
mailing list