(SOLVED) SQLite problem (only windows)
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2011-07-11 06:17

I think I've found a few mistakes in the management of DB SqlLite, if
you take the attached code and compile it you will see that there are
4 rows in the DBGrid and if you press the button should clear the line
that contains 'pippo'. But if you close and reopen the program, there
are one less, can you tell me why? And can you tell me how to solve
it? thanks

----------------------------------------------------------------------
xinyiman · 2011-07-11 06:50

I forgot, the problem occurs only on Microsoft, I have tried both XP
(SP3) and Windows 7.

----------------------------------------------------------------------
xinyiman · 2011-07-11 08:31

Has anyone tried the attached program? Why do I get feedback from
someone if the problem is also found by others.

----------------------------------------------------------------------
marcov · 2011-07-11 09:01

Afaik if you delete an entry, you can't continue iterating over the
dataset.

----------------------------------------------------------------------
xinyiman · 2011-07-11 11:26

I do not think this is the problem, because if I run the same code
works on Linux Ubuntu, Windows is not. Also, if you look at the data
after clicking the button you will notice that they are correct. But
if I close the program and re-open I do not feel that I found all the
data before closing the program and I want to see. It seems to me a
bug.

----------------------------------------------------------------------
xinyiman · 2011-07-11 15:27

No suggestions?

----------------------------------------------------------------------
Lacak2 · 2011-07-12 07:42

For me it works, row with 'pippo' is deleted and rows with
'ciao','carlo' and 'pollon remains'
Which version of FPC do you use ?

----------------------------------------------------------------------
jixian.yang · 2011-07-12 08:19

The row was deleted is Id1='1' and Id2='1'. There is no problem.

----------------------------------------------------------------------
xinyiman · 2011-07-12 08:36

But the data will remain even if you close and reopen the program?
Because until you run the code of the button and then close and reopen
the program the problem does not occur. However, the data are:

Version #: 0.9.30
Data: 2011-03-08
Version FPC: 2.4.2
Revision SVN: 29749
i386-win32/win64

----------------------------------------------------------------------
Lacak2 · 2011-07-12 13:46

IMO it is bug in FPC 2.4.2, which is fixed now (FPC 2.4.4 and later).
See http://bugs.freepascal.org/view.php?id=16493

----------------------------------------------------------------------
xinyiman · 2011-07-12 13:54

Got it, thanks a lot.

----------------------------------------------------------------------
xinyiman · 2011-07-12 14:29

Quote from: Lacak2 on July 12, 2011, 03:46:15 pmIMO it is bug in FPC
2.4.2, which is fixed now (FPC 2.4.4 and later).
See http://bugs.freepascal.org/view.php?id=16493

Solved, Thanks a lot