Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 11 total
Thread Sensitive result sets
Mon, Feb 11 2008 7:29 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Tim,

It would be great if we can have sensitive result sets with SELECTs that
have sub-queries.
Of course, the columns where the values are obtained from a sub-query would
be read-only.
For example, the query:

SELECT
 OrderID,
 CustomerID,
 (select Name from Customers C where C.CustomerID = CustomerId) as
CustomerName
FROM
 Orders
ORDER BY
 OrderID

Would return a sensitive result set, with the column "CustomerName" being
read-only.
This is the equivalent to a TEDBTable with Lookup fields.

Best regards
--
Fernando Dias
Easygate, Lda

Mon, Feb 11 2008 9:11 AMPermanent Link

"Jose Eduardo Helminsky"
Fernando / Tim

I am still under DBISAM development but I really want to know how fast is
the code you wrote for an example ?

> SELECT
>  OrderID,
>  CustomerID,
>  (select Name from Customers C where C.CustomerID = CustomerId) as
> CustomerName
> FROM
>  Orders
> ORDER BY
>  OrderID

In DBISAM I will use Calculated Field to find the name of the customers.

Eduardo

Mon, Feb 11 2008 3:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eduardo,

<< I am still under DBISAM development but I really want to know how fast is
the code you wrote for an example ? >>

It's about as fast as a calculated field for a local application, and faster
with a remote application due to not needing a round-trip.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 11 2008 3:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Fernando,

<< It would be great if we can have sensitive result sets with SELECTs that
have sub-queries. Of course, the columns where the values are obtained from
a sub-query would be read-only. >>

No problem, I will put it on the list.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 11 2008 4:11 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

> It's about as fast as a calculated field for a local application, and faster
> with a remote application due to not needing a round-trip.

Tim, this was exactly what I had in mind when I suggested this change:
move some tables with lookup or calculated fields into stored procedures Smile

Eduardo, like you I'm still with DBISAM for current development, but
planning a migration to EDB soon. However, it's a big change, and the
first application I will migrate to EDB is still using BDE/Paradox. For
now I'm only testing and planning.

--
Fernando Dias
Easygate, Lda

Mon, Feb 11 2008 4:22 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Tim,

Great! Thank you.
I hope your list is a stack and you put this one on top Smiley

--
Fernando Dias
Easygate, Lda
Tue, Feb 12 2008 3:18 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Fernando
Last time I asked it was several stack - all several inches high.


Roy Lambert
Tue, Feb 12 2008 4:40 AMPermanent Link

"Jose Eduardo Helminsky"
Tim

> It's about as fast as a calculated field for a local application, and
> faster with a remote application due to not needing a round-trip.

I am very happy to read this.

Eduardo

Tue, Feb 12 2008 4:42 AMPermanent Link

"Jose Eduardo Helminsky"
Fernando

> Eduardo, like you I'm still with DBISAM for current development, but
> planning a migration to EDB soon. However, it's a big change, and the
> first application I will migrate to EDB is still using BDE/Paradox. For
> now I'm only testing and planning.

I have more than 100 applications to convert and this will give me a huge
work but I only start migrating when I will know exactly where I need to go
without any doubts.

Eduardo

Tue, Feb 12 2008 11:42 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Roy

> Last time I asked it was several stack - all several inches high.

And, by the number of threads you started here during the last months, I
bet you generated at least one of them Smiley

--
Fernando Dias
Page 1 of 2Next Page
Jump to Page:  1 2
Image