Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Neil Shumsky
  Where is Neil Shumsky?
 LEEDS
 United Kingdom
 Neil Shumsky
 Tags
Subject: RE: Error 1815 "cursor" must be creat...
Thread ID: 15812 Message ID: 15817 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, October 01, 2002 6:22:48 PM         
   


Use this:
SELECT * from Table1 WHERE Field1 = Table2.Field1 INTO CURSOR _Cursor1 NOFILTER
In VFP7 you also can use:
SELECT * from Table1 WHERE Field1 = Table2.Field1 INTO CURSOR _Cursor1 readwrite


> 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


ENTIRE THREAD

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