>I am using SQL passthtrough to retrieve records via the sqlexec command
>is there a way to limit the number of records returned... i.e. the first 5 for example.
>
>I am only pulling them to view the data to make a decision on whether to pull all of the data...
>
>User doesn't want to wait for the full table to come across the network...
>
>Some tables have millions of records!
>
>Only need a few to help decide if they want all of them...
>
>Mike
Select count(*) from MyTable where myCondition.
Then present the dialog to the user if the number is too big.
If it's not broken, fix it until it is.
My Blog