Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't update Oracle date field via remote vfp view
Message
 
 
À
07/05/2001 18:01:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00504461
Message ID:
00504699
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform