On Thu, Apr 12, 2012 at 2:15 PM, Richard Hipp <[email protected]> wrote:
> > > On Thu, Apr 12, 2012 at 2:06 PM, Zbigniew <[email protected]> wrote: > >> At the attempt to get a non-existing value, for example: >> >> set x [dbcomm eval {SELECT max(somecolumn) FROM sometable}] >> > > The correct way to do this would be one or other other of the following: > > set x [lindex [dbcomm eval {SELECT max(somecolumn) FROM sometable}] > Oops. Omitted the " 0]" from the end of the previous line -----^ > > set x [dbcomm onecolumn eval {SELECT max(somecolumn) FROM sometable}] > > In the second example, it is traditional to abbreviate "onecolumn" to > simply "one". > > >> >> The returned value of $x will be {} - and no, not "empty", but exactly >> these two characters. >> >> Easy to reproduce. >> -- >> Zbigniew >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > [email protected] > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
