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