Sequential Number Generator

11 Jan 99 15:41:56 -0500

--=_ORCL_2768446_0_0
Content-Transfer-Encoding:quoted-printable
Content-Type:text/plain; charset="iso-8859-1"

Fill in the gaps... 

FILE WHATEVER IN DATABASE 
FILE WHATEVER IN DATEBASE ALIAS WHATEVER_ALIAS DESIGNER 

TEMP T_SEQ_NUM NUM*02     INITIAL 0 RESET AT MODE 

let T_SEQ_NUM =3D current counter somewhere then use an INTERNAL. 

PROCEDURE INTERNAL COUNT 
   BEGIN 
      GET WHATEVER & 
          VIA WHATEVER_KEY USING WHATEVER_KEY OF WHATEVER OPT & 
      ORDERBY SEQ_NUM DESCENDING 
      IF ACCESSOK AND T_SEQ_NUM =3D 0 
         THEN LET T_SEQ_NUM =3D SEQ_NUM OF WHATEVER_ALIAS ;Designer file 
      LET T_SEQ_NUM =3D (T_SEQ_NUM + 1) ;This will increment by one. 
      LET SEQ_NUM OF WHATEVER =3D T_SEQ_NUM 
END 

Easy enough... 

---------------------- 
Mark Stewart 
Consultants Club Corp. 
Windsor, Ontario

--=_ORCL_2768446_0_0
Content-Type:message/rfc822

Date: 11 Jan 99 14:18:38
From:"Gassett, Chris" <gassett@aavid.com>
To:"'Powerhouse List'" <powerh-l>
Subject:Sequential Number Generator
Return-Path:<powerh-l-owner@lists.swau.edu>
Received:by mail.detroitedison.com with ESMTP id OAA10282; Mon, 11 Jan 1999 14:22:44 -0500 (EST)
Received:by dte.detroitedison.com with ESMTP id OAA04580; Mon, 11 Jan 1999 14:22:42 -0500 (EST)
Received:from sphere.swau.edu (sphere.swau.edu [205.165.192.254]) by cosmic3.swau.edu (8.8.3/8.8.3) with ESMTP id NAA01139; Mon, 11 Jan 1999 13:22:48 -0600
Received:from localhost (daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) with SMTP id NAA21294; Mon, 11 Jan 1999 13:22:41 -0600
Received:by sphere.swau.edu (bulk_mailer v1.9); Mon, 11 Jan 1999 13:22:28 -0600
Received:(from daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) id NAA21257 for powerh-l-outgoing; Mon, 11 Jan 1999 13:22:26 -0600
Received:from firewall.aavid.com (firewall.aavid.com [199.92.156.104]) by sphere.swau.edu (8.9.1/8.9.1) with ESMTP id NAA21253 for <powerh-l@lists.swau.edu>; Mon, 11 Jan 1999 13:22:22 -0600
Received:(from smap@localhost) by firewall.aavid.com (8.7.5/8.6.11) id OAA15774 for <powerh-l@lists.swau.edu>; Mon, 11 Jan 1999 14:11:58 -0500
Received:from unknown(199.92.156.146) by firewall.aavid.com via smap (V2.0alpha) id sma015763; Mon, 11 Jan 99 14:11:36 -0500Received: by hercules.aavid.com with Internet Mail Service (5.5.2232.9) id <CP02KMA3>; Mon, 11 Jan 1999 14:18:39 -0500
Message-ID:<B6532CC1E3A0D211945A00105A19293512F381@hercules.aavid.com>
Sender:owner-powerh-l@sphere.swau.edu
MIME-Version: 1.0
Content-Type:text/plain; charset=iso-8859-1
Content-Transfer-Encoding:quoted-printable

Is there an easy way to code a sequential number used for keeping track of
items?  This number needs to be unique and automatically generated so the
user does not have to fish for the last number used.  Thanks in advance.
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.

--=_ORCL_2768446_0_0--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.