>Can I stop an SELECT SQL sentece ?
>Would you help me with this ?
>Thanks
I think you would temporarily SET ESCAPE ON. Then, the user can interrupt with ESC. I am not sure exactly how to check whether the user pressed ESC or not, and this is an important detail.
You could also try to optimize your queries. For instance, dividing a 9-table SELECT (for a report) into several commands reduced the time over a network from 50 seconds, to 2 seconds.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)