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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only