>Hmmm... Now that's interesting. I didn't know you could do that. I'm wondering if this would work when using SQL in combo boxes. I always hated having to send it to a temp cursor that I had to worry about cleaning up. I'll try that sometime. Good trick, if it works. :)
It works, since it was taken from one of our classes :)
But I would not use it in comboboxes. This was used to check field for uniqueness, so we only want to check, if this SQL produces records (_Tally) and result is not needed.
>
>Thanks,
>
>Michelle
>
>>
select * from (lcAlias) ;
>> where &lcfield == lcvalue to screen noconsole
If it's not broken, fix it until it is.
My Blog