General information
Title:
Cursor adapter with Oracla table
I have a oracle-table "IND" with the following fields :
dom VARCHAR2 (6)
cod VARCHAR2 (6)
oms VARCHAR2 (70)
"dom"+"cod" is the Primary key
Then I made a form with a cursor adapter in the DE with the following properties (the cursor adapter class is made by the McCasland-CA generator tool) :
alias CRSIND
cursorscheme DOM C(6), COD C(6), OMS C(70)
key fieldlist DOM, COD
tables IND
tag DSN=test_ananas; UID=abcd; PWD=abcd; SERVER=test_ananas
updatableFieldList OMS
updatableNameList OMS
usedatasource .F.
cselectcmdfilter DOM='GEM'
In the form I made a command-button with the following command-lines :
SELECT crsind
BROWSE
= TABLEUPDATE(.T.)
When I made an update in the field OMS in the BROWSE-screen, and I close and open again the form then I notice that the update is not executed.
What did I wrong ??
Thanks in advance.
Peter.
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