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:
set index to custcode
set order to tag notes3
set relation to notes.ccode into customer
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!