通过Portal的Filemaker循环

Question

我正在尝试创建一个循环来删除所有门户行。但循环并没有停止。我做错什么了？

Go to Portal Row [Select; First]
Loop
  Delete Portal Row [No Dialog]
  Go To Portal Row [Next; Exit after last]
End Loop

Answer 1

我怀疑你在你的人际关系图上有Allow creation of related records through this relationship。这意味着门户中总是有一条记录，而该记录不能被删除，因为它是用户输入新数据的地方。

您可以将脚本修改为如下内容：

Go to Portal Row [Select; First]
Loop
   Delete Portal Row [No dialog]
   Go to Portal Row [Select; First]
   Exit Loop If [IsEmpty(relationship::index)]
End Loop

其中relationship::index是存储在外部表每个字段中的值。

像这样操作门户可能是很棘手的。您可以考虑使用“转到相关记录”脚本步骤Go删除记录。类似于：

Set Error Capture [On]
#
# Attempt to go to the related records, creating a new window "delete records"
Go to Related Record [Show only related records; From table: "<relatedtable>"; Using layout: "<relatedlayout>" (<relatedtable>); New window]
#
# If that failed exit the script. We should still be in the same window and layout.
If [not Get ( LastError )]
   Exit Script []
End If
#
# Otherwise delete all found records
Delete All Records [No dialog]
#
# And close the window we created
Close Window [Name: "delete steps"; Current file]
Set Error Capture [Off]