Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Funny BUG and Serious ISSUE
Message
From
02/04/2005 16:27:06
 
 
To
02/04/2005 15:55:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01001002
Message ID:
01001024
Views:
19
>Hi Fabio,
>
>You are correct. There is a bug here. The following query is illegal in VFP and should fail:
>
>
>SELECT ;
> id;
>, !ISNULL((SELECT .T. FROM PivotConstant WHERE EXISTS(SELECT*FROM tree WHERE parentId=T.id))) hasChild;
>FROM tree T
>
>
>It is illegal in VFP because correlation is supported only to immediate parent query.
>
>Thanks,
>Aleksey.

infact i call it funny!
Previous
Reply
Map
View

Click here to load this message in the networking platform