Re: [sqlite] 1: near ")": syntax error

Try removing the comma before the closing parenthesis? And add a semi-Colin after the create table command. On Aug 9, 2012, at 12:04 AM, "Brandon Pimenta" wrote: > I just found a bug in SQLite. It says "1: near ")": syntax error". Here's > my SQL query: > >

Re: [sqlite] 1: near ")": syntax error

Get rid of the comma at the end of the 'timestamp' line. Rick On Aug 8, 2012, at 10:03 PM, Brandon Pimenta wrote: > I just found a bug in SQLite. It says "1: near ")": syntax error". Here's > my SQL query: > > CREATE TABLE online_status ( > username varchar(255) NOT NULL default '', >

Re: [sqlite] insert two select count(*) problem

insert into mydb (co1,co2) values ((select count(*) from db1 where db1.sco1>80), (select count(*) from db2 where db2.sco2>90)); --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

[sqlite] insert two select count(*) problem

The sqlcmd is: insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select count(*) from db2 where db2.sco2>90; It doesn't work. If one column, it can do,but when many column count(*), I don't know how to write the sql command. ___

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On 8 Aug 2012, at 7:10pm, Nico Williams wrote: > Also, what is the status of SQLite4? Not done yet. Use it only if you're eager to play with an unfinished product because of some cool new feature. Simon. ___ sqlite-users

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

Also, what is the status of SQLite4? I know it's in development, but I'm wondering how far along it is. I'm guessing from the errors I saw that some of the extensions are not ready, for example. But looking at vdbe.c (particularly the comment block for OP_OpenRead) and explain output it seems

[sqlite] Using 3.6.4 SQLite-Amalgamation file

All, I have the need to get the SQlite-Amalgamation file for 3.6.4, and I need the sqlite3.c file. I downloaded the archive 3.6.4 amalgamation file, but it doesn't contain the sqlite3.c file. How can I make this? Thanks, Jerry Tilsley Sr Systems Analyst St. Claire Regional Medical Center

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 6:48 PM, Nico Williams wrote: > > That works, though it fails with tcc: > i forgot to mention, the tcc guys, for whatever reason, don't want to make a release of their "mob" branch, which is the "unofficial trunk" the past year or so. That branch

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 10:37 AM, Stephan Beal wrote: > The current trunk builds for me as-is with the GNUmakefile.linux: > > make compiler=gcc > make compiler=clang > make compiler=tcc > > all work fine here (and tcc is FAST!) That works, though it fails with tcc: tcc -g

Re: [sqlite] C# Dynamic data type

Interesting idea. Thanks. Adam On Tue, Aug 7, 2012 at 12:07 PM, Black, Michael (IS) wrote: > You can use sscanf to determine data type...I've done it before using a > method that's not obvious... > > You parse from most restrictive to least restrictive format like

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 5:34 PM, Nico Williams wrote: > src/analyze.c:177:26: error: no member named 'regRoot' in 'struct Parse' > aRoot[i] = pParse->regRoot; > ~~ ^ > The current trunk builds for me as-is with the GNUmakefile.linux: make

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 5:27 AM, Richard Hipp wrote: > Copy Makefile.linux-gcc into Makefile. Edit to suite your system. Type > "make" And what branches are expected to build? Last night I had errors building trunk (FTS3 referred to an undefined sqlite4_blob type), and when I

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 12:27 PM, Richard Hipp wrote: > Copy Makefile.linux-gcc into Makefile. Edit to suite your system. Type > "make" > You can also do: ln -s GNUmakefile.linux Makefile or ln -s GNUmakefile.linux GNUmakefile which includes Makefile.linux-gcc. GNU make will

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

On Wed, Aug 8, 2012 at 1:45 AM, Nico Williams wrote: > See subject. Thanks! > Copy Makefile.linux-gcc into Makefile. Edit to suite your system. Type "make" > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >