Look really cool!
Kip up the good work YAG. VFP9 rock!
>Hey Kevin,
>
>Here's some sample code that's working in VFP 9.0.
>
>CLOSE DATABASES all
>CREATE CURSOR foo1 (f1 I, f2 I, f3 I)
>INSERT INTO foo1 VALUES(1,2,3)
>CREATE CURSOR foo2 (f1 I, f2 I, f3 I)
>INSERT INTO foo2 VALUES(1,2,3)
>
>SELECT T1.f1, (SELECT f2 FROM foo2 T2 WHERE T2.f1=T1.f1) AS foo2 ;
> FROM foo1 T1
>
>Look good? <g> I'm gonna post a number of samples on our blog today - just to give a better idea of some of the SQL enhancements that are coming.
http://blogs.msdn.com/vsdata.
>
>yag