Hi Kevin ----

OIC --- I thought you were trying to break out of the >middle< of an SQL statement. Hey, why not write up a FAQ and post it here on the UT for others who may be grapling with this same issue?


>I appreciate the offer! Unfortunately I think First Union would frown on me sending customer info out as a test file (even if I did blank name info,etc.)
>
>I do try to make my SELECTs as fast as possible but we pull reports off tables with 1/2 a million+ records in each, so this is something that is important to us.
>
>I actually have come up with a solution for my application.
>
>In the click event
>
>lnnowwhat=messagebox("Are You Sure You Want To Cancel?"+chr(13) ;
> +" Report Creation Will Terminate",36,"Abort Update?")
>if lnnowwhat = 6
> go_on = .f.
>else
> retry
>endif
>
>then I wrap the rest of the report generation code after the SELECT with an IF statement
>
>IF go_on
> repo form blah
>ENDIF
>
>Granted this is not the most OO way to do it but hey it WORKS GREAT!!!
>
>Thanks for your input!!