Simple Query com TDBGrid and SISGEV
lazarus / 16-Databases

----------------------------------------------------------------------
jwest · 2016-03-16 13:23

Hi,

I am using FPC 3.0, lazarus 1.6 in windows 32 bits.

I am trying to use a simple DBGrid with sqldb and Firebird.

My sqlDB query is simple: 'select A.x,a.y from table A'

I do:
IB_Firebird.connected:=True;
sqldbqry.open;

Next, I can see the data in the Grid.
But, When I click into Grid, I get a SISGEV  error. It seems the error
happend when the grid is changing to another row("moveby").

What am I doing wrong?


Call stack:
#0 DB$_$TDATASET_$__$$_DATAEVENT$TDATAEVENT$LONGINT at :0
#1 VMT_$SQLDB_$$_TCUSTOMSQLSTATEMENT at :0
#2 ?? at :0
#3 DB$_$TDATALINK_$__$$_MOVEBY$LONGINT$$LONGINT at :0
#4 TCOMPONENTDATALINK__MOVEBY(2, <error reading variable>) at
dbgrids.pas:3847
#5 DOMOVEBY(0x42cfacc) at dbgrids.pas:2550
#6 TCUSTOMDBGRID__MOUSEDOWN(MBLEFT, [SSLEFT], 307, 155, <error reading
variable>) at dbgrids.pas:2632
#7 TCONTROL__DOMOUSEDOWN({MSG = 513, KEYS = 1, XPOS = 307, YPOS = 155,
POS = {X = 307, Y = 155}, DUMMY = 10158387, RESULT = 0}, MBLEFT, [],
<error reading variable>) at .\include\control.inc:2161
#8 TCONTROL__WMLBUTTONDOWN({MSG = 513, KEYS = 1, XPOS = 307, YPOS =
155, POS = {X = 307, Y = 155}, DUMMY = 10158387, RESULT = 0}, <error
reading variable>) at .\include\control.inc:2294
#9 SYSTEM$_$TOBJECT_$__$$_DISPATCH$formal at :0
#10 VMT_$CONTROLS_$$_TCONTROL at :0
#11 ?? at :0
#12 TWINCONTROL__WNDPROC({MSG = 513, WPARAM = 1, LPARAM = 10158387,
RESULT = 0, WPARAMLO = 1, WPARAMHI = 0, WPARAMFILLER = {}, LPARAMLO =
307, LPARAMHI = 155, LPARAMFILLER = {}, RESULTLO = 0, RESULTHI = 0,
RESULTFILLER = {}}, <error reading variable>) at
.\include\wincontrol.inc:5383
#13 TCUSTOMGRID__WNDPROC({MSG = 513, WPARAM = 1, LPARAM = 10158387,
RESULT = 0, WPARAMLO = 1, WPARAMHI = 0, WPARAMFILLER = {}, LPARAMLO =
307, LPARAMHI = 155, LPARAMFILLER = {}, RESULTLO = 0, RESULTHI = 0,
RESULTFILLER = {}}, <error reading variable>) at grids.pas:4703
#14 TCUSTOMDBGRID__WNDPROC({MSG = 513, WPARAM = 1, LPARAM = 10158387,
RESULT = 0, WPARAMLO = 1, WPARAMHI = 0, WPARAMFILLER = {}, LPARAMLO =
307, LPARAMHI = 155, LPARAMFILLER = {}, RESULTLO = 0, RESULTHI = 0,
RESULTFILLER = {}}, <error reading variable>) at dbgrids.pas:1406
#15 DELIVERMESSAGE(0x5b7c6b0, <error reading variable: Attempt to
dereference a generic pointer.>) at lclmessageglue.pas:112
#16 TWINDOWPROCHELPER__DOWINDOWPROC(<error reading variable>) at
win32callback.inc:2423
#17 WINDOWPROC(4983250, 513, 1, 10158387) at win32callback.inc:2586
#18 USER32!CallNextHookEx at :0
#19 USER32!CallNextHookEx at :0
#20 USER32!GetMessageW at :0
#21 USER32!DispatchMessageW at :0
#22 TWIN32WIDGETSET__APPPROCESSMESSAGES(<error reading variable>) at
win32object.inc:366
#23 TAPPLICATION__HANDLEMESSAGE(<error reading variable>) at
.\include\application.inc:1260
#24 TAPPLICATION__RUNLOOP(<error reading variable>) at
.\include\application.inc:1395
#25 TWIDGETSET__APPRUN(0x4243f0 <TAPPLICATION__RUNLOOP>, <error
reading variable>) at .\include\interfacebase.inc:54
#26 TAPPLICATION__RUN(<error reading variable>) at
.\include\application.inc:1383
#27 main at NewTicketLz.lpr:23

----------------------------------------------------------------------
luizbellow · 2016-05-04 03:49

Hi,

I'm having exactly the same problem as you, have you already solved
it?

----------------------------------------------------------------------
Jurassic Pork · 2016-05-04 23:58

hello,
i have no problem with a tdbgrid , TIbConnection (connected to a
firebird embedded database version 2.5.5) , TSQLQuery  ( select * from
DeadlyMushrooms).  Lazarus 1.6.0  FPC 3.0   32 bits on Windows 7 64
bits.

Friendly, J.P