I have a boolean field in a MySQL table which I wish to display in a grid (dbAdvGrid) via a Client Data Set / Provider / Datasource.
All is well until I add the field (fkBoolean) to the list of columns and set the CDS to active. It then displays 'Invalid Cell' with the following details:
[15822ADF]{TMSD2011.bpl} Advgrid.TAdvStringGrid.AddCheckBox + $5B
[15C4FF34]{TMSD2011.bpl} Dbadvgrid.TDBAdvGrid.LoadFromDataSet + $450
[15C46E1E]{TMSD2011.bpl} Dbadvgrid.TDBAdvGrid.ActiveChange + $50A
[5071B6F6]{dbrtl150.bpl} DB.TDataLink.UpdateRange (Line 9307, "DB.pas" + 5) + $2
[15C45129]{TMSD2011.bpl} Dbadvgrid.TAdvGridDataLink.ActiveChanged + $45
[5071B7F9]{dbrtl150.bpl} DB.TDataLink.SetActive (Line 9345, "DB.pas" + 5) + $4
[5071B828]{dbrtl150.bpl} DB.TDataLink.UpdateState (Line 9360, "DB.pas" + 1) + $15
[5071B946]{dbrtl150.bpl} DB.TDataLink.DataEvent (Line 9421, "DB.pas" + 1) + $7
[5071BF87]{dbrtl150.bpl} DB.TDataSource.NotifyLinkTypes (Line 9708, "DB.pas" + 4) + $9
[5071BFB6]{dbrtl150.bpl} DB.TDataSource.NotifyDataLinks (Line 9715, "DB.pas" + 3) + $8
[5071BDB7]{dbrtl150.bpl} DB.TDataSource.SetState (Line 9637, "DB.pas" + 5) + $6
[5071BE02]{dbrtl150.bpl} DB.TDataSource.UpdateState (Line 9650, "DB.pas" + 1) + $A
[5071BFD0]{dbrtl150.bpl} DB.TDataSource.DataEvent (Line 9720, "DB.pas" + 1) + $7
[50721BC1]{dbrtl150.bpl} DB.TDataSet.DataEvent (Line 12167, "DB.pas" + 36) + $14
[506ABB38]{dsnap150.bpl} DBClient.TCustomClientDataSet.DataEvent (Line 1784, "dbclient.pas" + 10) + $6
[5071FBAC]{dbrtl150.bpl} DB.TDataSet.SetState (Line 11170, "DB.pas" + 5) + $6
[507200BF]{dbrtl150.bpl} DB.TDataSet.OpenCursorComplete (Line 11345, "DB.pas" + 7) + $5
[5071FFEF]{dbrtl150.bpl} DB.TDataSet.SetActive (Line 11316, "DB.pas" + 15) + $3
[50720033]{dbrtl150.bpl} DB.TDataSet.SetActive (Line 11323, "DB.pas" + 22) + $E
[5008A362]{rtl150.bpl } TypInfo.SetOrdProp (Line 1791, "TypInfo.pas" + 28) + $0
[2104A2A2]{designide150.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 841, "DesignEditors.pas" + 2) + $E
[2108F373]{designide150.bpl} VCLEditors.TBooleanProperty.MouseUp (Line 1840, "VCLEditors.pas" + 5) + $10
[21194BD9]{vclide150.bpl} PropBox.TCustomPropListBox.ItemMouseUp (Line 1625, "PropBox.pas" + 16) + $1B
[21194DCF]{vclide150.bpl} PropBox.TCustomPropListBox.MouseUp (Line 1690, "PropBox.pas" + 1) + $D
[5027E914]{vcl150.bpl } Controls.TControl.DoMouseUp (Line 7318, "Controls.pas" + 2) + $28
[5027E990]{vcl150.bpl } Controls.TControl.WMLButtonUp (Line 7331, "Controls.pas" + 9) + $6
[2119A4C0]{vclide150.bpl} IDEInspListBox.TInspListBox.WMLButtonUp (Line 1631, "IDEInspListBox.pas" + 3) + $4
[5027DF74]{vcl150.bpl } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[502820CB]{vcl150.bpl } Controls.TWinControl.IsControlMouseMsg (Line 9608, "Controls.pas" + 1) + $9
[50282838]{vcl150.bpl } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[502B8411]{vcl150.bpl } StdCtrls.TCustomListBox.WndProc (Line 6217, "StdCtrls.pas" + 54) + $6
[50281ED8]{vcl150.bpl } Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $6
[500B067C]{rtl150.bpl } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50358AFF]{vcl150.bpl } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 23) + $1
[50358B42]{vcl150.bpl } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[50358E6D]{vcl150.bpl } Forms.TApplication.Run (Line 9927, "Forms.pas" + 26) + $3
[004ACCE2]{bds.exe } bds.bds (Line 201, "" + 8) + $FFFB
[15C4FF34]{TMSD2011.bpl} Dbadvgrid.TDBAdvGrid.LoadFromDataSet + $450
[15C46E1E]{TMSD2011.bpl} Dbadvgrid.TDBAdvGrid.ActiveChange + $50A
[5071B6F6]{dbrtl150.bpl} DB.TDataLink.UpdateRange (Line 9307, "DB.pas" + 5) + $2
[15C45129]{TMSD2011.bpl} Dbadvgrid.TAdvGridDataLink.ActiveChanged + $45
[5071B7F9]{dbrtl150.bpl} DB.TDataLink.SetActive (Line 9345, "DB.pas" + 5) + $4
[5071B828]{dbrtl150.bpl} DB.TDataLink.UpdateState (Line 9360, "DB.pas" + 1) + $15
[5071B946]{dbrtl150.bpl} DB.TDataLink.DataEvent (Line 9421, "DB.pas" + 1) + $7
[5071BF87]{dbrtl150.bpl} DB.TDataSource.NotifyLinkTypes (Line 9708, "DB.pas" + 4) + $9
[5071BFB6]{dbrtl150.bpl} DB.TDataSource.NotifyDataLinks (Line 9715, "DB.pas" + 3) + $8
[5071BDB7]{dbrtl150.bpl} DB.TDataSource.SetState (Line 9637, "DB.pas" + 5) + $6
[5071BE02]{dbrtl150.bpl} DB.TDataSource.UpdateState (Line 9650, "DB.pas" + 1) + $A
[5071BFD0]{dbrtl150.bpl} DB.TDataSource.DataEvent (Line 9720, "DB.pas" + 1) + $7
[50721BC1]{dbrtl150.bpl} DB.TDataSet.DataEvent (Line 12167, "DB.pas" + 36) + $14
[506ABB38]{dsnap150.bpl} DBClient.TCustomClientDataSet.DataEvent (Line 1784, "dbclient.pas" + 10) + $6
[5071FBAC]{dbrtl150.bpl} DB.TDataSet.SetState (Line 11170, "DB.pas" + 5) + $6
[507200BF]{dbrtl150.bpl} DB.TDataSet.OpenCursorComplete (Line 11345, "DB.pas" + 7) + $5
[5071FFEF]{dbrtl150.bpl} DB.TDataSet.SetActive (Line 11316, "DB.pas" + 15) + $3
[50720033]{dbrtl150.bpl} DB.TDataSet.SetActive (Line 11323, "DB.pas" + 22) + $E
[5008A362]{rtl150.bpl } TypInfo.SetOrdProp (Line 1791, "TypInfo.pas" + 28) + $0
[2104A2A2]{designide150.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 841, "DesignEditors.pas" + 2) + $E
[2108F373]{designide150.bpl} VCLEditors.TBooleanProperty.MouseUp (Line 1840, "VCLEditors.pas" + 5) + $10
[21194BD9]{vclide150.bpl} PropBox.TCustomPropListBox.ItemMouseUp (Line 1625, "PropBox.pas" + 16) + $1B
[21194DCF]{vclide150.bpl} PropBox.TCustomPropListBox.MouseUp (Line 1690, "PropBox.pas" + 1) + $D
[5027E914]{vcl150.bpl } Controls.TControl.DoMouseUp (Line 7318, "Controls.pas" + 2) + $28
[5027E990]{vcl150.bpl } Controls.TControl.WMLButtonUp (Line 7331, "Controls.pas" + 9) + $6
[2119A4C0]{vclide150.bpl} IDEInspListBox.TInspListBox.WMLButtonUp (Line 1631, "IDEInspListBox.pas" + 3) + $4
[5027DF74]{vcl150.bpl } Controls.TControl.WndProc (Line 7074, "Controls.pas" + 91) + $6
[502820CB]{vcl150.bpl } Controls.TWinControl.IsControlMouseMsg (Line 9608, "Controls.pas" + 1) + $9
[50282838]{vcl150.bpl } Controls.TWinControl.WndProc (Line 9831, "Controls.pas" + 144) + $6
[502B8411]{vcl150.bpl } StdCtrls.TCustomListBox.WndProc (Line 6217, "StdCtrls.pas" + 54) + $6
[50281ED8]{vcl150.bpl } Controls.TWinControl.MainWndProc (Line 9552, "Controls.pas" + 3) + $6
[500B067C]{rtl150.bpl } Classes.StdWndProc (Line 13491, "Classes.pas" + 8) + $0
[50358AFF]{vcl150.bpl } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 23) + $1
[50358B42]{vcl150.bpl } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[50358E6D]{vcl150.bpl } Forms.TApplication.Run (Line 9927, "Forms.pas" + 26) + $3
[004ACCE2]{bds.exe } bds.bds (Line 201, "" + 8) + $FFFB
This error only occurs when page mode is False, if I switch it to true the error is not displayed.
Any help gratefully accepted!
Thanks,
Roy