SQLite error (cannot find lSQLite) with C code block

[kapilv]

Hello,

I am trying to implement a C Block to read Database of the SQLite.
Code wise it is okay, but when I tried to build application it gets into this error ‘cannot find lSQLite’.
I am not a C programming expert; it look like it couldn’t find SQLite library. I searched many places to look how I can add this library into Logi.CAD 3.
Could you please provide me some documentation or instructions to add this kind of libraries on my program? Or is it something else?

Attached is error and program screenshot.

Appreciate!

[Walter]

Hello Kapilv,

thank you for your post!
For further analysis we would need your iSQLite library for Raspberry Pi. Please provide it to us.

thank you and kind regards
Walter

[kapilv]

Somehow I resolve that error; but it started complaining about these now.
Attached is the library and project file. Please also see the screenshot of the compiler error below.

[Walter]

Hello,


i think we were able to solve the problem. The project needs to look like (screenshot: projectview). The settings needs to have other values (see: settings)


kind regards
Walter

[kapilv]

Thanks a lot Walter!

It worked! You made my day. I spent about 2 weeks and I was keep fighting with errors after error.
I can read SQLite database from Revolution Pi; that’s remarkable.

Thanks again!

Cheer!