General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Alex.
>
>>A table for an accounting program that uses Pervasive as the database engine has become corrupt. I need to delete a record and change others and wonder how to do it.
>>
>>I'd like to use SQL passthrough to make the changes but don't know how to go about it. For reporting purposes I have created remote read-only views into the database so I have the basic infrastructure to connect to Pervasive from VFP.
>
>You can use a remote view that writes to the database to delete/update the table. Alternatively, you can use SQL passthrough commands. First, connect to the Pervasive DSN using SQLCONNECT(). Then, use SQLEXEC() to send SQL DELETE and UPDATE commands to Pervasive.
>
>Doug
Thanks Doug.
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only