Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible VFP9 bug
Message
 
To
31/07/2007 11:20:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01244876
Message ID:
01244899
Views:
24
>
select * from customer where exists (select * from orders)
result in C5 error. Expected no error (not talking about SQL being logical or not).
>Cetin

Worked for me also.
CREATE CURSOR customer (Fld1 Int, Fld2 Int , Fld3 Int , Fld4 Int , Fld5 Int , Fld6 Int )
FOR asd  = 1 TO 50
    APPEND BLANK IN Customer
NEXT
CREATE CURSOR Orders (Fld1 Int, Fld2 Int , Fld3 Int , Fld4 Int , Fld5 Int , Fld6 Int )
FOR asd  = 1 TO 250
    APPEND BLANK IN Orders
NEXT

select * from customer where exists (select * from orders)

CLOSE DATA ALL
SET PATH TO (HOME(2)+[Northwind])
select * from customers where exists (select * from orders)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform