Missing Serial # 
Author Message
 Missing Serial #

-- I have a file with 1350 records. Serialized 1-1350. Somewhere a
serial # is missing 466,467,469 as 468 is missing.

Is there an easy way to script a "find" so I don't have to scroll
through every record to find the missing one?

tia,
Michael
=========================================
To reply please remove anti spam
"dot" and use the following:

=========================================



Sat, 28 Sep 2002 03:00:00 GMT
 Missing Serial #

Find All
Sort (by Serial # field)
Go to Record [First]
Set Field [Global Number, Serial #]
Go to Record [Next]
Loop
   Exit Loop If [Serial # <> Global Number +1]
   Go to Record [Exit, Next]
End Loop



Quote:

> -- I have a file with 1350 records. Serialized 1-1350. Somewhere a
> serial # is missing 466,467,469 as 468 is missing.

> Is there an easy way to script a "find" so I don't have to scroll
> through every record to find the missing one?

> tia,
> Michael
> =========================================
> To reply please remove anti spam
> "dot" and use the following:

> =========================================



Sat, 28 Sep 2002 03:00:00 GMT
 Missing Serial #
Maybe it is just that it is after midnight and my brain is fuzzy, but
don't you need a
Set Field [Global Number, Serial #]
right after the Exit Loop If ... ?
Quote:

> Find All
> Sort (by Serial # field)
> Go to Record [First]
> Set Field [Global Number, Serial #]
> Go to Record [Next]
> Loop
>    Exit Loop If [Serial # <> Global Number +1]
>    Go to Record [Exit, Next]
> End Loop



> > -- I have a file with 1350 records. Serialized 1-1350. Somewhere a
> > serial # is missing 466,467,469 as 468 is missing.

> > Is there an easy way to script a "find" so I don't have to scroll
> > through every record to find the missing one?

> > tia,
> > Michael
> > =========================================
> > To reply please remove anti spam
> > "dot" and use the following:

> > =========================================



Sun, 29 Sep 2002 03:00:00 GMT
 Missing Serial #
Yes, but I would use Set Field[Global Number,Global Number + 1] in case
there were sequential missing numbers.

-- Margaret Nupponen

Quote:

> Maybe it is just that it is after midnight and my brain is fuzzy, but
> don't you need a
> Set Field [Global Number, Serial #]
> right after the Exit Loop If ... ?


> > Find All
> > Sort (by Serial # field)
> > Go to Record [First]
> > Set Field [Global Number, Serial #]
> > Go to Record [Next]
> > Loop
> >    Exit Loop If [Serial # <> Global Number +1]
> >    Go to Record [Exit, Next]
> > End Loop



> > > -- I have a file with 1350 records. Serialized 1-1350. Somewhere a
> > > serial # is missing 466,467,469 as 468 is missing.

> > > Is there an easy way to script a "find" so I don't have to scroll
> > > through every record to find the missing one?

> > > tia,
> > > Michael
> > > =========================================
> > > To reply please remove anti spam
> > > "dot" and use the following:

> > > =========================================



Sun, 06 Oct 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Missing Serial #

2. Primary keys (serial and non serial)

3. Dump serials as serial

4. Dump serials as serial -- not a sequence

5. Dump serials as serial -- not a sequence

6. I have the serials buttons 5 volumes serials...

7. How can you recover from a corrupted, or missing missing .ldf file on mssql7

8. Missing Column Statistics, Missing Join Predicates

9. Missing First Two Chars of SQL Memo and Missing SQL Fields

10. Missing variable message - Nothing missing?

11. Hard disk serial number or Ethernet card serial number.

12. Julian/Serial Date conversion


 
Powered by phpBB® Forum Software