Delete portal row

[alitheg]

Is there a way to delete the SCEOND LAST portal row?

[Lee Smith]

As in "[color:"blue"]Allow deletion of portal records" that is available by going into Layout Mode and then Double Click On the Portal. The Portal Setup window will popup, and it is the First Option [color:"blue"]"Allow deletion of portal records"

HTH

Lee

[alitheg]

I have that selected, but I would like to delete the second last row in my portal using a script. I can only delete the first, last, number or field contents.

[Echo33029]

1. Create a global field called gRowToDelete

2. In a script enter the following commands

Go To Portal ROw (Last)

Set Field(gRowToDelete, status(currentportalrow) - 1)

if gRowToDelete > 0 then

delete portal row(gRowToDelete)

Basically you want to save the row number of the last row in the portal to a field, subtract 1 from that number and then use the delete portal row script step to delete the appropriate row. If you are using FM7, change the status command to the appropriate FM7 equivalent.

Hope this helps

Echo

[alitheg]

Thanks to you both, I have managed to solve the problem. Help appreciated!