Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About grid
Message
From
18/11/2004 06:42:39
 
 
To
18/11/2004 03:48:56
Reza Meamar
Homa Programming Group
Shiraz, Iran
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00962234
Message ID:
00962529
Views:
9
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
Map
View

Click here to load this message in the networking platform