<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>I'm hitting a peculiar problem. Wonder if there's a
precedent?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Using Valentina addRecord() function</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>PathName.value = List item</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Everything works great, except for very specific
circumstances. If two files have a similar path such as this:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>D:\Sample Folder\ 11 Caesar.jpg</FONT></DIV>
<DIV><FONT size=2 face=Arial>D:\Sample Folder\ 11 Augustus.jpg</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Even though these are two distinct files, Valentina
recognizes them as having precisely the same path and flags that a duplicate
record already exists.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Changing the second file name to any of these
alternatives corrects the problem:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>D:\Sample Folder\ 11_Augustus.jpg</FONT></DIV>
<DIV><FONT size=2 face=Arial>D:\Sample Folder\ 10 Augustus.jpg</FONT></DIV>
<DIV><FONT size=2 face=Arial>D:\Sample Folder\ 12 Augustus.jpg</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Since I don't know what a person might name their
files, I don't have the luxury of arbitrarily changing their file
names.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Is there a work-around for this?</FONT></DIV><FONT
size=2 face=Arial>
<DIV><BR>Thanks.</DIV>
<DIV> </DIV>
<DIV>Richard McCoy<BR>Executive Creative Director<BR>MCR Media Associates,
LLC</FONT></DIV></BODY></HTML>