Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid.column1.ControlSource variable not found error
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Grid.column1.ControlSource variable not found error
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01012741
Message ID:
01012741
Views:
82
I have the following code in my form initProcessGrid method. It's called from the form's init after all the appropriate cursors have been created.
lcSQL = "SELECT CPROCESSLOOKUPCA1.LU_NAME,CPROCESSINFOCA1.PROC_STAT,CPROCESSLOOKUPCA1.LU_KEY FROM CPROCESSLOOKUPCA1, CPROCESSINFOCA1 WHERE CPROCESSLOOKUPCA1.LU_KEY = CPROCESSINFOCA1.DESC_KEY ORDER BY CPROCESSINFOCA1.PROC_STAT DESC INTO cursor grdCPROCESSINFOCA1"

WITH this.ctnrtrackermaintpf1.apftrackermaint1.page2.mhgrid1
	.AllowCellSelection = .F.
	.RecordSourceType = 4
	.RecordSource = lcSQL
	.column1.controlsource = lcControlSource1 &&lu_name
	.column2.controlsource = "ICase(proc_stat=1, 'Required', proc_stat=2, 'In Process', proc_stat=3, 'COMPLETED', '')"
ENDWITH
I get the following error: Variable proc_stat not found.
Funny thing is it doesn't give error for column1.controlsource. proc_stat is a field in grdCPROCESSINFOCA1. Also if I tell it to ignore the error, the grid displays fine with appropriate ICase options. Why does this error pop-up but grid displays fine? Please note that grid displays on page frame.
Next
Reply
Map
View

Click here to load this message in the networking platform