>HI...
>I want to get the number of records from a query eg...
>SQLEXEC(h,'select * from styles')
>
>How can I see the number of rows it will retrieve without
>actually fetching the rows.
>
>I know I can use selec count(*) from styles
>
>But it's an extra query.
>
>I need this because if a user sets a filter that returns a large number of values I want to give a warning
>because of performance reasons.
>
>What's the most effiecient way to do this...
SELECT COUNT(*) using the same where clause, etc., is the only way to determine this.
Mark McCasland
Midlothian, TX USA