Using sqlite3 to operate the database test.db

[463017170]

Using sqlite3 to operate the database test.db

Can you help me see how to create, add, and modify a database? Thank you!

[daniel_cadext]

Maybe have a look at this project for inspiration

https://www.theswamp.org/index.php?topic=28286.0

[463017170]

Thank you for your reply! I think it should be an ARX syntax issue?

[tbrammer]

Unless I can't read the (chinese?) error messages I assume that the linker complaints about unresolved externals, right? Due to "std::basic_string<char...>" I suspect that this might be an UNICODE/ANSI issue.

[463017170]

Can you help me take a look at my code? Thank you very much！

[daniel_cadext]

The best way to approach this is to download the SQLite Amalgamation

https://sqlite.org/download.html

Setup your solution with two projects.

Compile the SQLite Amalgamation as a static library

Static link to the new library from your ARX project.

This way you won’t have any DLLs to load.

[daniel_cadext]

Here's an old project that should better illustrate, it's an old version of SQLite, you can probably just drop in the new Amalgamation

[463017170]

Thank you very much for your reply! Lisp is not familiar with it.

[daniel_cadext]

The lisp is not required, but you can see how to use it from C++

[463017170]

Can you help me modify test.rar?