Valentina Studio - Delete duplicate records

[Ruslan Zasukhin]

On 26/4/10 5:09 AM, "Markus Schmidt" <markus at creativenetworkdesign.com>
wrote:

> Hi Ruslan,
> 
> Can I use Valentina Studio to delete duplicate records ?
> 
> I tried setting a field to "unique" to remove duplicate rows, but I received
> an error message.
> The same technique works in MySQL :)

Hi Markus,

Vstudio do not have such feature.

I wonder, how you can have duplicates if in theory each table should have at
least one KEY/UNIQUE field ... Although with Valentina people tend to use
RecID ... 


As I remember you can try to use SQL to find duplicates

DISTINCT or GROUP BY
HAVING count >= 2

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]