Hi Ron,
A couple of things that may help. First it you have a Mac or on Windows
a way to print to a pdf file you may be able to copy and paste the
script. On a Mac open the script and start the print process. When the
print dialog opens press the print preview button and then copy and
paste out of the preview screen.
On Windows system print to a pdf, open the pdf and you may be able to
copy and paste from the pdf. I'm not 100% on this but it is worth a
try. I know it works on a Mac.
Getting to your script. In the first step you may want to try:
Set Variable [ $$vvalue; Value:GetAsText ( table_name::field_name) ]
This should give you a text string in your $$vvalue variable .
You listing implies that you getting the value for $$value from another
variable $$vfieldname. Is this the case or is it from an actual field?
If it is a variable, what should the value be?
If this doesn't help try the suggestions for posting you script so we
can take a look at the actual scripts.
Best regards
Bruce Herbach
Ron wrote:
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...
