Program stopped working...
lazarus / 16-Databases

----------------------------------------------------------------------
Stygian · 2016-08-24 06:59

Dear Everyone,

I'm facing with the following error. I have a master database and two
different program connected to it.
One is only reading, the other is read/writing.

Functions:
 1st: Only reads data and display on a big screen. Refresh itself
every 5min(i used a timer for it, sqlite don't have EventAlerts)
 2nd: This is the input window where you provide the data for the big
screen display.

So with the 2nd one there is no problem at all it's works like a
charm, but the 1st one is collapse every time a new data inserted or
sometimes randomly.

Can it be cause of the timer?
I mean someone input something at the same time the table reads?

Any idea?

Thanks
Sty.

----------------------------------------------------------------------
balazsszekely · 2016-08-24 07:23

QuoteCan it be cause of the timer?Not likely, although it's hard to
say without seeing code.

QuoteI mean someone input something at the same time the table
reads?That shouldn't be a problem. In a worse case scenario, you won't
be able to see the last inserted record. No reason for collapse.

Quotebut the 1st one is collapse every time a new data inserted or
sometimes randomly.
What do you mean be collapse? No SIGSEV? No error message? The
application just closes itself?

QuoteOnly reads data and display on a big screen. Refresh itself every
5min(i used a timer for it, sqlite don't have EventAlerts)Try to close
the connection before refreshing and see what happens.

----------------------------------------------------------------------
Stygian · 2016-08-24 07:38

QuoteWhat do you mean be collapse? No SIGSEV? No error message? The
application just closes itself?The "programname.exe" stopped working
something like this:
https://bd23.https.cdn.softlayer.net/80BD23/142.4.51.106/blog/wp-
content/uploads/2009/08/stopped_working_no_WER.png

QuoteTry to close the connection before refreshing and see what
happens.Do you mean i refresh the table with SQL statements?

----------------------------------------------------------------------
balazsszekely · 2016-08-24 07:57

QuoteThe "programname.exe" stopped working something like this:
https://bd23.https.cdn.softlayer.net/80BD23/142.4.51.106/blog/wp-
content/uploads/2009/08/stopped_working_no_WER.pngThat's not very
helpful. You should run the project from inside the Lazarus IDE, with
Notify on Lazarus Exception(Tools-->Options-->Debugger-->Language
exceptions) checked, and see what happens.

QuoteDo you mean i refresh the table with SQL statements?No! Close the
connection, reopen the query, datasource,  etc.

----------------------------------------------------------------------
Stygian · 2016-08-24 10:58

The query, datasource...etc close and reopening sloved the problem.

Thank You.