Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid afterrowcolumnchange not changing?
Message
From
08/09/2008 10:25:07
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01345711
Message ID:
01345734
Views:
10
>>Hi All,
>>
>>I have a two grids, one grid controls what is in the other grid, or is suppose to.
>>
>>the code I have in the AfterRowColChange method is this:
>>
>>LPARAMETERS nColIndex
>>DODEFAULT()
>>LOCAL llok, lcclient, laoption(1)
>>lcclient = ccontact.clientid
>>laoption[1] = ccontact.contactid  && when I stop it here, the record pointer is still on the first record, not the record I clicked on the grid.
>>THISFORM.cpageframe1.page1.grid2.RECORDSOURCE = ""
>>llok = settables(lcclient, THISFORM.DATASESSIONID, "CRACT", @laoption)  && this gets the correct records for the 2nd grid
>>THISFORM.resetgrids(.T.)  && this sets the grids back to the correct recordsources
>>SELECT 'crscustmer'
>>THISFORM.REFRESH()
>>
>>
>>Any ideas why it is not working for me?
>>
>>If I comment out everything, but the 1st two lines, the first grids shows that it is on the other records.
>>
>>TIA,
>>Beth
>
>Hi Beth,
>
>You're doing something too complex here. Why do you need to reset recordsource for the grid? Also you don't have to explicitly call DODEFAULT(), you may comment it out, nothing will change.

I am resetting the recordsource for the 2nd grid. I put the DODEFAULT() in there because I was trying to get the grid ARCC to set the record pointer to the correct record, so that my contactid would be the correct one and let the other code get the correct records. At the moment, it stays on the first record, so the second grid never really gets changed.
Beth
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform