Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get value from grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01043209
Message ID:
01043296
Views:
12
Or if you know the field names, just use

thisform.text1.value = MyAlias.myfield1 + MyAlias.myField2 + ...

assuming you want to show total in that textbox value.

Also it's always a good idea to give your form elements some meaningful names, such as: txtTotal, cboStates, chkResolved, etc. It takes few seconds, but makes your program and code more professional and easier to maintain.

>Hi Mohammed,
>
>
>LPARAMETERS nColIndex
>WITH THISFORM.GRID2
>thisform.text1.value=EVAL(.column2.ControlSource)+EVAL(.column3.ControlSource) ;
>+EVAL(.column4.ControlSource) +EVAL(.column5.ControlSource)
>thisform.text2.value=EVAL(.column1.ControlSource)
>ENDWITH
>
>* or
>
>LPARAMETERS nColIndex
>thisform.text1.value=EVAL(THIS.column2.ControlSource)+EVAL(THIS.column3.ControlSource) ;
>+EVAL(THIs.column4.ControlSource) +EVAL(THIS.column5.ControlSource)
>
>thisform.text2.value=EVAL(THIS.column1.ControlSource)
>
>
>MartinJ
>
>>hi all,
>>any idea
>>
>>i try to view 4 columns from mygrid to mytext1
>>via AFTERROWCOLCHANGE EVENTS at mygrid
>>evrey time get first record with all columns
>>second record swap just the field you pass or press
>>
>>LPARAMETERS nColIndex
>>thisform.text1.value=THISFORM.GRID2.column2.text1.VALUE+THISFORM.GRID2.column3.text1.VALUE ;
>>+THISFORM.GRID2.column4.text1.VALUE +THISFORM.GRID2.column5.text1.VALUE
>>
>>thisform.text2.value=THISFORM.GRID2.column1.text1.VALUE
>>
>>thanks.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform