By default, the Update Fixture of the FitNesse iDempiere suite does not accept variables on the Where Clause. Because of that, is a little hard to make dynamic tests, that requires an specific ID to be updated.
To fix that, I've changed the UpdateRecords.java, inside de FitNesseFixture package to make it evaluate the variables.
As it seems, it only gets the where clause from the Fixture Table and appends it into the sql string. To solve it, I added the following lines:
And now the Update Fixture understands variables and include their real values into the sql parameters.
The delete fixture was exactly the same. So I added the same code above in the DeleteRecord.java as well.
You'll find the prints and the patch file anexed here.
Hope that I've helped.
Mate Desktop Environment
Kernel Linux 4.8.0-39-generic x86_64
Oracle JDK 10
Closing as Potential-Idea.
I'll leave it to for review, as he's the maintainer of the fitnesse as repository.
Please reopen if is worthy to integrate.