Hi Cetin,

The NONCONSOLE stopped the display of the query results to the screen in the background. It doesn't occur on any other SELECT statements in other apps so I am not sure why it did on this one. This is a small in-house app to be used by developers and our help-desk to streamline the creation of insurance pdf forms, pdf form fields, and populating the pdf forms. The forms are later created on the fly and populated with data from our app programmatically during runtime. There are a few steps to go through during development time (adding the fields to the pdf form, storing the pdf form in a memo field in a file, mapping the form fields to our app's variables, etc) and since there will be over 400 forms that must be created we are planning on the helpdesk personnel participating in the process and they are not deveopers so we are automating the process. I have not put in all of the environment settings we typically include in our distributed apps so that may have something to do with it ocurring to begin with too.

I was selecting into a table because the table is used for other reasons outside the form and I wanted it available before, during, and after the form. I also wanted it to remain afterwards for testing purposes, but I have since changed it to a cursor instead which suits my purposes fine.


Tracy

>>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