>Nevermind, found the NOCONSOLE keyword...
>My code works:
>
>
>lctable = sys(2015)+SYS(3)
>SELECT formfield AS formfield,;
> LEFT(profiler,100) AS profiler;
> FROM acordict WHERE !EMPTY(formfield);
> INTO TABLE (lctable) ORDER BY formfield
>
>
>However that pesky sql results window opens up in the background behind the form and I've forgotten how to prevent that. Any ideas?
>
>TIA,
>Tracy
Hi Tracy,
Well I'd say include a destination clause (into ...) but you already did and saying it shows up stumped me :)
NOCONSOLE ??? What for ?
You confused me :)
1) Why a random generated name ?
2) Why a table - particularly when it's a table and not a cursor ?
3) Why not directly single RowSource='select.... into cursor crsCursorName'
Cetin