>>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. :)
>
BTW, why do you have to worry about cursors? They would be closed automatically, if form uses private DS.
>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