Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and Oracle Tables
Message
 
To
15/09/2006 11:32:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Oracle
Miscellaneous
Thread ID:
01154130
Message ID:
01154147
Views:
9
?
Can you post the code where you updating CA?

>TABLEUPDATE(.t., .t.) results in .T.
>AERROR(a_Error) results is 0 (no error)
>
>Executing the code again shows that the record has not been updated.
>
>
>
>>>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?
>>
>>And what is the result of TableUpdate?
>>And if it is .f. what AERROR() gives you as info?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform