Hi David,

>snipped a lot of interseting things

>CALCULATE now supports besides the basic functions (MAX, MIN, SUM, …) VAR_SAMP and STDDEV_SAMP as required by the SQL 2003 Standard. And now you can add your own aggregatable functions. Stay tuned for the samples to appear in the next days for this, hopefully some one will build a sample with COVAR() and CORR().


could you elaborate more on the state of your SQL implementation, including 64-bit table layer ?

we mainly need:

SELECT - SQL with all types of joins as well as sub-selects
[in, exists] and union could be coded around, but would amount to some work
Group by being probably the most important other language part

Update SQL with elaborate where / join conditions, as rewriting those to replace will not happen

Insert Into Table (FIeldList) Values and Insert into table Select ....

alter table [Conditions]

Delete could be handled via wrapping xBase, perhaps creating a delete-PK-Cursor

tia

thomas