Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New bug? IIF() with an embedded alias in expression
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01002937
Message ID:
01003166
Vues:
29
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform