Re: [sqlite] SQLite and Qt

[Sylvain Pointeau]

On Wed, Jun 16, 2010 at 3:42 PM, Sam Carleton 
>
> The error was between the keyboard and the chair...  Once the SQLite
> DLL was moved into the Qt bin directory, all worked as expected.
>
> :-)


> Thus the answer to my question would seem to be:  Qt will simply use
> the SQLite3.lib you give it, if it is to link to a DLL, you need to
> make sure Qt can find the DLL.
>
> sure, I am happy that your problem is solved.

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Qt

[Sam Carleton]

On Tue, Jun 15, 2010 at 7:11 AM, Sylvain Pointeau
 wrote:
> Hi,
>
> What is the error?
> did you make a sample project that you could share?

The error was between the keyboard and the chair...  Once the SQLite
DLL was moved into the Qt bin directory, all worked as expected.

Thus the answer to my question would seem to be:  Qt will simply use
the SQLite3.lib you give it, if it is to link to a DLL, you need to
make sure Qt can find the DLL.

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Qt

[Sylvain Pointeau]

Hi,

What is the error?
did you make a sample project that you could share?

Best regards,
Sylvain

On Tue, Jun 15, 2010 at 1:11 AM, Sam Carleton <scarle...@miltonstreet.com>wrote:

> Sylvain,
>
> I have given it a try and it isn't working.  First a quick questions:
> Is qsqlite.dll statically linked to the sqlite code or dynamically
> linked?  The sqlite3.lib I am trying to link to is the for dynamically
> linking, aka requiring the sqlite3.dll.  I am guessing that is the
> issue, but since it will take me a while to spin up a statically
> linked version of the lib, I thought I might ask before running down
> that rat whole;)
>
> Sam
>
> On Wed, Jun 9, 2010 at 4:20 AM, Sylvain Pointeau
> <sylvain.point...@gmail.com> wrote:
> >
> > build your qt sqlite as a plugin
> > then recompile this plugin with the version you want.
> >
> >
> http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above
> >
> > best regards,
> > Sylvain
> ___
> 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

Re: [sqlite] SQLite and Qt

[Sam Carleton]

Sylvain,

I have given it a try and it isn't working.  First a quick questions:
Is qsqlite.dll statically linked to the sqlite code or dynamically
linked?  The sqlite3.lib I am trying to link to is the for dynamically
linking, aka requiring the sqlite3.dll.  I am guessing that is the
issue, but since it will take me a while to spin up a statically
linked version of the lib, I thought I might ask before running down
that rat whole;)

Sam

On Wed, Jun 9, 2010 at 4:20 AM, Sylvain Pointeau
<sylvain.point...@gmail.com> wrote:
>
> build your qt sqlite as a plugin
> then recompile this plugin with the version you want.
>
> http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above
>
> best regards,
> Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Qt

[Sylvain Pointeau]

build your qt sqlite as a plugin
then recompile this plugin with the version you want.

http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above

<http://doc.trolltech.com/4.6/sql-driver.html#qsqlite-for-sqlite-version-3-and-above>best
regards,
Sylvain

On Wed, Jun 9, 2010 at 4:32 AM, Sam Carleton <scarle...@gmail.com> wrote:

> On Tue, Jun 8, 2010 at 10:25 PM, Bill King <bill.k...@nokia.com> wrote:
>
> >
> > >
> > >1. How do I control the version of SQLite used with Qt?
> > >
> > ./configure -system-sqlite will use the sqlite compiled for your system.
> >
>
> No, not how do I compile SQLite into Qt, I have done that.  I want to
> control the VERSION.  I don't know if the distro of Qt is using the latest
> version of SQLite or not.  Also, if I opt to NOT upgrade the Apache server,
> I would like Qt to use the same version of SQLite that the Apache server is
> using ;)
>
> Sam
> ___
> 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

Re: [sqlite] SQLite and Qt

[Sam Carleton]

On Tue, Jun 8, 2010 at 10:25 PM, Bill King <bill.k...@nokia.com> wrote:

>
> >
> >1. How do I control the version of SQLite used with Qt?
> >
> ./configure -system-sqlite will use the sqlite compiled for your system.
>

No, not how do I compile SQLite into Qt, I have done that.  I want to
control the VERSION.  I don't know if the distro of Qt is using the latest
version of SQLite or not.  Also, if I opt to NOT upgrade the Apache server,
I would like Qt to use the same version of SQLite that the Apache server is
using ;)

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Qt

[Bill King]

On 06/09/2010 11:52 AM, ext Sam Carleton wrote:
> I have been using SQLite for a few years now in an Apache server module and
> it works great for me.  The system is expanding, I am working on a Qt based
> GUI program that needs to access the SQLite database.  (The Qt program is
> only going to run on the same machine as the Apache Server.)
>
> If I am not mistaken, the version of SQLite used by the Apache server is
> 3.5.???.  I would like to start taking advantage of the foreign key feature
> of v3.6, which is my question:
>
>1. How do I control the version of SQLite used with Qt?
>   
./configure -system-sqlite will use the sqlite compiled for your system.
>2. How do I get the version of SQLite from both the native API and from
>Qt?
>3. How do I set the foreign key pragma in Qt?
>   
Just using QSqlQuery's exec function should work fine to exec "PRAGMA
foreign_keys = ON"
> Sam
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>   


-- 
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite and Qt

[Sam Carleton]

I have been using SQLite for a few years now in an Apache server module and
it works great for me.  The system is expanding, I am working on a Qt based
GUI program that needs to access the SQLite database.  (The Qt program is
only going to run on the same machine as the Apache Server.)

If I am not mistaken, the version of SQLite used by the Apache server is
3.5.???.  I would like to start taking advantage of the foreign key feature
of v3.6, which is my question:

   1. How do I control the version of SQLite used with Qt?
   2. How do I get the version of SQLite from both the native API and from
   Qt?
   3. How do I set the foreign key pragma in Qt?

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users