Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Max Value of DB Field

Status
Not open for further replies.
racav

racav

Programmer
May 21, 2002
2
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
 
Sort by date Sort by votes
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 it would be alot faster if you use the DBSTRUCT() and test the (len)...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AndrewMozley
  • Locked
  • Question
DBU - Database Utility - No of files 1
Replies
9
Views
681
lohen
lohen
AndrewMozley
  • Locked
  • Question
Keyboard entry of # character under Windows 7
Replies
0
Views
629
AndrewMozley
AndrewMozley
AndrewMozley
  • Locked
  • Question
APPEND . . . REPLACE is failing to populate fields
Replies
5
Views
859
LyndonOHRC
LyndonOHRC
mustis01
  • Locked
  • Question
cannot get field type with dbfieldinfo()
Replies
2
Views
271
stevenbc
stevenbc
fbizzell
  • Locked
  • Question
dBase III Plus 3
Replies
6
Views
1K
GriffMG
GriffMG

Part and Inventory Search

Sponsor

Back
Top