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