"Recompiling SQLite3DS" checksum changed
lazarus / 16-Databases

----------------------------------------------------------------------
shadow · 2013-06-06 19:05

Hello everyone!

While working on my project suddenly I got this compiling/linking
error messages:
QuotePPU Loading C:\lazarus\fpc\2.6.2\units\i386-win32\fcl-
db\sqlite3ds.ppu
Recompiling Sqlite3DS, checksum changed for SQLite3 {impl}
frmmain.pas(8,22) Fatal: Can not find Sqlite3DS used by FrmMain,
ppu=C:\lazarus\fpc\2.6.2\units\i386-win32\fcl-db\sqlite3ds.ppu,
package sqlite3laz

Does anyone know what this means? I'm new to Lazarus (FPC) and really
lost with this kind of problem.

----------------------------------------------------------------------
marcov · 2013-06-06 19:28

It most probably means you have duplicate units in your searchpaths.

E.g. you put the source in the unit instead of the browse path.

----------------------------------------------------------------------
shadow · 2013-06-06 19:34

I have included the SQLite-Wrapper from
https://github.com/plashenkov/SQLite3-Delphi-FPC

Now I have removed the uses, but it still doesn't work ... Do I have
to clear cache or something else?

----------------------------------------------------------------------
shadow · 2013-06-06 19:38

Ah, I've removed the lib-directory in the source path. Now it compiles
in the normal way.

Damn, any idea how I can use the SQLite wrapper, too?

----------------------------------------------------------------------
eny · 2013-06-06 19:46

Quote from: shadow on June 06, 2013, 09:38:02 pmDamn, any idea how I
can use the SQLite wrapper, too?
Doesn't the example folder give any hints on how to use it in your own
programs?

----------------------------------------------------------------------
shadow · 2013-06-06 19:53

QuoteDoesn't the example folder give any hints on how to use it in
your own programs?Sure, there is a well explained example included.
But it seems that the usage of the SQLite3 wrapper results in
conflicts with the implementation of the TSQLite3Dataset 

Well, I think I have to pass on the wrapper. Thank you both for your
help!

----------------------------------------------------------------------
eny · 2013-06-06 20:03

It's good to know this exists though.
Looks a lot like my own wrapper I created a while ago; needed BLOB
support and the return values of autoincrement columns and both where
not supported at the time (not sure if they are atm).

----------------------------------------------------------------------
Pascaluvr · 2013-06-07 02:52

Quote from: shadow on June 06, 2013, 09:53:36 pmQuoteDoesn't the
example folder give any hints on how to use it in your own
programs?Sure, there is a well explained example included. But it
seems that the usage of the SQLite3 wrapper results in conflicts with
the implementation of the TSQLite3Dataset 

Well, I think I have to pass on the wrapper. Thank you both for your
help!

Very strange.  I have used sqliteWrapper and the SQLdb components
simultaneously on the same DB without conflict.

As background ...  i was using the SQLITE FTS (Free Text Search)
option and found that the SQLdb components would restrict the display
size of a document to 256 bytes - so having identified the document I
wanted, I used the wrapper to Select the full document.

If you can give more info perhaps I can help;

----------------------------------------------------------------------
LuizAmérico · 2013-06-12 20:35

The problem is not specific to Sqlite3DS (TSqlite3Dataset). Any
package that depends of fpc native sqlite3 unit will have the same
problem.

This occurs because the compiler find fpc sqlite3 unit and then find
sqlite3 wrapper unit. Since the checksum of the two units does not
match, the compiler tries to recompile Sqlite3DS.

Most of the time removing the package unit (sqlite3laz) from uses
clause of main project file, resolves the issue.