deleting records in conflict tables

deleting records in conflict tables

Post by stuart hawkin » Sat, 12 Jan 2002 19:46:42



Hi,
We have a SQL 7 database with a number of conflicts that we know aren't
problems and we do not want to resolve through the conflict viewer.  What is
the quickest way of removing them?  Are there any implications to deleteing
the rows in the relevant conflict tables?

Thanks for the help.

God bless,
Stuart Hawkins

 
 
 

1. Cannot add record to Visual Foxpro table after deleting all records in table

After:
1. opening adodb connection with
vfpoledb.dll and datasource=path$ &
foxprofile.dbc successfully
2. deleting all records from table1 in
foxprofile.dbc successfully with
connection.execute("delete from table1") (I
can see the records being marked as deleted
in the VFP IDE) ,

I cannot add any record to table1 that has a
primary key like one of the deleted records.
So I execute connection.execute("pack
table1") and get "ADO error: File is in use".
(but my foxpro IDE is closed and only my VB6
program has the *.dbc open).

How can I delete (and pack if necessary) all
the records so they are gone for good from
the table?

Please!
Thank you.

2. Dump Tran W No_Log and Not Immediately Backing Up

3. Restoring deleted records with conflict viewer

4. data repeater

5. Conflicts in merge replication, records deleted

6. XML and Filemaker

7. No record of deleted conflicts

8. Deleting conflict system tables

9. Delete Conflict Table

10. Conflict tables still here after deleting Publication

11. Deleting conflict tables and SPs

12. Deleted records when text file is linked as table (#deleted)