>I have a VFP program that connects to my AS400, retrieves records from a file & copies them into a VFP table. I would like to use a code in my AS400 file to determine whether the record should be added to the VFP table. Is there a way to update the AS400 file from VFP? If not, is there a way to run a VFP program from the AS400?
>
>TIA for any suggestions! :)

You can use an updateable view as with any remote data source. You can also use the SQL Update command when using the SQL passthrough approach.

Regards,
Mike