Hi Chuck,
Thanks for your post yesterday. I am still having problems with scripting inside FM.
Could you possibly shed some light of what is going on here with the If statement?
1/
In the Script Definition window I see this:
if ["not IsEmpty(indoRelShip::Games1)"] instead of, as you have it in your example :
if [not IsEmpty(indoRelShip::Games1)]
Why is the program adding quotes to my code?
All I type in the Specify Calculation window is :
not IsEmpty(indoRelShip::Games1)
where indoRelShip is my SelfJoin and Games1 the first field I am searching through
2/
[Games1 , indoRelShip::Games1]
I can't get the program to accept the line above in the Specify Calculation window.
I want to write:
Set Field [ Games1 , indoRelShip::Games1] and it keeps rejecting this with claims of too many operators??
Is the scripting case-sensitive?
Wish I had more flexibility in the script window. ie wish I could write the code myself not rely on a function menu to clickon. Very frustrating.
I am a programmer by the way.
Thanks again for any help,
Patrick
quote:
Originally posted by Chuck:
Set up a self join relationship based on the field that you want the merge to be based on. In this case it would be the name field. Place a portal of that relationship on a layout, and script a loop through the portal, setting fields from related records to fields in your current record. If you allow the deletion of records in the portal, then once you've gotten the information you can delete the related records (since you have the data in the current record) and move on the the next record in a loop.
Just to make sure that it's all working right, since the final script would delete records, I would make sure to have a backup of the database.
The script would look like this:
Go to Record/Request/Page [ First ]
Loop
Go to Portal Row [ SelfJoin ]
Loop
If [ not IsEmpty ( SelfJoin::Sports ) ]
Set Field [ Sports, SelfJoin::Sports ]
End If
If [ not IsEmpty ( SelfJoin::Music ) ]
Set Field [ Music, SelfJoin::Music ]
End If
If [ not isEmpty ( SelfJoin::Arts ) ]
Set Field [ Arts, SelfJoin::Arts ]
End If
Go to Portal Row [ Next, Exit after last ]
End Loop
Go to Record/Request/Page [ Next, Exit after last ]
End Loop
This assumes that only one of the records will have information you want to keep for each individual field.
