[fpc-devel] odbcconn.pas

[Tomas Hajny]

On Thu, March 13, 2014 11:25, Reinier Olislagers wrote:
> On 13/03/2014 00:06, Nathan Wild wrote:

Please note that the original poster is not subscribed to the mailing list
and thus may not see your responses (like the one below) unless including
him in Cc: explicitly. Unfortunately, he hasn't mentioned this fact in his
post...

Tomas



>> 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.