Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2004-07

problem with FPC 1.9.4 about sqlite

3 messages · 3 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Zhong Wang

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.

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?

Thank you so much,
Yours,

_________________________________________________________ Do You Yahoo!?
美女明星应有尽有，"一搜"搜遍美图、艳图和酷图 http://cn.rd.yahoo.com/mail_cn/tag/yisou/SIG=112a2q42r/**http%3A%2F%2Fimage.yisou.com%2F

100兆邮箱够不够用？雅虎电邮自助扩容！ http://cn.rd.yahoo.com/mail_cn/tag/100m/*http://cn.promo.yahoo.com/minisite/100m/

Michael Van Canneyt
to Zhong Wang
Show quoted text 7 lines
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 ?

Show quoted text 20 lines
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.

Ron Weidner
to Michael Van Canneyt
Show quoted text 8 lines
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 ?

There are 2 people working on this problem right now. The author of PSP (pascal server pages) and the
developer of the LibSQL. The last I heard (sometime last week) they have LibSQL working on linux and they are not far from success on Windows. This is where the project lives...

http://wiki.sqlite.dubaron.com/

Ron_W

__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail