Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>>>>>>NOFILTER is a must in your situation because you're selecting all the columns and using a where condition. It may result in the filtered result.
>>>>>
>>>>>Sorry, but you're wrong.
>>>>
>>>>What do you mean? You mean it's not possible the above query will result in the filtered set?
>>>
>>>The query may give a filtered record set, but so what? The "copy to" command will respect the automatically created filter.
>>
>>That I know. But it still better to avoid filtered set.
>
>Depending on what you need the cursor for. In this particular case a filtered record set will work just fine.
Sorry Tore, but I'm going to disagree with you. It may work just fine - the danger is that the developer may want to include a record count in the excel. If it is a filtered set, then using RECCOUNT() will report the unfiltered count of the base table. That little distinction is the kind of thing that causes errors.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement