Ok great - I guess I need to check for upgrades more often. And as for
what I was doing - well I have a program that generates queries (not
very well it appears) and it would occasionally crash - when I tracked
the bug down I was able to simplify it to two lines.
Samuel R. Neff wrote:
I get a crash with 3.3.12 but correct syntax error in 3.4.2 on Windows XP
using exe's downloaded from sqlite.org.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\sam>sqlite3
SQLite version 3.3.12
Enter ".help" for instructions
sqlite> create table test(field text);
sqlite> select * from test group by distinct field;
Crash. Windows creates a dmp file but I can't copy it or do anything with
it (says in use). All I can do is send it to Microsoft--think they'd help?
;)
Downloaded newer exe and...
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\sam>sqlite3
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table test(field text);
sqlite> select * from test group by distinct field;
SQL error: near "distinct": syntax error
sqlite>
No crash.
Not sure what the OP is even trying to accomplish though.. it's certainly
not valid SQL.
Sam
-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------