>Hi all!
>I was wondering if anyone knows how to debug VFP Stored procedures in a Client\Server environment? I'm using VFP as a "backend" database.
>We are in process of converting our VFP5.0 app to Client\Server, where
>clients have a choice of using Oracle or VFP as a backend. As a file
>server system, the VFP stored procedure worked fine. I also could use
>the standard VFP debugger to debug the code. Now when executing the
>procedure on the Database server, Im getting an ODBC error "Command not supported"... however I have no idea which command that is! ANy help would be appreciated.
>
>Thanks in Advance
The Visual FoxPro ODBC Driver Help file has a list of commands that are not supported by the driver. Browse that to see if your stored procs have commands that are on the list.
Ryan Hirschey