Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter cleared, Data Session
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Filter cleared, Data Session
Miscellaneous
Thread ID:
00909258
Message ID:
00909258
Views:
45
WinXP Prof
VFP8 SP1

Hope someone can help... I have a system going and the main form shows 1-3 grids dynamically built. All ok here. Based on user picking some criteria to limit the display, I close the form, rebuild subset information and rebuild the form again with same grids but extra content...

Anyhow, here's where the problem occurs. While building the derived data sets, I am issuing a filtered index...
select * from SomeTable where MyCondition into cursor C_Subset1 READWRITE

select MainTable
set relation to MainKey into C_Subset1

*/ system crashes here, but only after second load of the form...
*/ all prior attempts have no problem
index on found( "C_Subset1" ) OF MyExternalIndex compact
I've tried putting a try/catch in place and it for some reason (why I'm here now) is being swapped into a new data session ID with only 1 table "FoxCode" (probably from the intellisence). The form is in the default "1" data session. Even with debugger, I can't swap back to data session 1 from 2... Even outside the try/catch.

Any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform