On Fri, 18 Apr 2008 08:50:42 +1200, Helpful Harry
<helpful_harry@[EMAIL PROTECTED]
> wrote:
>In article <e2ud04lb0ost5kelrfrrb2ivkvej0q089n@[EMAIL PROTECTED]
>, FastWolf
><wolfsofast@[EMAIL PROTECTED]
> wrote:
>
>> I want to create unique values for t_id. There doesn't seem to be a
>> function for testing validation.
>
>The usual way to get unique values for IDs is to use an auto-enter
>serial number. If needed this incrementing value can be appended to the
>end of other text, still resulting in a unique value.
Right you are, Harry, and I do use that method in this solution.
However, I also need to generate a completely different set of unique
identifiers based on a text string because the identifier gets plugged
into another text string and the whole thing is used as a filename on
a Web server.
The next thing you (probably) are going to say is, why not just use
the auto-generated numeric ID for the filename? And that would be a
valid suggestion. In this case, however, I am taking an existing
database that was built in mySQL (using Servoy as a front-end) and
*converting* it to FMP. Well, not converting actually, what I'm doing
is building a FileMaker solution that's WAY WAY more user-friendly,
robust, and stable than the Servoy app they had. The point is, they
are kind of locked into this method of naming their files so I need to
make it work that to make them happy.
Because Servoy hasn't worked all that well for them up to now. Prior
to this they were using a bit of Java code on a different Web server
to generate the ID, but that script keeps cra****ng. All manual entry
too. Not only that but it never did validate the unique value. At
this point their db is small enough where I have culled out and
replaced the dupes manually. But going forward I need an automated
solution to this problem.
thanks
--
FW
FileMaker Pro Advanced 8.5 on Windows XP Pro SP2
FileMaker Server 8.0 on Windows 2003 Server R2
|
