Alan Mead wrote:
I just want some fairly light-weight sqlite3 bindings that work on
Linux and Windows. The code on the SQLite website works great on
Windows but fails to compile on Linux. (I don't know Windows API
calls... it looks like he's searching for a function name in the
DLL.)
Are you failling to compile the sqlite library itself or the fpc binding
(sqlite3.pas)?
The fpc binding does not depend of an other library except the sqlite itself
I've tried a few other solutions and they have either not worked
cross-platform or they are meant for Delphi and I couldn't compile
them using just FPC.
[I could use Lazarus... Is it easy to learn to use TDataSet? My
ideal would be something like Perl's DBI... prepare(), execute(),
fetch_row(), etc. I know SQL and don't need a lot of abstractions
getting in the way.]
Yes it is. I recommend read any Delphi TDataset tutorial before using
the fpc one if you are not familiar with it. Then if you choose to use
TSqliteDatset take a look at lazarus wiki at Database/Sqlite section.
You can use TDataset also in console apps. See the examples in the dir
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/
Just rename from TSqliteDataset to TSqlite3dataset and sqliteds to
sqlite3ds.
Before I try to debug one of these non-working-solutions, does anyone
know of an existing FPC (not Delphi/Lazarus) solution that works on
both Windows and Linux?
At the time i tested, both the binding and the TDataset were working in
Linux and Windows, but were a change in the binding later. I'll take a look.
You can find the newest units for sqlite3 in the svn repository:
base sqlite3 (binding):
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/packages/base/sqlite/sqlite3.pp
TDataset descendants
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/customsqliteds.pas
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/sqliteds3.pas
Luiz
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
