Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and Oracle Tables
Message
From
15/09/2006 11:16:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
CursorAdapter and Oracle Tables
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Oracle
Miscellaneous
Thread ID:
01154130
Message ID:
01154130
Views:
64
I have a cursoradapter that connects to my Oracle datasource and pulls the data into a cursor in a private data session. This part works fine. For some reason, it will not update the tables in Oracle.

I have assigned the following properties in the INIT of the cursoradapter:

Tables
KeyFieldList
UpdatableFieldList
UpdateNameList

SendUpdates, Allow... = .T.
UseDeDataSource = .T.

I supply the data environment object. The data environment object connects to the datasource perfectly.

DataSource = ODBC
Connection is a valid connection string...

I have tested my cursoradapter object with VFP tables and it works fine; the fields update properly in the source table.

Where am I going wrong?
Gordon de Rouyan
DC&G Consulting
Edmonton, Alberta
Email: derouyag@shaw.ca
Next
Reply
Map
View

Click here to load this message in the networking platform