Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor adapter with Oracla table
Message
 
To
19/05/2004 11:02:21
Peter de Moel
Omnisys Automatisering
Hoevelaken, Netherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00905287
Message ID:
00905388
Views:
19
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.
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform