Hi Peter,
Change type fields dom and cod from VARCHAR2 to CHAR
MartinJ
>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.