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

2008-07-02 Thread qinligeng 
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

[sqlite] Can't get MAX value from table

2008-07-02 Thread Bob Dennis 

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