![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 10 of 11 total |
![]() |
Mon, Feb 11 2008 7:29 AM | Permanent Link |
Fernando Dias ![]() | 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. ![]() | 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. ![]() | 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 ![]() | > 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 ![]() | 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 ![]() | 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 ![]() | 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 Monday, July 7, 2025 at 06:35 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |