TSqlite3Dataset dgMultiselect DBGrid insert error
lazarus / 16-Databases

----------------------------------------------------------------------
asterixik · 2015-09-11 12:38

I use Lazarus 1.4.2
Sqlite3Dataset1 -> DataSource1 -> DBGrid1
When I turn on the dgMultiselect option in  DBGrid and then try to add
(append) record in SQlite3Dataset I see error message with "External
SIGSEGV...". Assembler stop on CUSTOMSQLITEDS_TCUSTOMSQLITEDATASET_$__
COMPAREBOOKMARKS$POINTER$POINTER$$LONGINT

A simple example in the archive.

----------------------------------------------------------------------
Jurassic Pork · 2015-09-11 13:25

hello asterixik,
how do you add a record in your database ? you have no button or
tdbnavigator to do that in your form 

Friendly J.P

----------------------------------------------------------------------
asterixik · 2015-09-11 13:37

Hi
I tested 3 variants:
DBNavigator "New record" buttonSqlite3Dataset1.Append methodSelect 
last row in DBGrid1 and press DOWN key (in sample zip) and have 1
result: SIGSEGV

----------------------------------------------------------------------
Jurassic Pork · 2015-09-11 15:00

Same thing for me 

try to unselect all the rows before the add.

For example with the tdbnavigator  try this code on the beforeaction
event :
Code: [Select]procedure TForm1.DBNavigator1BeforeAction(Sender:
TObject;
  Button: TDBNavButtonType);
begin
  DbGrid1.SelectedRows.CLear;
end;

----------------------------------------------------------------------
LuizAmérico · 2015-09-11 22:32

AFAIK, it was fixed in fpc version 3.0

You can use with fpc 2.6.4 see
http://sqlite4fpc.yolasite.com/download.php

----------------------------------------------------------------------
asterixik · 2015-09-14 06:48

I used TSqlite3Dataset 3.0 (install via Replace the default binary
units), but when run and try add record I see SIGSEGV also :-(

Assembler screenshoot attach

----------------------------------------------------------------------
asterixik · 2015-09-17 10:18

Anybody has any idea?

----------------------------------------------------------------------
LuizAmérico · 2015-09-17 13:19

See http://bugs.freepascal.org/view.php?id=28688

----------------------------------------------------------------------
asterixik · 2015-09-18 05:24

Quote from: LuizAmérico on September 17, 2015, 03:19:16 pmSee
http://bugs.freepascal.org/view.php?id=28688
Thanks

----------------------------------------------------------------------
asterixik · 2015-09-21 11:42

Now an SIGSEGV error message when I edit an existing record

----------------------------------------------------------------------
LuizAmérico · 2015-09-27 12:16

Sorry for the delay. The fix required considerable amount of work

Try the latest version found at
http://sqlite4fpc.yolasite.com/download.php

It should fix both issues