Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Neil Shumsky
  Where is Neil Shumsky?
 United Kingdom
 Neil Shumsky
Subject: Error 1815 "cursor" must be created with SELECT ..
Thread ID: 15812 Message ID: 15812 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, October 01, 2002 6:11:50 PM         

My problem is that my testing was done in a VFP app, but having rolled out the exe I get error 1815 "cursor" must be created with SELECT ... INTO TABLE which doesn't occur when run in the app.

Sample code:

SELECT * from Table1 WHERE Field1 = Table2.Field1 INTO CURSOR _Cursor1
SELECT A.* from Table3 A, _Cursor1 B WHERE A.Field2 = B.Field2 INTO CURSOR _Cursor2

The second line triggers the error

I can't use SELECT INTO TABLE in the first line as I have field names > 10 characters so unless I create a temporary database for line one and add the table to that is there any other way I can run line 2? I've checked the VFP7 service pack 1 readme. This error does occut in VFP6 apps.

Neil Shumsky


Error 1815 "cursor" must be created with SELECT .. Posted by Neil Shumsky @ 10/1/2002 6:11:50 PM
RE: Error 1815 "cursor" must be creat... Posted by Yuri Rubinov @ 10/1/2002 6:22:48 PM