Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Table Update via VFP
Message
 
 
To
24/01/2002 21:48:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00610261
Message ID:
00610286
Views:
16
This message has been marked as the solution to the initial question of the thread.
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform