InaPlex Forums

Hi! We use Inaport7 with GM8PE and I have a need to remove duplicate rows in the CAL and CONTSUPP tables. Is there a way to do this via Inaport? I can query for the rows in SQL that I need to delete...  Thanks for any guidance!

Blessings,
Sue Burke

Hi Sue

In your SQL query, make sure that you get the recid of the record you want to delete.

Then in the table map, there is an operation to delete a matched record - use the recid to match on it. You can use standard matching or SQL matching.

NOTE: This is NOT a cascading delete i.e. if you delete a parent record (e.g. contact1), Inaport will NOT automatically delete the related child records.

Take a backup first...

Regards

Admin