Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Making Pass-Through cursor updateable

Status
Not open for further replies.
daleoclarke

daleoclarke

Programmer
Oct 22, 2002
6
0
0
JM
I NEED HELP. I'm at the end of my rope.

I used SQLEXEC() to return results from SQL Server 7 with hope of making the result set updateable.

Keep gettting the error "No update tables are specified. use the Tables property of the cursor".

I'm using VFP 7

CURSORSETPROP("Buffering" ,3,"test")
CURSORSETPROP("tables" ,"dept","test")
CURSORSETPROP("KeyFieldList","Id","Test")
CURSORSETPROP("Updatefields","dpt_code,dpt_name","test")
CURSORSETPROP("SendUpdates",.t.,'test')

What am I doing wrong. HELP!! Anybody
 
Status
Not open for further replies.

Similar threads

D-Ward
  • Question
Cursor Adapter
Replies
7
Views
435
D-Ward
D-Ward
vaxman9
  • Question
Treeview OleDragDrop changing mouse cursor
Replies
7
Views
252
vaxman9
vaxman9
SitesMasstec
  • Question
Does a Report use the available cursor? 6
Replies
15
Views
280
EinTerraner
EinTerraner
SitesMasstec
  • Locked
  • Question
Cursor with categories and quantity of each category 2
Replies
11
Views
255
Chris Miller
Chris Miller
Filip Brnic
  • Question
Importing XML data into a cursor inside a form
Replies
7
Views
192
tomk3
tomk3

Part and Inventory Search

Sponsor

Back
Top