Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New bug? IIF() with an embedded alias in expression
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01002937
Message ID:
01003166
Views:
22
Yes! I'm not crazy...

Well, at least several brain cells are still firing.

I've sent the bug report on to Microsoft. Guess I'll take a look at the reportbuilder and make a few mods come Monday.

Thanks for the quick check Sergey.

Steve

>Now I got the error. Looks like a bug to me. Here're exact steps:
>OPEN DATABASE (HOME(2) + "\Northwind\northwind.dbc")
>USE northwind!Customers
>* Make sure that it's brand new report
>ERASE test.fr?
>Modify Report test
>Drop field control in the detail band of the report and past expression IIF(Customers.customerid="ABC","A","B") into it.
>Press OK and get the error.
>
>>Do it with a real table open. Add a field and you get the new multi tabbed 'Field Properties' screen. On the General tab press the expression builder button to and enter the expression with an alias for that table. I do the following for the CUSTOMERS table in the NorthWind sample folder:
>>
>>IIF(Customers.customerid="ABC","A","B")
>>
>>The verify button confirms it is a good expression and I press OK which returns me to the Field Properties screen. When I press OK here I get an error window:
>>
>>*****************************
>>Report Builder Error
>>
>>Alias is not found
>>Line 0 in saveexprwidth():
>>...
>>fieldexprthandler.Error()
>> OK
>>*****************************
>>
>>It does not occur if the table is not open in the first place. And it occurs without going to the expression builder but if you just enter the expression in the expression box on the Field Properties screen.
>>
>>It doesn't make sense that the verification works fine but the OK on the Field Properties screen trying to set the width doesn't.
Steven D. Supinski
The American Contractor
Santa Cruz, CA 95062
Phone: (800) 333-8435 ext 4017
Email: ssupinski@theamericancontractor.com
Previous
Reply
Map
View

Click here to load this message in the networking platform