Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC returning -1 when creating cursor
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00792371
Message ID:
00792464
Views:
21
>Thanks, I figured it out, I had to make backend read/write.
>
>Nick

Nick,

Also it is not necessary to create unique names for the cursors using sys(2015). Cursors are always local to the machine and they are guaranteed to have unique names in the network.
lcSQL = "SELECT * FROM Whatever"

SQLExec(LnHanlde,lcSQL,"MyCursor")
will create a cursor with the local alias of MyCursor however if you check DBF("MyCursor") you will find that, in fact, the file name is something totally unique like 000F809FC.dbf or the like.

You can use meaningful names for you cursors in your code and you don;t need the sys(2015) stuff at all.
Previous
Reply
Map
View

Click here to load this message in the networking platform