gettingstarted
[Top] [All Lists]

Max values in db

To: Getting Started <gettingstarted at lists dot realsoftware dot com>
Subject: Max values in db
From: Ron Lambert <railman at sasktel dot net>
Date: Wed, 29 Sep 2004 11:49:58 -0600
Delivered-to: gettingstarted at lists dot realsoftware dot com
I have a situation where I have a database table (Carsource) with one of the fields (CSid) being my ID field. As I enter a new set of data a understand I must use a unique ID. My problem is that this ID is sequential, so I must know my max value in the id field.

Is there a way to find the max value of a field set? I have been considering the SQL(...) method, but I cannot come up with a wording.

Thanks

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>

<Prev in Thread] Current Thread [Next in Thread>