Brian,
You might not use nofilter with other db however there is another way to force a true cursor creation. Either there is a nonexistant field (ie: lastname+firstname as name) or an expression in where. As in :
select * from myTable where .t. into cursor myCursor
Cetin
>Well, I never use the nofilter clause, so I guess I don't know.
>
>If the nofilter clause is used, will the SQL Select statement be valid when calling data from another db other than FoxPro?
>
>- Brian
>
>>
>>Brian,
>>When you don't have a true cursor (nofilter clause) SQL might simply set a filter on records (with ANSI on or off). Was that what you mean ?
>>Cetin