Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

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