Re: [sqlite] import with quotation mark

I use: .separator "\t" but not solve, it works only when not have quotation. Fehmi Noyan ISI ha scritto quanto segue il 24/04/2013 6.48> Did you try explicitly declaring your separator via .separator command? You should be able to importing the line with quotas included in it.

Re: [sqlite] import with quotation mark

Did you try explicitly declaring your separator via .separator command? You should be able to importing the line with quotas included in it. http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles From: Spora To: sqlite-users@sqlite.org Sent:

Re: [sqlite] Programming API vs console

Hi, Igor, On Tue, Apr 23, 2013 at 8:55 PM, Igor Tandetnik wrote: > On 4/23/2013 11:47 PM, Igor Korot wrote: > >> During the program flow I need to insert a record in one of the tables >> inside transaction. >> Record inserts OK (no error message generated), but when I try to

[sqlite] import with quotation mark

Last Sqlite is not able to import line as this: 01010aa16020b'bb"cc, 33e fff31/03/13 Error: file.txt line 298: expected 9 columns of data but found 8 With previous version i not have this problem. Do it is possible to add a switch to ignore '"'

Re: [sqlite] Programming API vs console

On 4/23/2013 11:47 PM, Igor Korot wrote: During the program flow I need to insert a record in one of the tables inside transaction. Record inserts OK (no error message generated), but when I try to check using the SQLite console the record is not present. I let the transaction finish and check

[sqlite] Programming API vs console

Hi, ALL, I am developing an application using C API of SQLite. During the program flow I need to insert a record in one of the tables inside transaction. Record inserts OK (no error message generated), but when I try to check using the SQLite console the record is not present. I let the

Re: [sqlite] Feature request: Support for aarch64

On Tue, 23 Apr 2013 09:26:20 -0400 Richard Hipp wrote: > I really dislike changing autoconf versions since any autoconf upgrade > results in a massive change in the generated "configure" script, > which is annoying to audit before each release, and which results in > exceedingly

Re: [sqlite] Writing in a blob

On Tue, 23 Apr 2013 10:28:35 -0400 Richard Hipp wrote: > In summary: No, a bare SQLite blob does not provide file-system > semantics. But you can write a wrapper library around SQLite that > does provide file-system semantics for large blobs, and doing so > would have many

Re: [sqlite] Writing in a blob

On Tue, Apr 23, 2013 at 10:28:35AM -0400, Richard Hipp scratched on the wall: > Or, if you really want file-system semantics on top of your database (and > this is a reasonably idea, actually) you could write a wrapper library that > implemented file-system semantics on top of SQLite. As a

[sqlite] sqlite4 and sqlite3_busy_timeout

I'm experimenting with sqlite4 by porting an application that currently runs sqlite3. I'm following the surprisingly straight-forward instructions at http://sqlite.org/src4/doc/trunk/www/porting.wiki I see that sqlite4 no longer provides sqlite4_busy_timeout, is there an equivalent that I

Re: [sqlite] Unable to load DLL 'sqlite3

Denis, you are most likely using a wrong bitness. Set your project to create a x86 assembly or get an x64 SQLite build. Gerd Denis Rapiti schrieb am 23.04.2013 16:13: Hi everyone, Has anyone used the sql-net library I keep getting Unable to load DLL 'sqlite3': The specified module could

Re: [sqlite] Writing in a blob

>>Imagine what could happen if, for example, git where to start using this >>library. Instead of the ".git" directory containing lots and lots of >>separate files, your repository would be a single ".git" file which was >>really an SQLite database accessed through the "sqlite3fs" wrapper. I use

Re: [sqlite] Writing in a blob

On Tue, Apr 23, 2013 at 4:28 PM, Richard Hipp wrote: > ...implemented file-system semantics on top of SQLite. I propose an API > something like this: > > SQLFILE *sqlite3fs_fopen(const char *zPath, const char *zMode); > For anyone wanting to take that (admittedly large)

Re: [sqlite] Writing in a blob

On Mon, Apr 22, 2013 at 7:39 AM, Paolo Bolzoni < paolo.bolzoni.br...@gmail.com> wrote: > I noticed that sqlite3_blob_write cannot increase the size of the pointed > open blob. So I ask, there is a way to treat a blob as a stream so I can > write > or read values in it with ease? > Short answer:

[sqlite] Unable to load DLL 'sqlite3

Hi everyone, Has anyone used the sql-net library I keep getting Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E) the error occurs on the following line of code: var r = SQLite3.Open (databasePathAsBytes, out handle, (int) openFlags,

Re: [sqlite] SQLite Encryption in Windows 8 Metro App

On 23 Apr 2013, at 2:11pm, "Jay, Jayavasanthan John" wrote: > Or, is there any other package which doesn't have these dependencies for > encrypting and decrypting SQLite databases. I cannot answer your questions about SQLCipher, but the main authors of SQLite produce

Re: [sqlite] Feature request: Support for aarch64

On Mon, Apr 22, 2013 at 8:26 AM, Jan Staněk wrote: > Hello, > support for the ARM 64 bit CPU architecture (aarch64) was introduced in > autoconf 2.69. sqlite appears to use an earlier version of > autoconf, preventing its being built. Can you be more specific about what

[sqlite] SQLite Encryption in Windows 8 Metro App

Hi Guys, I tried out SQLCipher and have successfully integrated in testing with SQLite for encrypting and decrypting my database for a Windows 8 Metro App. But as per Windows 8 Metro App compatibility guidelines, openssl (which is the crypto package used by SQLCipher) fails on the usage of

[sqlite] Feature request: Support for aarch64

Hello, support for the ARM 64 bit CPU architecture (aarch64) was introduced in autoconf 2.69. sqlite appears to use an earlier version of autoconf, preventing its being built. Would it be possible to migrate sqlite to new version of autoconf? Thanks for answer, Jan Stanek

Re: [sqlite] Beginning database question

Thank you @Michael Black and @Doug Nebeker for your replies @Michael Black >> I assume when you say "discrete" you actually mean "bracketed" as there are lots more than 10 heights and weights. Yes, I mean 'bracketed' or 'binned' data. >> I don't know what Excel has to do with this unless

Re: [sqlite] Noob question

Solved, thanks. On Tue, Apr 23, 2013 at 4:43 PM, Carl Gross wrote: > Sorry for the noob question. I posted a question to the group and > received 2 replies. But I'm having problems replying to those individuals. > When I click on the "Reply via email to XXX" button, I

[sqlite] Noob question

Sorry for the noob question. I posted a question to the group and received 2 replies. But I'm having problems replying to those individuals. When I click on the "Reply via email to XXX" button, I receive an error page saying, "Requested archive does not exist." Do I have to reply to the group?