Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dare I use the default data session?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00353286
Message ID:
00353475
Views:
17
I almost always prefer private DS. See the VFP help on USE with the NOREQUERY nDataSession clause. That may help with the speed of opening the form with a private DS.

>I have forms that have a big grid. Clicking on the grid opens up a detail form displaying the same cursor, hopefully at the record that was clicked in the grid. (I pass the key value as a parameter and LOCATE FOR that value in the detail form.) I had one pair of forms where I had to give the detail form a private data session to make it work. Mysteriously it worked for the other form pairs. The problem refuses to appear in the debugger. I now have another form pair that just started doing something similarly wrong, after I changed the cursors somewhat. The detail form opens to the right record, but as soon as I click a nav button, it goes to the first record. It works correctly in the debugger (naturally). Changing the form to private datasession made it work correctly. However, that makes the form take longer to open, because the cursor is a view that takes a little while to join. Now I have that overhead for both the grid and the detail form. When the detail forms open,
>it .HIDEs the grid form without closing it, so the data session ought to be all right.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform