Re: [sqlite] How do I know the python functions registered on SQLite ?

Hi, Thanks Rogers ! Danke Hick ! I'll do my manual housekeeping, so. Cheers, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] duplicate row in sqlite3 database

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of RSmith > Sent: Friday, May 09, 2014 2:01 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] duplicate row in sqlite3 database > > That sounds NOTHING like a violation

Re: [sqlite] duplicate row in sqlite3 database

That sounds NOTHING like a violation error... it seems a lot more like the intermediate thing failed on communicating, but I am not familiar with it (I hope another poster might have advice) - unless it simply does not understand the serialized output. Either way it doesn't feel right to me.

Re: [sqlite] duplicate row in sqlite3 database

When I deliberately try to insert a duplicate row I get the following error from my VEE* environment: Execution of method ExecuteNonQuery in the referenced .NET object or type failed. Exception type: System.Runtime.Serialization.SerializationException Type is not resolved for member

Re: [sqlite] Foreign Key errors

After looking into error messages further, I see that the constraint name is not included in NOT NULL or UNIQUE constraint errors although it is there in CHECK constraint errors. The table.column that caused the error is in the messages so it is possible to identify which column caused the error.

Re: [sqlite] Compiling System.Data.SQLite for .NET CF 3.5 (VS2008 & WinCE 6) on x86

Eric Johnston wrote: > > The question is: How do I compile System.Data.SQLite for .NET CF 3.5 (VS2008) > with a target platform of x86 for the SQLite.Interop.092.dll? > The Windows CE 6.x SDKs that I've seen do not include support for the x86 platform. Are you aware of one that does? -- Joe

[sqlite] Spellfix Implementation

I'm using the extension module spellfix module to order tables via levenstein. I compiled spellfix.c (it's inside /ext/misc/) using MinGW for Windows: gcc -g -shared spellfix.c -o spellfix.dll It compiles successfuly but when i load it into the command line shell of sqlite: sqlite> .load

Re: [sqlite] Spellfix Implementation

On Fri, May 9, 2014 at 11:31 AM, JocOnat wrote: > I'm using the extension module spellfix module to order tables > via levenstein. > > I compiled spellfix.c (it's inside /ext/misc/) using MinGW for Windows: > > gcc -g -shared spellfix.c -o spellfix.dll > I had to add

Re: [sqlite] duplicate row in sqlite3 database

On 2014/05/09 17:58, Drago, William @ MWG - NARDAEAST wrote: -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Thursday, May 08, 2014 9:48 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] duplicate

Re: [sqlite] duplicate row in sqlite3 database

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Thursday, May 08, 2014 9:48 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] duplicate row in sqlite3 database > > On 5/8/2014 5:14 AM, techi

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

It must have been, considering other software running on these WinCE 6 devices I have are using an older version of SQLite. They're not using .NET CF, though. I can't find an ftp archive (or any archive) of older versions of the System.Data.SQLite libraries. Have you found one, by any chance?

Re: [sqlite] 64 bits Dll

On Fri, May 9, 2014 at 5:56 PM, Carlos Ferreira wrote: > Constantine, really useful information. > > Do you know if the compiled objs that may be available in Delphi are > comparable in performance with the ones made by MS VS. > ​No, sorry.​ I know there is a tool,

Re: [sqlite] 64 bits Dll

You can also use SQLite.Interop.dll as a replacement SQLite library with encryption support. It is part of the System.Data.SQLite distribution and both 32 bit and 64 bit are included. Bogdan On Fri, May 9, 2014 at 9:56 AM, Carlos Ferreira wrote: > Constantine, really

Re: [sqlite] 64 bits Dll

Constantine, really useful information. Do you know if the compiled objs that may be available in Delphi are comparable in performance with the ones made by MS VS. I know there is a tool, IMPLIB to import dlls or libs that can be from Microsoft and create Libs to use in Delphi..Not sure how

Re: [sqlite] 64 bits Dll

Ralf, Thanks for the insigth. Regards. Carlos -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: sexta-feira, 9 de Maio de 2014 15:20 To: General Discussion of SQLite Database Subject: Re: [sqlite] 64 bits

Re: [sqlite] 64 bits Dll

Thanks for the reply. I am doing very simple raw table inserts of big blobs, and also blob incremental reading.. I am barely using the sqlite query system itself in this particular performance bottleneck. Thanks to a friend of this community, Constantine, I was able to get the latest 32 and 64

Re: [sqlite] 64 bits Dll

On 2014/05/09 16:20, Ralf Junker wrote: On 09.05.2014 13:50, Carlos Ferreira wrote: XE6 itself seems to native have access to both... FireDAC only, and outdated by 2 months at the day of release. Delphi XE5 SQLite is still at 3.7.17, almost one year behind. Very true - the one

Re: [sqlite] 64 bits Dll

On Fri, May 9, 2014 at 5:20 PM, Ralf Junker wrote: > FireDAC only, and outdated by 2 months at the day of release. Delphi XE5 > SQLite is still at 3.7.17, almost one year behind. > ​In Delphi XE5 FireDAC either links statically the object files ​ ​sqlite3_x86.obj

Re: [sqlite] 64 bits Dll

On 09.05.2014 13:50, Carlos Ferreira wrote: XE6 itself seems to native have access to both... FireDAC only, and outdated by 2 months at the day of release. Delphi XE5 SQLite is still at 3.7.17, almost one year behind. DISQLite3 has always been up to date for years and Delphi versions back

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

On 2014/05/09 13:43, Kleiner Werner wrote: Hello I have a strange problem. On my Windows 7 XAMPP there is a little web application. The PHP connection to SQLite DB (3.3.7) is made with PDO. On Windows all is fine. Now I copied complete project to a Web Hoster. if I want to call my start page I

Re: [sqlite] 64 bits Dll

On 2014/05/09 12:36, Carlos Ferreira wrote: I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is from 20-5-2013. I am using it with Delphi, and it works fine for what I need. I need however a 64 bits version of the DLL. I actually have the64 bits 3.7.16 version that I

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

Hi Eric. Then I guess it was a conscious decision to drop support for x86 with .NET CF 3.5, becuse I think it has been supported in olver versions of SQLite? Best regards, Mattias From: Eric Johnston To: General Discussion of SQLite Database

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric >

Re: [sqlite] sqlite db transfer

On 9 May 2014, at 1:23pm, Sky Meena wrote: > i working in server client... c program. i need to transfer db from server > to client. in udp socket .. i to send a db. SQLite does not involve a server or a client. All processing and access of the database is done inside

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

On 9 May 2014, at 1:16pm, Werner Kleiner wrote: > If I connect to this db with PHPLiteadmin it tells me "No Table in Database" > But if I connect on Windows with e.g. Sqlitestudio all is fine. I'm betting that you're not connecting to the same database file in all these

[sqlite] sqlite db transfer

i working in server client... c program. i need to transfer db from server to client. in udp socket .. i to send a db. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WITHOUT ROWID option

On 9 May 2014, at 11:17am, Sky Meena wrote: > i need to transfer sqlite.db from server to client in udp socket Please start a new thread about this. It has nothing to do with 'WITHOUT ROWID option'. Simon. ___ sqlite-users

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

Strange thing is: If I connect to this db with PHPLiteadmin it tells me "No Table in Database" But if I connect on Windows with e.g. Sqlitestudio all is fine. ??? -- View this message in context:

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

On Fri, May 9, 2014 at 2:09 PM, Stephan Beal wrote: > On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner wrote: > >> The PHP connection to SQLite DB (3.3.7) is made with PDO. >> > > It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner wrote: > The PHP connection to SQLite DB (3.3.7) is made with PDO. > It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3 is ancient. http://www.sqlite.org/releaselog/3_3_7.html -- - stephan beal

Re: [sqlite] 64 bits Dll

On Fri, May 9, 2014 at 2:45 PM, Carlos Ferreira wrote: > Tell me how you want to do this DLL exchange. ​I will send the compiled dlls to your personal email.​ --Constantine ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] 64 bits Dll

Ralf, Thanks. XE6 itself seems to native have access to both...I have to test this. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ralf Junker Sent: sexta-feira, 9 de Maio de 2014 12:45 To: General Discussion of SQLite

Re: [sqlite] 64 bits Dll

Constantine, Thank you for your feedback. If you could make the win32 and win64 DLLs available I would really thank you. If for some reason it does not work as I expect, probably I can try the suggestion you made. My only concern is that I need the compiled DLls and the Sqlite itself compiled

Re: [sqlite] 64 bits Dll

On 09.05.2014 12:36, Carlos Ferreira wrote: I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is from 20-5-2013. I am using it with Delphi, and it works fine for what I need. I need however a 64 bits version of the DLL. SQLite3 for Delphi, both Win32 and Win64, with many

[sqlite] General error: 11 malformed database schema - near "'NOCASE'":

Hello I have a strange problem. On my Windows 7 XAMPP there is a little web application. The PHP connection to SQLite DB (3.3.7) is made with PDO. On Windows all is fine. Now I copied complete project to a Web Hoster. if I want to call my start page I get the error: General error: 11 malformed

Re: [sqlite] 64 bits Dll

On Fri, May 9, 2014 at 1:36 PM, Carlos Ferreira wrote: > Can anyone tell me where can I find the 64 bits version of Sqlite.dll, or > can anyone compile it for me? It would work as a small consulting project. > ​I can send you dlls compiled from the latest amalgamation

[sqlite] 64 bits Dll

Hello, I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is from 20-5-2013. I am using it with Delphi, and it works fine for what I need. I need however a 64 bits version of the DLL. I actually have the64 bits 3.7.16 version that I downloaded from the SYNOPSE

Re: [sqlite] WITHOUT ROWID option

Judging from the documentation there is not (optional methods may have a NULL pointer in the method table). Maybe this will/has change(d) 2.12 The xRowid Method int (*xRowid)(sqlite3_vtab_cursor *pCur, sqlite_int64 *pRowid); A successful invocation of this method will cause *pRowid to be

Re: [sqlite] How do I know the python functions registered on SQLite ?

We register our defined functions in a linked list in memory for the same reason (and have also implemented a .func in the shell to list all/matching registered functions) -Ursprüngliche Nachricht- Von: big stone [mailto:stonebi...@gmail.com] Gesendet: Donnerstag, 08. Mai 2014 18:35

Re: [sqlite] FTS3/4 merge function behaviour when deleting rows

I am now totally convinced that FTS3/4 does not work for this usage model. If you are deleting and inserting documents, the size of the FTS index will grow in a linear manner with no limit no matter what you do with the merge command (when you run it, what parameters you provide). I have

Re: [sqlite] WITHOUT ROWID option

i need to transfer sqlite.db from server to client in udp socket.. working in c language.. .. i dont know how to transmit db. in client side it should create copy of db. if client ask name of db to server . server should transmit.. On Fri, May 9, 2014 at 3:09 PM, Stephan Beal

Re: [sqlite] WITHOUT ROWID option

On Wed, May 7, 2014 at 6:31 PM, Richard Hipp wrote: > On Wed, May 7, 2014 at 9:00 AM, Marco Bambini wrote: > >> What is the best way to know if a table has been created with the WITHOUT >> ROWID option? >> > > > (1) You could send "SELECT rowid FROM table"

Re: [sqlite] WITHOUT ROWID option

On Fri, May 9, 2014 at 11:38 AM, Stephan Beal wrote: > i don't think a WHERE is necessary to improve the efficiency. The > statement only gets prepared, not stepped, and i would not expect any > analysis of results until the first step() (but maybe i'm assuming too >

Re: [sqlite] WITHOUT ROWID option

On Fri, May 9, 2014 at 8:36 AM, Andy Goth wrote: > On 5/8/2014 10:11 AM, Jim Morris wrote: > >> To improve efficiency you could add "where 1=2" to avoid returning any >> rows. Should just check validity. >> > > This being SQLite, as previously discussed, you could say

[sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the download site for System.Data.SQLite ( http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) it seems that only ARM is supported. Best regards, Mattias Kindborg ___

Re: [sqlite] WITHOUT ROWID option

On 5/8/2014 10:11 AM, Jim Morris wrote: To improve efficiency you could add "where 1=2" to avoid returning any rows. Should just check validity. This being SQLite, as previously discussed, you could say "where 0" :^) -- Andy Goth | ___