I've looked high and low and can't find a way to invoke the other 2
affinity modes. Are they available? I'm on 3.5.4.
Any pointers would be greatly appreciated.
Thanks!
Scott
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
D. Richard Hipp wrote:
> On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote:
>
>
>> I've looked high and low and can't find a way to invoke the other 2
>> affinity modes. Are they available? I'm on 3.5.4.
>>
> The concept of "strict"
I take it that there's no way to work around this currently?
Scott
Scott Chapman wrote:
> D. Richard Hipp wrote:
>
>> On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote:
>>
>>
>>
>>> I've looked high and low and can't find a w
I don't see how. Any clues?
Thanks!
Scott
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
In Section 7.0, Transaction Control At The SQL Level, at
http://www.sqlite.org/lockingv3.html, it says:
"If the SQL COMMIT command turns autocommit on and the autocommit logic then
tries to commit change but fails because some other process is holding a SHARED
lock, then autocommit is turned b
Adobe AIR did not include the FTS module.
I read in this thread
(https://store1.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=75&catid=697&threadid=1417051&enterthread=y)
that they disabled loadable modules.
However, it would have been easy for them to statically include the FTS
(a
I am having a look at Visual Basic Express 2005 Beta. I haven't
programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't
do any database with it then.
All of my programming these days is in Python with Postgresql or SQLite.
Has anyone gotten VB and SQLite working together?
Ar
Thanks Steve.
Anyone have guidance on which of these will work (well) with the latest
version of VB and SQLite?
Steve O'Hara wrote:
Check out the WIKI, there's a myriad of possibilities.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behal
I'd like to be able to see all the sql traffic going to/from my sqlite
database. Is there a way to run things in a debug mode so that it
outputs the sql traffic to a log file, similar to how you'd do it in
Postgres?
Scott
-
On 02/19/2004 05:12 am, D. Richard Hipp wrote:
> Question to all: If I modified SQLite to use the
> same column naming rules as (say) PostgreSQL, how
> much existing code would it break? Is this something
> that should be done, even though it is a (slightly)
> incompatible change?
Compatibility
It should be "primary key" not "primarykey". It doesn't give you any errors
and it doesn't give you a primary key.
Scott
I made a little python code below that fetches a sqlite3 table description
(using apsw) but it won't work when the table is empty. ÂI made it tell me
the table is empty in this case. Â
Is there a way to get the columns in a table without having to parse the SQL
that created the table, when the
On Monday 31 January 2005 7:58 am, Downey, Shawn wrote:
> "If anyone can see the source code, then won't we be venerable to
> hackers?"
Here is a very useful paragraph that should be given to anyone who thinks in
the above terms:
"A common question in the minds of some CEOs and CIOs is, 'If it
On Wednesday 02 February 2005 7:52 am, John Dean wrote:
> At 14:57 02/02/2005, Paul Malcher wrote:
> >Scott Chapman wrote:
> >>Regarding the issue of SQL Server vs. SQLite:
> >>If the choice were between SQL Server and SQLite, and the need came up
> >>that
> Let's be careful out there. I have found rookies tend to blindly
> evangelically tout their first learned tool as the one and only path of
> light to truth and world peace.
Fred, I think you just hit a good part of the reason that PHP and MySQL have
mind-share out there when they are lousy too
When I run make, I get this:
./libtool --mode=link gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src
-DNDEBUG -I/usr/include -DSQLITE_OMIT_CURSOR -DHAVE_READLINE=1
-I/usr/include/readline \
-o sqlite3 ./src/shell.c libsqlite3.la -lreadline -lreadline
gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLE
ons
sqlite> create table test (id INTEGER PRIMARY KEY AUTOINCREMENT,name text);
sqlite> .quit
C:\Documents and Settings\Scott Chapman\My
Documents\development\misc\sqlite>python apsw_pragma.py test1.db3
Traceback (most recent call last):
File "apsw_pragma.py", line 37, in ?
do
I'm using APSW 3.0.8-r3 on Python Windows XP Pro with Python 2.3.4.
Minimal test-case code:
import apsw
db = apsw.Connection('test.db3')
cursor=db.cursor()
cursor.execute('PRAGMA empty_result_callbacks = 1')
sql="select * from testnn" # testnn is empty
cursor.execute (sql)
description = cursor.getd
This was caused by me having two different readline.h files on my server.
Please disregard!
Thanks!
Scott
On Saturday 05 March 2005 05:55 pm, Scott Chapman wrote:
> When I run make, I get this:
>
> ./libtool --mode=link gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I./src
> -DN
I'm able to duplicate this on Linux with fresh compiles of Python, apsw,
sqlite.
Scott
On Saturday 05 March 2005 06:11 pm, Scott Chapman wrote:
> I'm using APSW 3.0.8-r3 on Python Windows XP Pro with Python 2.3.4.
>
> Minimal test-case code:
>
> import apsw
> db
I'm not able to duplicate this on Linux with fresh compiles of everything.
That leads me to believe the binary I downloaded for Windows is not built on
3.1.3 after all.
Scott
On Saturday 05 March 2005 06:01 pm, Scott Chapman wrote:
> Windows XP Pro, Python 2.3.4, sqlite 3.1.3
>
SQLError: near "AUTOINCREMENT": syntax error
C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite>
C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite>
C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite&g
[ Sorry - previous emal had the wrong pragma in two places (but the right one
in the code sample so I don't feel quite so dumb. It seems from the sqlite
docs that I should be getting different results than I am:
PRAGMA empty_result_callbacks;
PRAGMA empty_result_callbacks = 0 | 1;
Query or cha
Eli,
I'd highly recommend Python. I've used Perl, PHP and Python. Python is
hands-down the winner. After getting ahold of the elegance of Python, PHP
feels like a hack job. Perl is "executable line noise". Python is very
mature and very nice. It has a far cleaner implementation of just ab
24 matches
Mail list logo