Recent

Author Topic: Simple Query com TDBGrid and SISGEV  (Read 2639 times)

jwest

  • New Member
  • *
  • Posts: 38
Simple Query com TDBGrid and SISGEV
« on: March 16, 2016, 02:23:30 pm »
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

  • Newbie
  • Posts: 2
Re: Simple Query com TDBGrid and SISGEV
« Reply #1 on: May 04, 2016, 05:49:48 am »
Hi,

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

Jurassic Pork

  • Hero Member
  • *****
  • Posts: 1228
Re: Simple Query com TDBGrid and SISGEV
« Reply #2 on: May 05, 2016, 01:58:49 am »
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
Jurassic computer : Sinclair ZX81 - Zilog Z80A à 3,25 MHz - RAM 1 Ko - ROM 8 Ko

 

TinyPortal © 2005-2018