Hi,
Is it possible to somehow search for/replace a string in all columns of all
tables?
Thanks
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/
ahperfect I'm done. Thank you all for all your help.
the latest build of sqlite3 has the readfile and writefile functions in it, and
they seem to be working just fine. here is the cmd.exe session showing what I
did. I was then able to open the image 'i3.png' and it is exactly the
On Wed, Dec 3, 2014 at 8:36 PM, Jonathan Leslie
wrote:
> no such function writefile. do I have to update my sqlite3
>
>
The writefile() function is built into recent sqlite3.exe command-line
shells. Very recent once, at least.
If you are not using a recent command-line shell, then you can
sqlite> .version
SQLite 3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212
sqlite>
- Original Message -
> From: Jonathan Leslie
> To: General Discussion of SQLite Database
> Cc:
> Sent: Wednesday, December 3, 2014 8:36 PM
> Subject: Re: [sqlite] trying to store a
no such function writefile. do I have to update my sqlite3
C:\jon\svn\SCEPTRE\trunk\SCEPTRE\Scenario Management\ahk_sceptre>sqlite3
test2.db3
SQLite version 3.8.5 2014-06-04 14:06:34
Enter ".help" for usage hints.
sqlite> select writefile(name,contents) from files where name='image2.
select writefile(name, contents) from files where name='filename.ext';
---
Theory is when you know everything but nothing works. Practice is when
everything works but no one knows why. Sometimes theory and practice are
combined: nothing works and no one knows why.
>-Original Message---
>
> From: Clemens Ladisch
>To: sqlite-users@sqlite.org
>Sent: Wednesday, December 3, 2014 1:00 PM
>Subject: Re: [sqlite] trying to store a file as a blob. caught on syntax...
>
>
>Jonathan Leslie wrote:
>> I'm at a cmd.exe prompt.
>
>
>
>
>>
>> sqlite> INSERT
On Wed, Dec 3, 2014 at 5:46 PM, Simon Slavin wrote:
>
> On 4 Dec 2014, at 12:26am, James K. Lowden
> wrote:
>
> > What to do is another question. SQLite can surely ignore it. If I
> > felt strongly about it, I'd submit a bug report to GCC because IIUC
> > the nonnull attribute syntax provides
On 4 Dec 2014, at 12:26am, James K. Lowden wrote:
> What to do is another question. SQLite can surely ignore it. If I
> felt strongly about it, I'd submit a bug report to GCC because IIUC
> the nonnull attribute syntax provides no way to express the constraint
> defined by the standard, i.e. "
On Wed, 03 Dec 2014 08:56:44 +0100
Clemens Ladisch wrote:
> James K. Lowden wrote:
> > /* Copy N bytes of SRC to DEST. */
> > extern void *memcpy (void *__restrict __dest,
> > __const void *__restrict __src, size_t __n)
> > __THROW __nonnull ((1, 2));
> >
> > IIUC the d
I'd like to use the authorizer callback together with the new user
authentication module introduced in SQLite version 3.8.7. However, I
experience problems in compiling my application using a SQLite library
compiled with SQLITE_USER_AUTHENTICATION defined.
sqlite3.h defines the sqlite3_set_aut
Jonathan Leslie wrote:
> I'm at a cmd.exe prompt.
>
> sqlite> INSERT INTO Files (name,contents) VALUES ('tsql.lis',X"$(od -A n -t
> x1 tsql.lis|tr -d '\r\n\t ')");
> Error: near ""$(od -A n -t x1 tsql.lis|tr -d '\r\n\t ')"": syntax error
>
> I'm trying to store the file tsql.lis as a blob, and od.
On Wed, Dec 3, 2014 at 9:50 AM, Stephan Beal wrote:
> On Wed, Dec 3, 2014 at 5:35 PM, Scott Robison
> wrote:
>
> > standards have all been ISO standards. Pedantic? Yes. Obviously DRH is
> > willing to make the code more portable as long as it doesn't violate
> > ANSI-C, hence his patch early in
On Wed, Dec 3, 2014 at 5:35 PM, Scott Robison
wrote:
> standards have all been ISO standards. Pedantic? Yes. Obviously DRH is
> willing to make the code more portable as long as it doesn't violate
> ANSI-C, hence his patch early in the thread (see
> https://www.sqlite.org/src/info/0d04f380e1bd171
On Wed, Dec 3, 2014 at 2:17 AM, Clemens Ladisch wrote:
> Scott Robison wrote:
> > On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote:
> >> Do you have a standard that allows NULL? The one I quoted does not.
> >
> > Note: I'll have to double check my copy of the C90 standard document, but
> > my r
I'm on a window 7 x64 machine, at a cmd.exe prompt. This is what I tried:
C:\jone>sqlite3 test2.db3SQLite version 3.8.5 2014-06-04 14:06:34Enter ".help"
for usage hints.sqlite> CREATE TABLE Files (name TEXT PRIMARY KEY,contents
BLOB);sqlite> INSERT INTO Files (name,contents) VALUES ('tsql.lis
On 3 Dec 2014, at 3:20pm, Richard Hipp wrote:
> https://www.sqlite.org/rescode.html#busy
Thanks, Richard. I have somehow never seen that.
I had no idea that the difference between _BUSY and _LOCKED was purely about
whether the conflicting access was from the same connection.
Simon.
>From https://www.sqlite.org/rescode.html#busy
In both cases there are specific extended codes that may further pinpoint the
source just in case you do not know what you are doing at the time the result
code was returned. Interpretation is only difficult if you do not know what
you are doing w
On Wed, Dec 3, 2014 at 10:18 AM, Simon Slavin wrote:
>
> On 3 Dec 2014, at 3:10pm, Hick Gunter wrote:
>
> > SQLITE_BUSY means that some connection is BUSY with a write transaction
> and has locked the database file; presumably, it will be possible to write
> to the database when the current writ
On 3 Dec 2014, at 3:10pm, Hick Gunter wrote:
> SQLITE_BUSY means that some connection is BUSY with a write transaction and
> has locked the database file; presumably, it will be possible to write to the
> database when the current writer has finished, just not now or within the
> specified bu
I think the error messages are distinct enough as is.
SQLITE_BUSY means that some connection is BUSY with a write transaction and has
locked the database file; presumably, it will be possible to write to the
database when the current writer has finished, just not now or within the
specified bus
To me, a BUSY state would mean that everything up to actually reading or
writing the data out is valid, but, the response time coming back was just
too long, so a timeout hit which might mean that a retry later might be
appropriate. To me, a timeout = busy, but, locked != busy. When something
is
On 3 Dec 2014, at 2:20pm, Stephen Chrzanowski wrote:
> Although I think there is already an error result, one situation might be
> when the DB is in a read only state.
I just thought of the database /file/ being marked 'read-only'. But it turns
out that there's a different SQLite result code
Although I think there is already an error result, one situation might be
when the DB is in a read only state.
On Wed, Dec 3, 2014 at 6:15 AM, RSmith wrote:
>
> On 2014/12/03 13:00, Jonathan Moules wrote:
>
>> Hi,
>> Just a quick request/suggestion.
>>
>> Currently SQLITE_BUSY events return an e
On 2014/12/03 13:00, Jonathan Moules wrote:
Hi,
Just a quick request/suggestion.
Currently SQLITE_BUSY events return an error of "Database is locked". Is it possible to
change this to "Database is busy" or something similar?
I ask because when someone then goes googling for "SQLite database lo
Hi,
Just a quick request/suggestion.
Currently SQLITE_BUSY events return an error of "Database is locked". Is it
possible to change this to "Database is busy" or something similar?
I ask because when someone then goes googling for "SQLite database locked",
they'll end up thinking they're hitting
Scott Robison wrote:
> On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote:
>> Do you have a standard that allows NULL? The one I quoted does not.
>
> Note: I'll have to double check my copy of the C90 standard document, but
> my re-reading of the C99 quote leads me to the conclusion that NULL is a
On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote:
>
> Do you have a standard that allows NULL? The one I quoted does not.
Note: I'll have to double check my copy of the C90 standard document, but
my re-reading of the C99 quote leads me to the conclusion that NULL is a
valid pointer by definition
On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote:
>
> James K. Lowden wrote:
> > /* Copy N bytes of SRC to DEST. */
> > extern void *memcpy (void *__restrict __dest,
> > __const void *__restrict __src, size_t __n)
> > __THROW __nonnull ((1, 2));
> >
> > IIUC the declarat
29 matches
Mail list logo