[fpc-devel] odbcconn.pas

[Reinier Olislagers]

On 13/03/2014 00:06, Nathan Wild wrote:
> 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.
Good to hear that ;)

> 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.
> 
> Am I missing something stupid?
We don't know your code, so no idea... <open door> Are you .Posting the
data?

To give you an idea, the GUI/RAD tutorials
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial0
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial1
and
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial2
should work with odbc as well as with other dbs; just use odbcconn..

Also, you could have a look at the database test suite:
http://wiki.lazarus.freepascal.org/Databases#Running_FPC_database_tests
fpc\packages\fcl-db\tests\dbtestframework.pas

The info on
http://wiki.lazarus.freepascal.org/ODBCConn
you probably already know about as you can connect etc.
Please feel free to document any hints/tips/needed additions for
Pervasive there...

You could create a minimal test program based on
http://wiki.lazarus.freepascal.org/Database_bug_reporting#FreePascal
and post on the forum
http://forum.lazarus.freepascal.org/index.php/board,63.0.html
with an attachment.