Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Why a Simple EDBQuery is always ReadOnly. |
Fri, Mar 8 2013 2:26 PM | Permanent Link |
Vitor Martins Pregitzer & Ca., Lda | Why a EDBQuery with simple SQL "SELECT * FROM OfList" is always ReadOnly. The table OfList is not ReadOnly. Thanks Best Regards. Vitor Martins |
Fri, Mar 8 2013 4:21 PM | Permanent Link |
Terry Swiers | Hi Vitor,
> Why a EDBQuery with simple SQL "SELECT * FROM OfList" is always ReadOnly. > The table OfList is not ReadOnly. Are you setting the RequestSensitive on the TEDBQuery component to true? If you are not, you are getting a canned result set. --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com --------------------------------------- |
Mon, Mar 11 2013 1:48 AM | Permanent Link |
Barry | Vitor,
In addition to Terry's suggestion, if "OfList" is a multi-table view, then it will be insensitive (read-only) or if it is a single table view sorted on a non-index column it will also be insensitive. Barry |
Mon, Mar 11 2013 4:13 PM | Permanent Link |
Vitor Martins Pregitzer & Ca., Lda | Thanks to all, RequestSensitive on the TEDBQuery component must be set to true. Best Regards Vitor Martins |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |