Private Data Sessions and IDX problem  
Author Message
Stuman99





PostPosted: Visual FoxPro General, Private Data Sessions and IDX problem Top

I have found a problem when using private data sessions and IDX index. I have a main form A which launches two instances of form B. All forms are private data sessions. If I close the second instance of form B, then say try and change the work area on the first instance of form B, I receive the error, data type mismatch. Keep in mind this is a port from FPW2.6 so coding style is old.

Form B has the following tables open and one relation statement:

select 1

use customer

set index to custcode

select 2

use notes

set order to tag notes3

set relation to notes.ccode into customer

select 3

use images

To recreate problem:

1) from main form launch two instances of form b

2) close second instance of form b

3) on first instance of form b click a button that selects 3 ( the image table ).

The problem appears to be related to the use of the IDX file. I have tried creating a CDX and this does not have the same issue. My problem is that this is a port and would cause a longer development cycle if I have to change to CDX.

Any ideas would be greatly appreciated!



Visual FoxPro1  
 
 
AndyKr





PostPosted: Visual FoxPro General, Private Data Sessions and IDX problem Top

>>The problem appears to be related to the use of the IDX file

I am afraid that there is no solution. This is a known issue with IDX files and the only way around it is to use structural CDX instead.