Best way to access Pervasive DB from Delphi 7 ?

[pederalm]

We have a Pervasive 8.10 enginee database and I would like to access the database with sql commands like "INSERT INTO" from Delphi 7.

I have tried the PDAC, but I can only access with the "SELECT * from..." command. Can I use the PDAC at all if I want to use the "INSERT INTO" command?

Help!

 

[mirtheil]

PDAC can issue an INSERT SQL statement. You'll need to use PvQuery to issue SQL statements. If you're using PvTable, I think it's a Post. If it's not working, post your code and the error or behavior you are seeing.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[pederalm]

Sweet it worked:

PvTable1.Append;
PvTable1.FieldValues['...'] := ...;
...
...
PvTable1.Post;