the code is :
ConnectionString="dsn=ba_odbc;User ID=informix;Password=informix;"
txtParam.value = ConnectionString
dxDBGrid1.Dataset.ADODataset.ConnectionString = ConnectionString
dxDBGrid1.Dataset.ADODataset.CommandText = "Select * from tnat"
when i run i get message :
dataset does not support bookmarks,wich are required for
multi-record data controls.
Possible solution : Try to use CursorLocation=ClUseClient
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Dear Angkana,
If I'm not mistaken, you've set up the Grid's data source so that it doesn't support bookmarks. However, the XpressQuantumGrid may require bookmarks in some situations. Here is the snippet from the "XpressQuantumGrid Data Loading Modes" topic:
==================
Navigation types
In addition to different data loading modes, the XpressQuantumGrid supports multiple navigation types in Load All Records and Dynamic Load modes. It chooses the required navigation type automatically, but you can also handle this process yourself. There are three navigation types available:
by record number
by bookmark
by KeyField value via the Locate method
When in Load All Records mode, navigation is generally performed by record number, however, if the egoSmartRefresh option is active, navigation is performed by bookmarks. When in Dynamic Load mode, navigation is performed by bookmarks.
This is the default behavior. If you always want to navigate by bookmarks, simply activate the egoUseBookmark option. If you do not wish to use bookmarks, you can activate the egoUseLocate option to always navigate by the Key Field's value. If both the egoUseBookmark and egoUseLocate options are active, navigation will be performed by bookmark.
==================
So, I can suggest two ways out:
1) Adjust the settings of your Grid so that it doesn't require bookmarks (see above).
2) Change the recordset's CursorLocation to clUseClient.
Please keep me informed about your progress.
Thanks,
Serge