Since this is not updatable, SQL pass thru will be faster. Since you have already created the SQL, the converting to SPT will be very easy. Use the SQLExec() function to return all the records you want. If you already have another remote view open that uses a shared connection, you can get the Connection Handle being used with CursorGetProp('Connecthandle', 'MyView'). Otherwise, you have to use the SQLConnect() function to create a connection. Then use SQLExec to submit the query and return the results to a cursor.

>Hi Mark,
>
>The view is created locally on the users station. It is created in a temp DBC that is created in the c:\temp folder. 'maintbl' is also a temp dbf that is created in the same folder. They are erased afterword when the program ends. Also if the folder does not exist, I create it. The users pick the invoices from a list or enter the numbers mannualy. They want multiple selections. Not just 1 at a time. The numbers chosen are stored in the 'maintbl'. Perhaps the deleting & recreateing of the view is the slow method. I will try and look into the REQUERY method you mentioned. I had placed this block just before creating the view to avoid any previous data from still being around.
>
>IF INDBC('invc_ln_view', 'VIEW')
> DELETE VIEW invc_ln_view
>ENDIF
>
>There are several of these views needed for this screen and I would like to reduce the time it takes. Like I said before, this DBC stuff is all new to me. And there is nobody else here that has any knowledge of it either. Trial & error with some help from people on the UT is all there is. I will try to create the views 1 time, and REQUERY with the new data the rest of the times. Also this is not an updateable screen. It's just for printing of the invoices. No data goes back to the host DBC. And nothing can be modified.
>Again, Thanks for more things to think about.