Ken, Dennis, et al.
As you all can see, from the What's New documents, we are
enjoying implementing the many "Engine-Level Enhancements"
in the recent updates of R:BASE eXtreme 9.5 (32/64).
We are actually having a ball!
Enjoy the showcase and pride of our eXpanded R:Dream Team!
The best is yet to come.
Very Best R:egards,
Razzak
At 01:26 PM 3/14/2014, Kenshap wrote:
I actually want to second this thumbs up. Sometimes it's the little
things that make a big difference.
Regards, Ken
Sent from my iPhone
> On Mar 14, 2014, at 1:10 PM, Dennis McGrath <[email protected]> wrote:
>
> Razzak,
>
> That is pretty awesome.
>
> Any chance you are thinking of adding this option to the SELECT command?
> That would really blow my socks off!!!!!!
>
> Dennis McGrath
> Software Developer
> QMI Security Solutions
> 1661 Glenlake Ave
> Itasca IL 60143
> 630-980-8461
> [email protected]
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of
A. Razzak Memon
> Sent: Friday, March 14, 2014 12:00 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Tip of the Day: JOIN, INTERSECT, SUBTRACT,
and UNION -Temporary Table Support
>
> Friday, March 14, 2014
>
> Tip of the Day: JOIN, INTERSECT, SUBTRACT, and UNION - Temporary
Table Support
> Product.: R:BASE eXtreme 9.5 (32/64)
> Build...: 9.5.4.30310 or higher www.rupdates.com
> Keywords: JOIN, INTERSECT, SUBTRACT, UNION, TEMPORARY
> Section.: Commands, Temporary Tables
>
> Did you know that a TEMPORARY option has been enhanced for the JOIN,
> INTERSECT, SUBTRACT, and UNION commands, to support the creation of a
> temporary table?
>
> The following example uses the JOIN command to create ProdDetail as a
> temporary table:
>
> JOIN ProdLocation USING Model WITH Product USING Model +
> FORMING TEMPORARY ProdDetail
>
> The following example uses the INTERSECT command to create RepSales as
> a temporary table:
>
> INTERSECT Employee WITH SalesBonus FORMING TEMPORARY RepSales +
> USING EmpLname, EmpID, HireDate, NetAmount, TransDate, Bonus, BonusPct
>
> The following example uses the SUBTRACT command to create NoBonus as a
> temporary table:
>
> SUBTRACT SalesBonus FROM Employee FORMING TEMPORARY NoBonus
>
> The following example uses the UNION command to create SalesRepHistory
> as a temporary table:
>
> UNION Employee WITH SalesBonus FORMING TEMPORARY SalesRepHistory
>
> Enjoy the showcase and pride of our eXpanded R:Dream Team!
>
> Very Best R:egards,
>
> Razzak.
>
> www.rbase.com
> www.facebook.com/rbase
> www.Razzak.com
> www.RazzakMemon.com
> --
> 31 years of continuous innovation!
> 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
> --
