Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add calculated field to grid
Message
From
06/04/2007 17:55:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Add calculated field to grid
Miscellaneous
Thread ID:
01213123
Message ID:
01213123
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform