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?