Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'mycursor' must be created with SELECT...INTO TABLE
Message
From
12/10/2001 07:58:39
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/10/2001 13:23:18
Martin Thibault
Minière Québec Cartier
Port-Cartier, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00567104
Message ID:
00567494
Views:
14
>Look this code!!!
>
>select * from mytable into cursor mycursor
>select * from mycursor into cursor mycursor2
>
>VFP return error message 'mycursor' must be created with SELECT...INTO TABLE
>
>I know if i use NOFILTER in my select - sql, the problem will be resolve!!!
>
>But i always use this syntax without problem, and since this morning i got an error message!!!
>
>I would like to know, why now this syntax does not works!!!
>
>Thanks!!!
>Martin

In my experience, you have no warranty that if the SELECT implicitly applies NOFILTER one time, it will do so every time. I had several cases of a series of SELECTs suddenly failing. Just go the safe way, and always use NOFILTER on the first SELECT.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform