Normal Topic AutoNumber example (Read 10056 times)
POLAN6052-670
Member
*
Offline



Posts: 1
Joined: Apr 19th, 2010
AutoNumber example
Apr 19th, 2010 at 1:44am
Print Post Print Post  
How do I write a routine to search for the maximum value of a field in the entire table?

I have a key field that needs to have a unique value, and the new records value is incremented by 1 from the highest value in the table.

Similar to the auto number function in Access
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: AutoNumber example
Reply #1 - Apr 19th, 2010 at 1:19pm
Print Post Print Post  
Hello,

The Knowledge Base article at http://www.lantica.com/support/kb/article/000073 should help you with what you need.

-Ray

  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged