Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add calculated field to grid
Message
 
 
To
06/04/2007 17:55:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01213123
Message ID:
01213124
Views:
12
>Greetings All
>I am attempting to add a calculated field to a grid as can be done in a browse. Not having much luck.
>
>I code my grids. I have provided sample code below:
>
>x = x+1
>.columns(x).width = 80
>.columns(x).controlSource = "apInvItems.shopOrder"
>.columns(x).header1.caption = DBGETPROP("apInvItems.shopOrder","FIELD","CAPTION")
>x = x+1
>.
>.
>
>I want to display in a grid column the dfference between the apInvItems fields: qtyOrdered and the qtyInvoiced. Short of creating a cursor with the calculation as a cursor column, can I assign to a grid column the calculated value:
>
> apInvItems.qtyOrdered - apInvItems.qtyInvoiced
>
>
>Thanks in advance
>
>Vince

Yes, jut put it in parenthesis. It will make the field read-only.
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