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

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

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

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

> 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

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

Tim,

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

--
Fernando Dias
Easygate, Lda

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


Roy Lambert

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

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

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

--
Fernando Dias