General information
Category:
Forms & Form designer
Sorry, I cannot get where the problem is.
Anyway you don't need to call the afterrowcolchange method of the grid nor the activate event of the cell, so you can limit your call at the pageframe.page2.grid1.setfocus()
What I want to say with the setfilter command is that with large tables it becomes slower and slower. I'd prefer to fill the CursorB with the proper data in the afterrowcolchange event of the page1.grid1
If you'll do that, you'd probably want to zap the CursorB, in this case remember to set the Pageframe.page2.grid1.recordsource = ''
then fill your cursor and after set Pageframe.page2.grid1.recordsource = 'CursorB' and then set the controlsource of each column to the proper value.
It should work Reza.
If not send me your form and 'I'll give it a glance s soon as possible
Alessio
>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