Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Colum controlsource
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00432723
Message ID:
00432725
Views:
20
>Well, I think I wanna do something that just can't be done with VFP. This is what I got and it works:
>
>
>vvGrid.COLUMNS[14].CONTROLSOURCE= "AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2)"
>
>
>
>Now this is what I REALLY REALLY wanna be able to do, but VFP doesn't seem to like this. I'm assuming it's because of the 'IIF' in there...so is there some kinda workaround for this?
>
>
>vvgrid.COLUMNS[14].CONTROLSOURCE= "IIF(Month(lv_compete.competedate=1.and.Day(lv_compete.competedate)=1,AllTrim(Str(Year(lv_compete.competedate))),AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2))"

Try putting an "=" in front of the IIF.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform