Sqlite3 Operation can't performed on inactive data set
lazarus / 16-Databases

----------------------------------------------------------------------
BlueIcaro · 2010-10-27 09:18

Hello, I have app with many sqlite tables, one of those have three
lookup three.  When I start my app it's works nice. Then I add some
dato to this database, using a form with some datalookup components,
and it's works.

I close the app, my app on close events, close the the database. Then
when I run again my app. show the error. Also if I try to open the
database using the sqlite component I got the same error.

Only I can do, is create the table again, using the component, but I
lost the data stored.

What happen?

I use lazarus 0.9.29 svn: 27806 adn fpc: 2.4.3

Thanks

/Jorge

----------------------------------------------------------------------
xenblaise · 2010-10-28 01:39

One possible solution is to use the sqldb components but do not
initialize in the properties, instead?, do a manual coding, calling it
from form_load.
eq.
SQLConnection1.Databasename := 'xxxx';
SQLTransaction1.Connection := SQLConnection1;
SQLQuery1.Connection := SQLConnection1;
Datasource1.Dataset := SQLQuery1;
DBGrid1.Datasource := Datasource1;

----------------------------------------------------------------------
BlueIcaro · 2010-10-28 05:48

Hello, I use sqlite3dataset and a DataSource. I don't use
Sqlconnection. But I going to change the application to use
SqlConnection, so xenablaise I'll ask in this post, if I have any
problem.

I hope I can have your help xenablaise.

/BLueIcaro

----------------------------------------------------------------------
BlueIcaro · 2010-10-28 07:33

I did some test. If I delete de field in object inspector I can open
the database.

/BlueIcaro

----------------------------------------------------------------------
BlueIcaro · 2010-10-28 08:09

I use sqlite3dataset, and SqlQuery, and when I do the sql order:
Select * from tbTrabajos;

I got a error: ID unkonw type fo fied

I create ID field is autoinc

Any help?

/BlueIcaro

P.D: Used:  create table tbclientes (id 'autoinc' nombre varchar(30));

----------------------------------------------------------------------
xenblaise · 2010-10-28 08:39

QuoteI use sqlite3dataset, and SqlQuery,

why used 2 datasets, sqlquery is a decendant of a dataset too.
so your using 2 datasets in the same connection?

Have you visit to this link, try to find anything if it can help you,
this is also a sqlite connection.

http://wiki.lazarus.freepascal.org/User:Rocarobin

look at the way I build my code, maybe you could find it.