Delete dulicates - how to use?

[Mike Weaver]

Hi All,
Please, can anyone fill me in on how I should use the "delete
duplicates" tool?

I have been trying to use it and I can't get it to work, it keeps
telling me:
"Numeric values required."

Even when I specify a numeric column.


Also does this script work fine from a Mapbasic command?

Big thanks, Mike.

[Sarah]

Hi,

I just checked this tool to make sure it still worked like I thought
it did and it seems to be working very well for me for all types of
columns - numbers, text, dates etc. All you need to do is choose a
table and the column which you want to remove duplicates from, then
choose save as - if you add "count" this should give you a good
indication of whether it has worked on not as it is adds a column to
the end so say how many have been combined.

As for Mapbasic I am not sure, but I expect you can call the code from
your script or add some of the relevant code to do the same - the
deleteduplicates.mb is available in program files samples for
Mapbasic.

Hope that helps,

Sarah

[Mike Weaver]

I have tried decimal and integer with out any luck I get an error:
"Numeric values required."
What column types can it operate on?

Mike.

[Sarah]

As I said, it doesn't seem to have a requirement type - works for me
on integer, float, date, character.

Are you using a local Mapinfo file or are you accessing data from an
external database? perhaps that could be the reason? For instance SQL
Server tables always needs a column with a numerical indexed value to
be able to do anything with the data.

Sarah

[Mike Weaver]

Ah ha!!
while the error reported is "Numeric values required." the issue seems
to be that the feild is not indexed!
I add an index, and your right every thing works well :)

Thanks

[Mortankas]

I experience this problem, even when ensuring that column chosen is
indexed.

I've even created my own 'ID' column and populated it with integer
RowId - and then tried to delete duplicates on the indexed column
again without success - i get the same error - 'Numerical Values
Required'

> > > > > Big thanks, Mike.- Hide quoted text -
>
> - Show quoted text -