>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