Re: [sqlite] Doesn't update return wrong code while there isn't record in table?

Thank you for you reply, :) But I see the return errmsg is "unknown error" on sqlite3.6.23-1. What does it mean? Kees Nuyt wrote: > > On Mon, 24 May 2010 01:27:05 -0700 (PDT), liubin liu > <7101...@sina.com> wrote: > > >> Doesn't update return wrong code while >> there isn't record in

Re: [sqlite] network access problem

>Running in sqlite application in Virtual Box, attempt to open a >database with sqlite from a shared network folder >\\Vboxsvr\testdata however the open16 and openv2 (with read >only) both fail --- rc = 14. File opens file if moved locally to >hard drive. > >using latest version of sqlite3

Re: [sqlite] network access problem

On Mon, 24 May 2010 11:28:04 -0700 (PDT), Art wrote: >Running in sqlite application in Virtual Box, attempt to open a database >with sqlite from a shared network folder \\Vboxsvr\testdata >however the open16 and openv2 (with read only) both fail --- rc = 14. >File opens

Re: [sqlite] Index not used in simple alias-like views

Op 24-mei-2010, om 17:59 heeft Dan Kennedy het volgende geschreven: > > On May 24, 2010, at 6:14 PM, Edzard Pasma wrote: > >> Hello, I found a blind spot of the query optimizer. This appears when >> a table is accessed as a view. I think the problem can be phrased as >> "the optimizer failing to

Re: [sqlite] network access problem

I just tried -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Monday, May 24, 2010 2:37 PM From: sqlite-users-boun...@sqlite.org on behalf of Art Sent: Mon

Re: [sqlite] network access problem

That's not a valid file path for open(). You need to mount the share as a drive before you can use it. Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Art Sent: Mon 5/24/2010 1:28 PM To:

[sqlite] network access problem

Running in sqlite application in Virtual Box, attempt to open a database with sqlite from a shared network folder \\Vboxsvr\testdata however the open16 and openv2 (with read only) both fail --- rc = 14. File opens file if moved locally to hard drive. using latest version of sqlite3 3.6.23.1

Re: [sqlite] Index not used in simple alias-like views

On May 24, 2010, at 6:14 PM, Edzard Pasma wrote: > Hello, I found a blind spot of the query optimizer. This appears when > a table is accessed as a view. I think the problem can be phrased as > "the optimizer failing to push an outer join predicate into a > view"... This simply means that the

Re: [sqlite] Strange SQLITE_FULL error

If you'll note in the code it does set lastErrno to the GetLastError() return. Hopefully you have control of the code so you can add an "sqlite3_file_control" call to see what's going on. You should be able to do this when you get the SQLITE3_FULL return code. int errnum;

[sqlite] Index not used in simple alias-like views

Hello, I found a blind spot of the query optimizer. This appears when a table is accessed as a view. I think the problem can be phrased as "the optimizer failing to push an outer join predicate into a view"... This simply means that the following example does not use the existing index:

[sqlite] Strange SQLITE_FULL error

I'm coming accross a weird error from some deployed code. Several users occassionaly get an unexpected SQLITE_FULL error on calls to sqlite3_step(). It happens infrequently, and I've not been able to reproduce. First some background: - Windows only (seen on XP and Vista) - sqlite version

Re: [sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as not signed"

On Fri, 21 May 2010 21:32:13 -0400, Rich Rattanni wrote: >BloodShed Dev-C++ and ming? My choice for windows development. > >On Fri, May 21, 2010 at 11:01 AM, Richard Hipp wrote: >> This appears to be a bug in your compiler.  The compiler is segfaulting. >>

Re: [sqlite] Doesn't update return wrong code while there isn't record in table?

On Mon, 24 May 2010 01:27:05 -0700 (PDT), liubin liu <7101...@sina.com> wrote: > Doesn't update return wrong code while > there isn't record in table? No. Your update tells SQLite to update all rows in the selection. It did. In this case "all" meaning zero, but that is not an error. Think of

Re: [sqlite] What languages can include SQLite statically?

Gilles, For Delphi I successfully used files from http://www.aducom.com to statically link sqlite files compiled with bcc (Borland command-line c compiler freely available now) with Delphi. Also the components of aducom.com will allow you to use all the power of Delphi database components with

[sqlite] Doesn't update return wrong code while there isn't record in table?

Doesn't update return wrong code while there isn't record in table? Is it normal action? _code__ #include #include void create_db (void); int main (void) { int ret = -1; create_db (); sqlite3 *db = NULL; ret = sqlite3_open