Just a quick note to show you one of the cool things that will be in 2.0 -
derived tables:

SELECT * FROM
  (SELECT CustNo, Company, State
   FROM
   (SELECT * FROM customer WHERE Country='US') USCustomer
   ) FLCustomer
WHERE State='FL'

More importantly, the above query can generate a sensitive (live) result set
that is editable.  You can also do cool queries like this:

SELECT *
FROM (SELECT CustNo, SUM(Orders.ItemsTotal) AS Total
     FROM Customer INNER JOIN Orders ON Orders.CustNo=Customer.CustNo
     GROUP BY CustNo) AS CustomerTotals
WHERE Total > 100000

The only downside is that you can't use parameters with a derived table
(yet, that will be coming later).

--
Tim Young
Elevate Software
www.elevatesoft.com

Wow that looks cool, just thinking after looking at that code,
Delphi sells more in Europe than the USA, are your products
better sold over here ?
MrsNoseyRita

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:CAA2DBAC-39EA-4638-8688-3A48EB852A6C@news.elevatesoft.com...
> Just a quick note to show you one of the cool things that will be in 2.0 -
> derived tables:
>
> SELECT * FROM
>   (SELECT CustNo, Company, State
>    FROM
>    (SELECT * FROM customer WHERE Country='US') USCustomer
>    ) FLCustomer
> WHERE State='FL'
>
> More importantly, the above query can generate a sensitive (live) result
> set that is editable.  You can also do cool queries like this:
>
> SELECT *
> FROM (SELECT CustNo, SUM(Orders.ItemsTotal) AS Total
>      FROM Customer INNER JOIN Orders ON Orders.CustNo=Customer.CustNo
>      GROUP BY CustNo) AS CustomerTotals
> WHERE Total > 100000
>
> The only downside is that you can't use parameters with a derived table
> (yet, that will be coming later).
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Tim,

Very cool!
What about:

SELECT
 Orders.*,
 (select CustName
  from Customer
  where Customer.CustNo=Orders.CustNo
 ) as Name
FROM
  Orders


Returning an editable result set?
Can we have it in 2.0 ?

--
Fernando Dias
[Team Elevate]

Rita,

<< Wow that looks cool, just thinking after looking at that code, Delphi
sells more in Europe than the USA, are your products better sold over here ?
>>

I'll have to check....yep, the EU is quite a ways ahead of the US and Canada
combined.  Our top 10 in sales are to:

1) US
2) UK
3) Germany
4) Japan
5) Australia
6) Canada
7) Netherlands
8) France
9) Brazil
10) Denmark

We have customers in 79 countries around the world, and we're very proud of
this fact.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fernando,

<< Returning an editable result set? Can we have it in 2.0 ? >>

It's on the list, but the initial efforts at making this happen have stalled
and are going to need some further research, so it will most likely come a
bit later than the initial 2.0 release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Rita,
>
> << Wow that looks cool, just thinking after looking at that code,
> Delphi sells more in Europe than the USA, are your products better
> sold over here ?  >>
>
> I'll have to check....yep, the EU is quite a ways ahead of the US and
> Canada combined.  Our top 10 in sales are to:
>
> 1) US
> 2) UK
> 3) Germany
> 4) Japan
> 5) Australia
> 6) Canada
> 7) Netherlands
> 8) France
> 9) Brazil
> 10) Denmark
>
> We have customers in 79 countries around the world, and we're very
> proud of this fact.

Do you count us as New Zealand or Cook Islands? IF NZ, change it to
Cook Islands and you can probably make it 80 countries.

--
Jeff Cook
Aspect Systems Ltd
www.aspect.co.nz
+
Joan and Jeff Cook
The Cooks Oasis
www.cookislandsoasis.com

Jeff,

<< Do you count us as New Zealand or Cook Islands? IF NZ, change it to Cook
Islands and you can probably make it 80 countries. >>

Done.

--
Tim Young
Elevate Software
www.elevatesoft.com

sweeeeeeeeeeeeeeeeeeeeeeeeeeeetttt.      Doooooooonuts.....
Beeeeeeer.....        Grin

Lance


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:CAA2DBAC-39EA-4638-8688-3A48EB852A6C@news.elevatesoft.com...
> Just a quick note to show you one of the cool things that will be in 2.0 -
> derived tables:
>
> SELECT * FROM
>   (SELECT CustNo, Company, State
>    FROM
>    (SELECT * FROM customer WHERE Country='US') USCustomer
>    ) FLCustomer
> WHERE State='FL'
>
> More importantly, the above query can generate a sensitive (live) result
> set that is editable.  You can also do cool queries like this:
>
> SELECT *
> FROM (SELECT CustNo, SUM(Orders.ItemsTotal) AS Total
>      FROM Customer INNER JOIN Orders ON Orders.CustNo=Customer.CustNo
>      GROUP BY CustNo) AS CustomerTotals
> WHERE Total > 100000
>
> The only downside is that you can't use parameters with a derived table
> (yet, that will be coming later).
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Tim


And if you really want to cheat remember the UK splits into 4 - England, Scotland, Wales & a bit of Ireland

Roy Lambert

"Lance Rasmussen [Team Elevate]" <lance@jazziesoftware.com> wrote in message
news:F5766402-9842-4ABC-A457-BE91229A634A@news.elevatesoft.com...
> sweeeeeeeeeeeeeeeeeeeeeeeeeeeetttt.      Doooooooonuts..... Beeeeeeer.....
> Grin
>
Calm down its just Young at work take a shower or somthin.
Rita