>>
>>"cursor" must be created with SELECT ... INTO TABLE (Error 1815)
>>You have tried to use a repackaged cursor as a source for another SELECT statement.
>>
>>Some cursors cannot be used in successive queries.
>>Use the INTO TABLE clause of the SELECT - SQL statement instead.
>>
>>***
>>
>>Interesting error, it would be nice to know the definition of 'Some cursors', I wonder what are the ones that can have successive queries.
>
>Brett, what you've got is a "filtered view" of the original table. You should add NOFILTER to the SELECT command to get a real cursor.
>
>To determine if the cursor from a SELECT is a filtered view or not, you can use the DBF() command on the alias andd see if it ends in .TMP or not. If it ends in .DBF, it's a filtered view of the original table and can't be used in additional SELECTs.
Thanks for the info, I have been following the thread closely as I have been bit by the Filtered cursor a few times. My only suggestion is to MS that they define the 'Some Cursors' statement a little better in their help file.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope