Delete duplicates does not apply to views, sorry (no mater if its a unique
table view - updateble view).
The solution from Dawn is OK.
Ramiro


                                                                           
             "William Owens"                                               
             <[EMAIL PROTECTED]                                             
             emetery.org>                                             Para 
             Enviado por:              [email protected] (RBG7-L Mailing    
             [email protected]          List)                               
                                                                        cc 
                                                                           
             01/04/2005 11:33                                       Asunto 
             a.m.                      [RBG7-L] - delete rows              
                                                                           
                                                                           
                Por favor,                                                 
                responda a                                                 
             [email protected]                                              
                                                                           
                                                                           





I have a table that can have duplicate rows (Dos 6.1) Is there a way I can
delete dup rows based on certain fields?

example

  5 fields >  reqdate, section, range, plot, compdate
I want to delete the row where reqdate,section,range,plot are equal and
compdate fails?

Thanks

Bill

Reply via email to