Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 5 of 5 total |
Sensitive Views |
Mon, Feb 23 2009 8:24 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sensitive views using joins as part of the WHERE clause but not having any of the joined columns as part of the result set would be really nifty. Any chance?
EG SELECT Companies.* FROM Companies JOIN Career ON Career._fkCompanies = _ID Roy Lambert |
Mon, Feb 23 2009 9:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Sensitive views using joins as part of the WHERE clause but not having any of the joined columns as part of the result set would be really nifty. Any chance? >> Views already act like tables in that they reflect changes in the underlying tables and can be refreshed, etc. The only part that they don't do is updating, which is something that I'm working on fixing in a future release with something like INSTEAD OF triggers on view INSERT, UPDATE, or DELETE operations. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 24 2009 2:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Views already act like tables in that they reflect changes in the underlying >tables and can be refreshed, etc. The only part that they don't do is >updating, which is something that I'm working on fixing in a future release >with something like INSTEAD OF triggers on view INSERT, UPDATE, or DELETE >operations. I was hoping to be just able to use a table component..... Roy Lambert |
Tue, Feb 24 2009 9:46 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I was hoping to be just able to use a table component..... >> You *can* use a TEDBTable component to open any view. The only problem is that, right now, you can't update any views that can't return a sensitive (in the TEDBQuery sense) result set. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 24 2009 10:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>You *can* use a TEDBTable component to open any view. Figured that one out already >The only problem is >that, right now, you can't update any views that can't return a sensitive >(in the TEDBQuery sense) result set. This is what prompted my original question. The one about table components was prompted by "The only part that they don't do is updating, which is something that I'm working on fixing in a future release with something like INSTEAD OF triggers" which makes me think Query. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |