Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Possible VFP9 bug
Message
 
À
31/07/2007 11:20:57
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01244876
Message ID:
01244899
Vues:
25
>
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform