General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only