[NEW][SQL] WHERE fld IN (SELECT ...) implemented

[Deane Venske]

Thanks Ruslan! This will be great!!!

BTW, are there any known issues with using sqlExecute("CREATE TABLE x
(...);")?
The other day my code was working fine, now it wont work. I've even tried
doing it from scratch in the message window but just can't get the program
to make tables using SQL.

Thanks,
Deane

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Tuesday, 3 June 2003 6:46 AM
To: valentina at lists.macserve.net; David Studstill
Cc: REALbasic Network Users Group; REALbasic Betas
Subject: [NEW][SQL] WHERE fld IN (SELECT ...) implemented
Importance: Low


Hi Guys,

:-)

I was need just few hours to implement first sub-query type
for Valentina 1.9.8

Now you can do queries like this.

    SELECT * FROM T1
    WHERE a IN ( SELECT x FROM T2 WHERE y <= 2)
    ORDER BY c

I wonder why I have not made this few months ago?!
So easy with Valentina design...  :-)

--
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina