Re: multiple file reads and sorts

From: Richard (riplin_at_Azonic.co.nz)
Date: 01/09/04 

Date: 8 Jan 2004 20:29:13 -0800

"William M. Klein" <wmklein@nospam.netcom.com> wrote

> Alternatively, if the logic for YOUR program indicates that having a duplicate
> alternate record key is an "application error" - the process it accordingly
> (as an error for YOUR program).

Why would the SELECT specify 'WITH DUPLICATES' if having a duplicate
alternate key was an 'application error' ?

Given that without this clause the file status would return '22' which
is a real error then I find your note rather puzzling.

A file status of '02' is only an 'application error' if the file is
wrongly designed.

Relevant Pages

  • Re: A reply to Marvin Minsky.
    ... and not over specify the behavior. ... abstractions based on internal implementations over specify. ... period, and then you build a machine that duplicates the behavior, haven't ... It is the interanl ...
    (comp.ai.philosophy)
  • Re: Help with ALTER TABLE statement
    ... Allen Browne wrote: ... Is that a constraint? ... an allow duplicates index/constraint just doesn't ... specify the UNIQUE option. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Remove Duplicates
    ... In Options, specify that Global is Unique, always validate. ... Create a new script. ... Set Error Capture ... exclamation point, for duplicates. ...
    (comp.databases.filemaker)
  • Re: Remove Duplicates
    ... In Options, specify that Global is Unique, always validate. ... Create a new script. ... Set Error Capture ... exclamation point, for duplicates. ...
    (comp.databases.filemaker)
  • Re: Count rows based on multiple variables
    ... Do you intend to specify what that name and text is, ... the formula supposed to just count duplicates based on columns B and C where A ... >luck. ...
    (microsoft.public.excel.programming)