>>Does it work if you remove the:
>>
>>WHERE Product = ?Parm1
>>
>>clause?
>
>
>Yes it Works, i just found the solution to the Top Clause, in Q260526 It describes the problem if SQL Server 7.0 database is set to 6.5 Compatibility The TOP clause is not supported.
>
>Thanks, it all woks with the TOP Clause now !!
Thanks for the heads up on the knowledge base article.
Chris McCandless
Red Sky Software