Oct 22, 2002 #1 racav Programmer Joined May 21, 2002 Messages 2 Location AR Hi, Does anyone know how to get the max value of a db field? I need a function like the "SELECT MAX(Field)" of SQL. Thx. Esteban
Hi, Does anyone know how to get the max value of a db field? I need a function like the "SELECT MAX(Field)" of SQL. Thx. Esteban
Oct 23, 2002 #2 HotEye Programmer Joined Jan 10, 2001 Messages 112 Location GB I think the quickest way is to create an index and then use dbgobottom() with the index active. Hope that helps. Upvote 0 Downvote
I think the quickest way is to create an index and then use dbgobottom() with the index active. Hope that helps.
Oct 23, 2002 Thread starter #3 racav Programmer Joined May 21, 2002 Messages 2 Location AR Thank you very much... Upvote 0 Downvote
Oct 23, 2002 #4 bjolly64 Programmer Joined Jul 6, 2002 Messages 20 Location US i think it would be alot faster if you use the DBSTRUCT() and test the (len)... Upvote 0 Downvote