Has there been a change to the Oracle table since you created the remote view? If so, you have to
validate your remote view. The easiest way is using a tool like Stonefield Database Toolkit. If you do not use that, DO HOME() + "tools\gendbc\gendbc" will create a PRG file with all the code needed to recreate your database and all its objects.
After you create that PRG, open it and look for the code that generates that RV. Copy and paste that code into a separate PRG file. Tweak that code and run it to keep your RV up to date.
>Does anyone had problems updating an Oracle date/time field via a vfp date field via a remote view. When I issue a tableupdate command I get a connectivity error - invalid column name, but the column name is correct.
>
>Then the only way out is to use task manager to kill the fox.
>
>Env: vfp 6.0 on NT 4.0
>
>Anyone have any ideas?
>
>Thanks.
>
>Keith
Mark McCasland
Midlothian, TX USA