General information
Category:
Forms & Form designer
i put it in activate event but my problem is exist.
i made CursorTempB in init event of my form as below :
SELECT Rec_b.*, Driver_v.dvname, Driver_v.dvcarno ;
FROM rec_b ;
LEFT OUTER JOIN driver_v ON rec_b.dvcode = Driver_v.dvcode ;
ORDER BY rec_b.rbcode INTO CURSOR &CursorTempB readwrite
INDEX ON rbnum TAG rbnum
INDEX ON rbdate TAG rbdate
INDEX ON rbsen TAG rbsen
INDEX ON rbrec TAG rbrec
SET ORDER TO tag rbnum
WITH thisform.pageframe1.page2.grid1
.RecordSource = CursorTempB
.column1.ControlSource = "rbnum"
.column2.ControlSource = "rbdate"
.column3.ControlSource = "rbsen"
.column4.ControlSource = "rbrec"
ENDWITH
can you explain more about "Remember that the use of the set filter command could take a lot of time to show your data, maybe you'd better build a temporary cursor in which you store the record to show with a scan --- endscan loop" ?
Thanks for your reply
Reza
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