Is there any reason not to incorporate the diff posted for ticket 2869 into
the main branch and have sqlite3_open16_v2()?
- Sherief
___
sqlite-users mailing list
sqlite-users@sqlite.org
The documentation found at http://sqlite.org/c3ref/exec.html is unclear
about some parts: is it possible to not request an error message (via
passing NULL as the errmsg parameter)? And what are the possible return
values?
- Sherief
___
sqlite-users
> Hi - it only happens on Windows systems that are using U3 USB keys.
> None of
> the queries are intensive - they are pretty simple and shouldn't take
> longer
> than a few milliseconds.
>
> On harddisks it *always* works. Never had an issue there.
>
Like Teg said, you can use procmon in
On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote:
> Can someone please give me a suggestion for a good client for CVS
> that runs
> under Windows?
>
> I have my linux system but figured it would be nice to have a client
> in both
> places, a belt and suspenders kind of
Try TortoiseCVS.
- Sherief
On Feb 26, 2009, at 16:28, "J. R. Westmoreland" wrote:
> Can someone please give me a suggestion for a good client for CVS
> that runs
> under Windows?
>
> I have my linux system but figured it would be nice to have a client
> in both
> places, a
> Here is what I did
>
> I downloaded
> sqlite-3_6_10.zip 245,575 bytes
> which unzipped to
> sqlite3.exe501,456
Why not post a cryptographic hash of the exe file you have, and the output
of the "ver" command when ran from your "command prompt".
- Sherief
> dear users
> I use sqlite for vb6, utf-8 database,
> when insert arabic data to database
> and search it with 'like' operator
> (within % syntax), return all records!!!
> Please help me...
> thanks
> John Smith
> ___
Arabic, in general, is one hell of
> SAVEPOINTs is the way PostgreSQL and MySQL do it, as well as many
> other SQL database engines. We want to maximize compatibility.
>
> We have discussed letting you used named transactions using BEGIN. We
> might add that in the future. But for now, SAVEPOINT seems to be the
> safest way to
> Preliminary documentation can be seen at
> http://www.sqlite.org/draft/lang_savepoint.html
Why savepoints? Why not just add support for named transactions? Is there
some semantic difference I'm missing?
- Sherief
___
sqlite-users mailing list
> The given code is correct. The lower-case string is a C# alias for the
> System.String class. System.Int64 is an opaque 64-bit pointer value.
Seems like the grasping deficiencies are on my side :D.
> The code so far is correct. What is missing though is the calling
> convention, which by
> I am calling now this:
>
> [DllImport("sqlite3.dll", CharSet = CharSet.Unicode)]
> internal static extern System.Int64 sqlite3_open16(string
> filename, out IntPtr handle);
>
> I now finds an entry point, but i returned to the previous error:
> An attempt was made to read
>
> It throws an exception: unable to find entry point sqlite3_open16
Try opening the DLL with Dependency Walker, make sure the entry point *is*
there?
- Sherief
___
sqlite-users mailing list
sqlite-users@sqlite.org
> SET( CMAKE_INSTALL_PREFIX "f:/doof" )
This *will* cause problems for some people ;).
Otherwise, I love CMake, so I'm all for this. Any chance a stable CMake file
would be hosted on sqlite.org?
- Sherief
___
sqlite-users mailing list
Does sqlite3_open fail too?
- Sherief
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> Hi,
>
> Sherief, thank you for our kind help.
You're welcome :).
> I really did use globals.
> I found a way to run DumpMemorLeaks after all globals and static
> variables are deallocated, I used
> _CrtSetDbgFlag(_CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF);
I should've RTFMed harder :(.
>
> I really don't see any way to use _CrtDumpMemoryLeaks(). It always
> shows hundreds of blocks even if I'm sure that nothing was allocated
> (no malloc or new). I know that this is not a place to learn how to
> use VC++. Maybe it's true that Deleaker just freaks out. I will try to
> track it
> I found that win function FlushFileBuffers (used by SQLite) slows down
> performances,
> but still don't have explanation why this funcion on some machines
> works 10x slower then on others.
>
> I have used win xp sp2 on all machines where I have tested the
> behaviour.
Try using CodeAnalyst,
> SQLite also does some "interesting" things with pointers. There are
> a few areas of the code where an array of memory is allocated and
> then the pointer is backed up a record (under-running the allocated
> space)
> to make the array 1-based rather than 0-based. All of the access is
>
> The problem is that I'm getting better performance on AMD machine with
> ATA disk,
> but 10 times slower on DualCore machine with SATA disk (both disks are
> at 7200 rpm)...
> I don't understand the source of this behaviour...
OS? Tried VSTS profiler, VTune or the free CodeAnalyst to look at
> As you can see I use sqlite3_prepare/sqlite3_finalize pairs. My memory
> leak checker ( Deleaker : www.deleaker.com ) reports memory leak at
> sqlite3_prepare :
>
> msvcrt.dll!malloc
> sqlite3.dll!sqlite3_malloc + 120 bytes
> sqlite3.dll!sqlite3_realloc + 27 bytes
>
> I have a problem with BLOB writing. I need to write
> some binary stream into sqlite table. As I understood, incremental
> BLOB I/O requires space of constant size to be preallocated
> with zeroblob, but I don't know the size of stream in advance.
> And sqlite doesn't allow to change the size of
> I have the DevKit and all the goodies and am able to make the DS jump
> though
> hoops. But I always have trouble with SQLite. I'm one of those who gets
> the
> very irritating huge numbers of compile errors that have something to
> do with
> compiler version versus SQLite version versus header
> Has anyone used SQLite on the NintendoDS? Can it fit? Arm7 and ARM9 and
> a
> cartridge like an SD card. The database can be static in FLASH. But the
> rest?
>
> -- Charlie Springer
>
[Sherief N. Farouk]
If you have an official devkit, or care to grab a copy of the
> > Sqlite3_bind_text(Statement, S.c_str(), S.size() + 1,
> > SQLITE_[TRANSIENT | STATIC?]);
>
> Drop +1. It's unlikely that you actually want terminating NUL to be
> part
> of the string in the database.
>
Sorry, mixed that one with the nByte parameter of prepare_v2. It's "-1" in
code though,
Does the bind text family attempt to access the data pointed to by the
passed parameter after the lifetime of the function call? I have a situation
similar to the following:
Std::string S("Blah");
foo(S);
Rest_of_program();
Where foo() is:
Void foo(string& S)
{
//prepare a statement
I agree with Michael. Some of these warnings can be stopped with trivially
small code modifications, and they do try to prevent human error. Consider
this line (from my 3.5.9 amalgamation):
X1 = 365.25*(Y+4716); //X1 is an int
Which produces the following warning in VC++2008:
warning C4244: '='
> What do you mean by "Mapping". There are several api wrappers for
> sqlite written in C++. See
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
>
After checking some of the things on that list, ruling out some for
superficial reasons (like thinking that C++ is Java and writingLikeThis),
se of licence of sqlite server
>
> kindly send me the detail
>
> arvind
> systime
[Sherief N. Farouk]
Dear Pointy Haired Boss,
Please let Dilbert handle this one instead.
Best Regards,
- Sherief
(I'm sorry. I saw this and I just couldn't resist. I deserve everyt
ns very minimal,
> but
> Vista itself eats every last scrap of physical memory, forcing all
> other
> apps to the paging file trying to cache the contents of the database.
[Sherief N. Farouk]
Any chance you could make a small C program to reproduce this case (via
procedurally creating
TECTED] [mailto:sqlite-users-
> [EMAIL PROTECTED] On Behalf Of Dan
> Sent: Friday, July 25, 2008 3:22 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Hard time with blobs
>
>
> On Jul 25, 2008, at 12:05 PM, Sherief N. Farouk wrote:
>
> > I'm havi
2008, at 10:35 AM, Sherief N. Farouk wrote:
>
> > I want to use blobs to store binary objects in the database, but
> > I'm having
> > a hard time understanding how they work. First of all, I don't see
> > a way to
> > set a blob's size, and sqlite3_blob_write doe
I want to use blobs to store binary objects in the database, but I'm having
a hard time understanding how they work. First of all, I don't see a way to
set a blob's size, and sqlite3_blob_write doesn't increase the size of the
blob, which is putting me in a weird catch-22 situation.
What's the
nnis Cote
> Sent: Wednesday, July 23, 2008 10:22 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Transaction Files / SQLite?
>
> Sherief N. Farouk wrote:
> >
> > Streams are parallel 'bags of bytes' of a file. As in, you can
> > open(&quo
ade things clearer.
- Sherief
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:sqlite-users-
> [EMAIL PROTECTED] On Behalf Of Dennis Cote
> Sent: Wednesday, July 23, 2008 9:46 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Transaction Files / SQLite?
>
Can you define a custom less-than operator for sorting? If this were C++,
I'd do std::sort(Result.begin(), Results.end(), MyCustomOperator());
- Sherief
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:sqlite-users-
> [EMAIL PROTECTED] On Behalf Of Andrew Gatt
> Sent: Wednesday,
I'm currently trying to port an application that does a lot of work based on
two NTFS features: Streams, and Transactional NTFS. Since TxF is a HUGE
feature, with a lot of potential pitfalls, I thought I might do this as a
layer over SQLite: a db file with one table, multiple rows: one for each
or airline points just for searching! Hit the link
> below to join for free and we will both get points!
>
> http://scour.com/invite/harishdixit1/
>
> I know you'll like it!
>
> - harish
[Sherief N. Farouk]
Are you, seriously: spamming a development mailing list, using your
@
a
> difference
> between these two things, but it doesn't matter in this context where
> all you want is to get an exported name exactly as it is in your code).
>
> Igor Tandetnik
>
[Sherief N. Farouk]
The decoration is due to the stdcall convention (APIENTRY). It's in
38 matches
Mail list logo