Re: Error in post with ADOSQLServer


"Sergio Pottstock" <pttk@xxxxxxx> wrote in message
news:42978440@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Yes is one table with 86.500 record!!, I need delete all duplicate record.
>

That is probably your problem: duplicate records. SQL is complaining that it
does not know what record you are trying to update, because there is more
than one Give your table a primary key, or use a GROUP BY or DISTINCT
statement to transfer unique records to a new table.

Maurice


.

Relevant Pages

  • Deleting Duplicate Records in a Query
    ... I need to get rid of these duplicates. ... Because both fields match at the same time, ... This is not a duplicate record: ... write out the sql statement for me, ...
    (microsoft.public.access.queries)
  • Redundancy
    ... I need to create a duplicate record into another database when I create a record in the current one. ... I'm using the SQL INSERT Command. ... How would I send a copy to another database with SQL? ...
    (microsoft.public.access.formscoding)
  • Combo box for Searching
    ... the related record. ... record and gives an error because it will create a duplicate record. ... Regards John ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: me.undo
    ... It appears that after entering the ... you are moving to the next new record by clicking a button ... the form to go to the duplicate record in the BeforeUpdate event. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Error in post with ADOSQLServer
    ... Yes is one table with 86.500 record!!, I need delete all duplicate record. ... >> When execute this instruction: ... >> PTTK ... Prev by Date: ...
    (borland.public.delphi.database.ado)