No Duplicate in Quick

Peter Bateman pfbcs@hotmail.com
Tue, 19 Oct 2004 14:02:29 -0300


Georgia:

  The DUPLICATE KEY ( default '_' ) is an entry shortcut.

  So your users could simply enter the previous entry instead of using the 
shortcut.

  I think what I would do is give a warning instead of an error.

  e.g.

  Say first and lastname are fields that we want to warn our users about.

  Temp t_FIRST char * 40 reset at startup
  Temp t_LAST char * 40  reset at startup


  Procedure EDIT FIRST_NAME
  Begin

    If t_FIRST = FIRST_NAME
      then warning "*W* First name repeated. Enter \ to correct."
End
Procedure PROCESS FIRST_NAME
Begin
    Let t_FIRST = FIRST_NAME
End

  Procedure EDIT LAST_NAME
  Begin

    If t_LAST = LAST_NAME
      then warning "*W* LAST name repeated. Enter \ to correct."
End
Procedure PROCESS LAST_NAME
Begin
    Let t_LAST = LAST_NAME
End

Regards,
Peter Bateman

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.