Re: [sqlite] Can't get MAX value from table

MAX( ColumnName )>No column name - Original Message - From: "Bob Dennis" <[EMAIL PROTECTED]> To: "SQLite user gorup" Sent: Wednesday, July 02, 2008 4:01 PM Subject: [sqlite] Can't get MAX value from table > > Hi, I am fairly new to SQLite,

[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