Duplicate Error

[Ruslan Zasukhin]

On 2/12/10 4:26 AM, "Richard McCoy" <mcrmedia1 at insightbb.com> wrote:

Hi Richard,

> I'm hitting a peculiar problem. Wonder if there's a precedent?
>  
> Using Valentina addRecord() function
>  
> PathName.value = List item
>  
> I set the FilePath field in my database to "Unique" so that a person cannot
> add duplicate files. I'm also filtering in code to make sure that no
> duplicates get to the addRecord() code.
>  
> Everything works great, except for very specific circumstances. If two files
> have a similar path such as this:
>  
> D:\Sample Folder\ 11 Caesar.jpg
> D:\Sample Folder\ 11 Augustus.jpg

This not sounds right.
  
> Even though these are two distinct files, Valentina recognizes them as having
> precisely the same path and flags that a duplicate record already exists.

I believe that if you will open your db in Vstudio
And try add above 2 values into your unique field,
You will be able do that.

What TYPE of field?

May be it is TEXT?
May be flag IndexbyWords is ON for that field ?
 
> Changing the second file name to any of these alternatives corrects the
> problem:
>  
> D:\Sample Folder\ 11_Augustus.jpg
> D:\Sample Folder\ 10 Augustus.jpg
> D:\Sample Folder\ 12 Augustus.jpg
>  
> Since I don't know what a person might name their files, I don't have the
> luxury of arbitrarily changing their file names.
>  
> Is there a work-around for this?

-- 
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]