Re: [sqlite] using max value

2006-07-13 Thread Christian Smith
Jay Sprenkle uttered: On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote: You can't use aggregate functions in WHERE clauses. Also, you can't use a select as the value in an insert. You can insert from the results of an insert. uh...It seems to work: The OP was trying to use a SELECT

Re: [sqlite] using max value

2006-07-13 Thread Jay Sprenkle
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote: You can't use aggregate functions in WHERE clauses. Also, you can't use a select as the value in an insert. You can insert from the results of an insert. uh...It seems to work: SQLite version 3.0.8 Enter ".help" for instructions sqlite>

Re: [sqlite] using max value

2006-07-13 Thread Christian Smith
Keiichi McGuire uttered: I'm a bit stuck on this one problem I have this simple table that has two fields: id and value. What I want to do is to get the largest id (the last entry) and then add an arbitrary number to the value that's in the same entry as that one, and put the result in the

[sqlite] using max value

2006-07-12 Thread Keiichi McGuire
I'm a bit stuck on this one problem I have this simple table that has two fields: id and value. What I want to do is to get the largest id (the last entry) and then add an arbitrary number to the value that's in the same entry as that one, and put the result in the next entry. to make it sound