Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid
Message
From
21/01/1999 14:09:44
 
 
To
21/01/1999 13:51:12
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonesia
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Re: Grid
Miscellaneous
Thread ID:
00178390
Message ID:
00178627
Views:
19
>>Grid.Refresh is not the best place for this operation, because it can fire internally sometimes. I think that separate custom method e.g. Thisform.RestoreGrid would work safer.
>
>Actually I did that before, and it gave me the same result.
>I put the code in Grid.Refresh before I gave up and scream for help :)
>
>>Also, I don't quite understand: seemingly you run cross-tab query and at the same time you have columncount=3 (or you reset it on fly?).
>That just for example, Edward.
>Actually I build a 2 field table and a 2 column grid, the cross tab fired from a listbox.
>
>and it look like this :
>Grid1.ProgrammaticChange
>Parameter cSelect,cOrder
>Do Case
>Case cSelect=1
>Select * From myTable1 WHERE UPPER(ALLT(orderno))==UPPER(ALLT(cOrderno)) Into myTempCursor
>Case cSelect=2
>Select * From myTable2 WHERE UPPER(ALLT(orderno))==UPPER(ALLT(cOrderno)) Into myTempCursor
>Endcase
>DO vfpxtab WITH 'mytable'
>This.Refresh()

For listbox I would expect this code to be in Listbox.InteractiveChange. Anyway, what is grid.recordsource: cross-tab output? If yes, then remember that actual columncount (number of output fields) will vary and you will have to say explicitly in code Grid.Columncount=fcount()
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform