Hey Dan, Please be patient with my English. I wonder if you would like to tell me what I am doing wrong. I use Borland C++ Builder 3.0, but it seems impossible to me to get sqlite3 up and running. I have included the sqlite3.c file in my project. But the compiler reports some errors. The same goes with the command line compiler bcc32. So I have tried to do like Nick Shaw, use the dll. But that fails too, owing to linker problems. Are you willing and able to support me? I very much like the possibility SQLITE provides to call funcions in code. I also prefer to link it in the executable file, like you recommend beneath. Kind regards Peter Wallmander
>----Ursprungligt meddelande---- >Från: danielk1...@gmail.com >Datum: 2009-12-24 12:30 >Till: "General Discussion of SQLite Database"<sqlite-users@sqlite.org> >Ärende: Re: [sqlite] sqlite3_prepare_v2 > > >On Dec 24, 2009, at 5:46 PM, Nick Shaw wrote: > >> I'd suggest having your own sqlite3.dll in your own application's >> working folder, rather than relying on an existing version somewhere >> on the PC already which could be any version! >> >> If you created your own DLL, why would you then want to statically >> link to it (defeating a lot of the point of a *dynamic* load >> library)? That doesn't provide you with any back/forwards >> compatibility. Why not dynamically load the sqlite3.dll and the >> required functions at runtime instead? If the functions can't be >> found on the load, you would then be able to handle it gracefully >> and inform the user, rather than having the prompt of a procedure >> entry point error, which means nothing to non-programmer users. > >Yet if you compile sqlite3.c in statically, then there is >no chance at all that you will fail to find the required >functions. And it guarantees that your app always runs with >the same version that you tested with. Compiling SQLite in >statically will only add 250KB or thereabouts to your binary. > >What are the advantages of using a DLL if you store it in >the application's folder and don't expect any apps other >than yours to use it? > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
