Re: MAX NUMBER


Reiro wrote:
hi ppl...

i am entering dat in an access front end connect to an oracle database.
i am using max (number) + 1 increasing my id...

problem is ... if during testing i enter a number like 9999999 in the
database.
Even whn record is deleted i get the next value as 9999999 + 1.
how do retrieve the maximum value that is in the table.

thx in advance...

By not allowing anyone to enter a number in this column.
Assuming the sql statement is correct, as you entered the maximum value
of 9999999 in this column, you will retrieve this number as the maximum
value.
Nothing can be done about that: what you see is what you get.

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages

  • Re: MAX NUMBER
    ... Reiro wrote: ... i am entering dat in an access front end connect to an oracle database. ... Daniel A. Morgan ...
    (comp.databases.oracle.misc)
  • Re: MAX NUMBER
    ... i am entering dat in an access front end connect to an oracle database. ... To retrieve the max number in a column of a table, use a query similar to the following: ... adding one to this max number smells suspiciously like one should be using an Oracle Sequence as it will autoincrement an interval based on the last value used. ...
    (comp.databases.oracle.misc)
  • MAX NUMBER
    ... i am entering dat in an access front end connect to an oracle database. ... how do retrieve the maximum value that is in the table. ... thx in advance... ...
    (comp.databases.oracle.misc)
  • Capturing returned ODBC error message using form_Error
    ... I have written an application with an Access front end to an Oracle Database. ... user-defined error messages. ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)
  • Re: Retrieve size of db objects
    ... given a certain Oracle database, I need to execute queries/commands in ... order to retrieve the following information: ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.server)