> > From: Neville Franks
> implementations are meant to save
> prepared statements in a cache and IIUC most do.
Thats exactly what I am doing. I still pass the original statement every time.
The same call either creates a new statement or re-uses the cached version.
> The trend is more for fu
> From: Neville Franks
> Subject: Re: [sqlite] How do you guys use sqlite from C++?
> I use a modified version of the C++ wrapper
> http://www.codeproject.com/KB/database/CppSQLite.aspx
Apparently I did come up with an original idea. Because none of the wrappers
from the archives are using vari
I've made my own wrapper class around sqlite for executing database commands.
Its completely generic and supports the use of binds and parameter substitution
through the use of variable arguments () as well as a printf-style
format string that clues the routine into the types of the arguments.
> From: wiktor
> Subject: [sqlite] Newbie question about using SQLite with
> Windows Forms application (VS 2005 C++)
> I'm trying to build a win form application that uses
> sqlite. I have problems with making it work. I would like
> to have the sqlite source included in my project (as .h file
>
> From: candd
> I want to have a sample C source for a program that convert
> an sqlite
> data base file to xml file.
> could you help me please!
Thats a pretty broad and open ended question. What exactly are you trying to
accomplish here? Do you want to produce enough XML data so that you can
> From: John Machin
> Irrespective of what people tell you and how authoritative
> they seem, I
> would recommend that you do some simple tests:
Excellent advice! Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
> From: candd
>
> Dear All!
>
> I am new user of sqlite3
> I want to have a sample C source for a program that convert
> an sqlite
> data base file to xml file.
> could you help me please!
Hi and welcome to the group. Your problem is very easy to solve, just rename
your database file to have
c from the amalgamation and it says that >2GB file
support is enabled on POSIX if the underlying OS supports it. And "Similar is
true for Mac OS X". But there is no mention of Windows.
Anyone?
Thanks!
Sincerely,
Vinnie
___
sqlite-users ma
So I'm getting SQLITE_BUSY now. I have one thread inserting rows while another
thread tries to read a row from the same table. I had a bad implementation
where I was keeping the transaction open far longer than necessary so I think I
went over some 5 second rule? Does SQLite wait up some length
Sorry for only posting when I have a problem...but...
I'm doing
PRAGMA user_version=?;
And getting result code SQLITE_ERROR (1) from sqlite3_prepare_v2(). Of course I
can't step into the sqlite3.c code because the Visual Studio 2008 debugger gets
hopelessly confused when confronted with a fil
Sorry for asking such a basic question, and it seems I know the answer but I
would like a confirmation.
If I am executing the same SQL statement from multiple database handles to the
same database file, I still need to prepare a distinct sqlite3_stmt for each
connection, even though the SQL st
Wow man that is the page I've been looking for my whole life but didn't know
it...finally an explanation for this mess.
> From: "Igor Tandetnik"
>
> "The Absolute Minimum Every Software Developer
> Absolutely, Positively
> Must Know About Unicode and Character Sets (No
> Excuses!)"
> http://ww
> Note that both UTF-8 and UTF-16 are capable of representing
> the full range of Unicode characters. Conversion between the two is
> lossless. You seem to be under impression that UTF-8 is somehow
> deficient, only suitable for "legacy" encoding. This is not the
> case.
Yeah thats what they say.
PRAGMA statements, I see what you mean now. This is exactly what I needed,
thanks a lot.
To clarify what I am doing, my SQL statements are in UTF-8 and they are all
prepared, with parameter bindings. So table names, column names, etc.. are all
UTF-8.
However, I have table fields which will be
> From: "Igor Tandetnik"
> You could convert your file name from UTF-16 to UTF-8, then
> call sqlite3_open_v2.
Converting the file name is no problem. But I thought that depending on how you
opened the database (open16 versus open_v2), SQL treats your strings
differently. I don't care about t
Dear Group:
When my application launches I want to open the associated database, and if
that fails because the file does not exist then I would create a new database.
sqlite3_open_v2() is ideal for this purpose because you can leave out
SQLITE_OPEN_CREATE flag, and specify SQLITE_OPEN_READWRI
Michael:
While my answer isn't strictly limited to sqlite, the performance nut in me
can't help myself. You have a a table with only one column, a string. I could
be wrong here but it seems like you just want to keep a list of values that you
have already tried. After you insert a bunch of str
I have added sqlite.c to my Visual Studio 2008 project and everything seems to
be working in terms of database calls. However, when I step into an actual
sqlite routine using the debugger, the source code position is out of sync with
the actual location. For example, I step into sqlite3_open_v2
18 matches
Mail list logo