[fpc-pascal]FPC Debugging (with SQLite)
olivier.coursiere at laposte.net
Fri Jul 11 01:54:45 CEST 2003
Hi all !
> > How so ?
> James, he did *not* port this app to BeOS, some one else did. He
> wrote a
> Pascal interface to the version that that developer had ported to
> (you're following me right ;-). He therefore had no option but to use
> version ported under BeOS, unless he ported a newer version himself,
> So therefore, he was only able to do the interface as per the version
> available to him. Therefore my comment. Do you understand? No
> Looking at the BeBits page, (http://www.bebits.com/app/3156), 2.7.1
> was the
> last port made (circa November 2002).
Under BeOS, the port is really easy : sqlite compile nearly out of the
box from official sqlite sources. I have succesfully compiled sqlite
2.8.3 two or three weeks ago (during the last thread about sqlite in
this list). Only one change was needed. I had only change
sqliteOsSleep's implementation to use snooze instead of usleep, not
available in Be's headers.
In fact, Eric's version is a quick port of TSQLIte component (available
at http://www.torry.net/db_directsql.htm) from Delphi and Windows to
FPC and BeOS (mainly removing Windows only functions and dynamic
loading). That is why his unit works under Linux. Maybe Delphi users
and FPC users under Windows should use TSQLite component directly.
Now, there is also a DBExpress driver available for Delphi users (and
maybe kylix's one with some work ?).
> > It's been fixed there was no problem with his unit other than
> > the fact that, with the current version of SQLite the cMem unit was
> > needed in order because of the way SQLite uses memory.
> Cool. Let him know ;-)
Under BeOS, this unit is not necessary as far as i know (but not well
tested, only trivials samples). If someone have some code that show
this problem (and the improved wrapper), i can test them under BeOS.
More information about the fpc-pascal