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 derfloh 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
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
 
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
Thank you very much...
 
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 Question
DBU - Database Utility - No of files
Replies
9
Views
993
lohen
lohen
AndrewMozley
  • Locked
  • Question Question
Keyboard entry of # character under Windows 7
Replies
0
Views
790
AndrewMozley
AndrewMozley
AndrewMozley
  • Locked
  • Question Question
APPEND . . . REPLACE is failing to populate fields
Replies
5
Views
1K
LyndonOHRC
LyndonOHRC
mustis01
  • Locked
  • Question Question
cannot get field type with dbfieldinfo()
Replies
2
Views
440
stevenbc
stevenbc
fbizzell
  • Locked
  • Question Question
dBase III Plus
Replies
6
Views
1K
GriffMG
GriffMG

Part and Inventory Search

Sponsor

Back
Top