MAX( ColumnName )---->No column name ----- Original Message ----- From: "Bob Dennis" <[EMAIL PROTECTED]> To: "SQLite user gorup" <sqlite-users@sqlite.org> Sent: Wednesday, July 02, 2008 4:01 PM Subject: [sqlite] Can't get MAX value from table
> > Hi, I am fairly new to SQLite, and using it to replace Microsoft db in > PocketPC applications. > > I am having trouble getting a MAX value from a table as follows:- > > SQL = SELECT MAX( ColumnName ) FROM TableName > > Set Recs = db.Execute(sql) > > Result = recs(1)(ColumnName) > > I get nothing in the Result value. > > I have tried putting an index on the column but it made no difference. > > Any ideas would be greatly appreciated > > Thanks > > Bob Dennis > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users