Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't update Oracle date field via remote vfp view
Message
 
 
To
07/05/2001 18:01:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00504461
Message ID:
00504699
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform