>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,
How are you retrieving the data from Oracle? If via SQL Pass-thru, then check out MSKB#
Q138094. If using remote views, check of the SendUpdates checkbox and see if the updates actually getting sent back when you issue a TableUpdate().
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao