Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid.column1.ControlSource variable not found error
Message
From
11/05/2005 04:41:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01012741
Message ID:
01012746
Views:
24
>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.

Prefix it with alias.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform