Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors in Grids
Message
From
17/07/1999 11:16:05
 
 
To
17/07/1999 08:48:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00242682
Message ID:
00242731
Views:
22
Hi jeffrey.

>> I know I could've done a set filter but I don't trust those to work all the time. <<

Trust has nothing to do with it (g). Filtered RecordSources in grids are s-l-o-o-o-w because they are not optimized.

>>SELECT .F. AS PICK_DEL, CDC_ID, SPECNO, ;
UNIQKEYSAS, UNIQKEYBAY ;
FROM CDCHIV ;
WHERE CDC_ID = HIV_TEMP ;
INTO CURSOR TEMP_HIV <<

Hmmm. What is the RecordSourceType for your grid? Is it 1-Alias or is it 4-SQL statement? If it is 4-SQL statement, this is what your problem is. FWIW, I tend to stick with 1-ALias because it works best for me.

If I were in your shoes, I would create a parameterized view on cdcHiv and requery the view in the valid of your control and then set focus to the grid. This really is the simplest, most straight forward way of doing it.

If you need help setting up the PV, just holler.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform