Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Urgent Need for Help
Message
 
 
To
10/06/2002 08:52:54
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00666478
Message ID:
00666626
Views:
17
>I am attempting to update an ACCESS table. When I try to close the table I get error 1492 - "No key columns are specified for the update table "setups". Use the KeyFieldList property of the cursor." even though with the debugger open GetCursorProperty(KeyfieldList,ttable)shows that I have set a key field and the field is actually a key field in the access table. Something else is happening. Can anyone tell me whats going on? Thanks. This project is due today.

In case there was a typo above, what do you get from the following:
CursorGetProp('KeyfieldList', tTable)

CursorGetProp('UpdatableFieldList', tTable)
    && should have list of all field names to update

CursorGetProp('UpdateType', tTable)  && should be 1

CursorGetProp('SendUpdates', tTable) && should be .T.
Do any field names have spaces in them? If so this could be a problem. Wrap them in full quotes.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform