Hi Matt instead of a cursor use a table once you get the the oracle data copy it to a tempory table on disk and start using that table on the close of the application delete the tempory table.


>Hello all,
>
>I have a datasession delima. I have a cursor that I create from SPT to an Oracle table that has a listing of about 27000 codes. It takes approximately 3 to 4 seconds on my slowest PC to select the records. I wish to use these codes in a lookup. Here is the delima.
>
>My lookup form uses a Private Datasession. I do not want to have to query this table via SPT every time the form is loaded. I would prefer to query the Oracle table once and then query the VFP cursor when the form is loaded. Quering the VFP cursor takes less than a second.
>
>Here is what I wish to do.
>
>1. Select the Data from the oracle table via SPT once when the application starts and place the Cursor in the default datasession (1).
>
>2. When the lookup form is displayed (private datasession) Select the data from the VFP Cursor in the Public datasession into a cursor in my lookup form's private datasession.
>
>How can I do this?