Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Reymundo,
Are you using a Remote View or SQL Pass through(SPT)?
I am assuming from below that you are using a Remote View.
In order for your changes to be saved in the Oracle table you must make the view updatable.
See the help file on the CURSORSETPROP() function. If you set the following properties you should be able to control the updates with the TABLEUPDATE() and TABLEREVERT() functions.
Properties:
Buffering,KeyFieldList,SendUpdates,UpdatableFieldList,UpdateNameList
Matt
>Dear All,
>
>Good Day!..
>
>I am trying to make an experiment regarding how to access oracle database
>via remote connection in VFP. i can now access the tables which was created in
>Oracle 8i, i can now browse and even change the content of the table, but my
>problem is all the changes i made is not reflecting in oracle database.
>
>i uses this command do i need to commit the work? what is the VFP SYNTAX FOR
>commiting the changes made in VFP BROWSE OR UPDATE STATEMENT
>
>UPDATE customer_master_data SET customer_master_data.NAME = [REYMUND] WHERE customer_code =[0000000084]
>
>
>Thanks in advance to all
>
>
>Best Regards
>Reymund
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement