>> See? That's how I read this, too. Oh, well... I've wasted more
>> time
>> on stupider things than this, so it's no use cying over spilled
>> milk. :-)
>
> This, at least, seems pretty clear:
>
>
> http://sqlite.org/compile.html#enable_update_delete_limit
Yup, you're right, Jay. I
On Mon, Jul 06, 2009 at 01:22:52PM -0400, Andy Froncioni scratched on the wall:
>
> On 6-Jul-09, at 1:20 PM, D. Richard Hipp wrote:
> > At http://www.sqlite.org/compile.html under section 1.6, it says you
> > cannot use SQLITE_OMIT_ compile-time options with the amalgamation.
> > The
On Jul 7, 2009, at 1:56 AM, Andy Froncioni wrote:
>> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote:
>>
>>> I know I'm probably doing something wrong, but I can't seem to get
>>> a simple UPDATE...LIMIT query working.
>>>
>>> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10;
>>> SQL
> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote:
>
>> I know I'm probably doing something wrong, but I can't seem to get
>> a simple UPDATE...LIMIT query working.
>>
>> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10;
>> SQL error: near "LIMIT": syntax error
>>
>>
>> I have compiled
On 6-Jul-09, at 1:20 PM, D. Richard Hipp wrote:
> At http://www.sqlite.org/compile.html under section 1.6, it says you
> cannot use SQLITE_OMIT_ compile-time options with the amalgamation.
> The documentation never says you cannot use
> SQLITE_ENABLE_UPDATE_DELETE_LIMIT with the amalgamation, but
On Jul 6, 2009, at 1:03 PM, Andy Froncioni wrote:
>>
>> You will need to build from the source tarball (the one with the
>> unsupported configure script), not the amalgamation package for
>> this to work.
>
> Thanks a bunch. I'll try that...
>
> But I don't remember reading that the tarball I
On 6-Jul-09, at 12:18 PM, Dan wrote:
>
> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote:
>
>> I know I'm probably doing something wrong, but I can't seem to get
>> a simple UPDATE...LIMIT query working.
>>
>> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10;
>> SQL error: near
On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote:
> I know I'm probably doing something wrong, but I can't seem to get
> a simple UPDATE...LIMIT query working.
>
> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10;
> SQL error: near "LIMIT": syntax error
>
>
> I have compiled sqlite3
I know I'm probably doing something wrong, but I can't seem to get
a simple UPDATE...LIMIT query working.
sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10;
SQL error: near "LIMIT": syntax error
I have compiled sqlite3 with the following configure options:
% CFLAGS="-Os
9 matches
Mail list logo