[fpc-pascal]problem with FPC 1.9.4 about sqlite

[Michael Van Canneyt]

On Tue, 13 Jul 2004, [gb2312] Zhong Wang wrote:

> Hello, everyone,
>
>   I find there're some problems with sqlite on FPC
> 1.9.4. My OS is Fedora Core 2 with kernel of 2.6.5.
>
>   First, it dosen't support sqlite 3.0. It seems that
> the interface API changed.

This is quite possible.
It means the sqlite unit must be rewritten. There is a sqlite for delphi
project somewhere (sqlite4delphi?), they probably have the latest header
translations, maybe you can try to compile that ?

>
>   Second, the test codes under fpc source about sqlite
> can be compiled with sqlite 2.8.14, but when running,
> it exits and reports:
>
> ---------->
> Creating class
> An unhandled exception occurred at 0x55045E8D :
> EAccessViolation : Access violation
>   $55045E8D
>   $55047948
>   $FEFFF438
>   $46464546
> <----------
>
>   And I notice that it creats a zero-length file:
> -rw-r--r--   1 kennywang kennywang      0  7ÔÂ 13
> 11:30 test.db
>
>   So, what's the problem? Can anyone help me?

As far as I remember, the database must already exist before
trying the test program. But I must check this, it's a long time since I
tried it.

Michael.