The initial fields I am failing on are all text.
I wish I could copy the script but FM doesn't allow me to do a copy / paste
to anything other than another script (...??)
I actually have 3 scripts:
The first goes thru a table of metadata which contains the names of all of
the fields in the base table I am converting.
For each field, it extracts the field name and performs the 2nd script.
The second script uses the fieldname to get the value or values:
If $$norepeats = 1
Set Variable [$$vvalue; Value:GetField($$vfieldname)]
If [not IsEmpty ($$vvalue)] (This is the failure)
If [Length($$vvalue) >= 1 and $$vvalue >= 0] (also tried this)
Etc.
This construct has been working in another script, but that script does not
have the IsEmpty step.
Ron Carr
-----Original Message-----
From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On
Behalf Of Jens Selvig
Sent: Wednesday, November 26, 2008 10:51 AM
To: [email protected]
Subject: Re: Invalid data
Is my understanding correct? You have 5900 records, 400 fields with
each field having 4 repeated values? What kind of data type do the
fields have? Can you share the actual looping script steps you use?
Jens
On Nov 26, 2008, at 7:12 AM, Ron wrote:
> I have scripts that cycle thru roughly 5900 records, one column at a
> time, roughly 400 columns, most repeating up to 4 times.
> I expect a number or a short a/n character set, or an empty value.
> I am testing the value in each column/repeat for Not IsEmpty.
> I am getting invalid data returned, so the Not IsEmpty doesn't work.
> How else can I test the value to reject whatever this invalid data is?
> Or, from another point of view, how would these values be
> initialized so I could test for that?
>
> Many thanks!
>
> Ron Carr
Jens Selvig
...Lost in Montana...
