Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 10 of 11 total |
Sensitive result sets |
Mon, Feb 11 2008 7:29 AM | Permanent Link |
Fernando Dias 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Fernando Dias 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 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 PM | Permanent Link |
Fernando Dias Team Elevate | Tim,
Great! Thank you. I hope your list is a stack and you put this one on top -- Fernando Dias Easygate, Lda |
Tue, Feb 12 2008 3:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Last time I asked it was several stack - all several inches high. Roy Lambert |
Tue, Feb 12 2008 4:40 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Fernando Dias 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 -- Fernando Dias |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |