Let ([

$n = $n + 150 ;

Calc = "getnthrecord (TableA::ChargeFoundSet; $n ) & ¶ &  "

];

Evaluate ( Calc )

)

thanks,

-i

Try this and see what it returns:

Let ([

$n = $n + 150 ;

Calc = "getnthrecord (TableA::ChargeFoundSet; $n ) & ¶ & "

];

EvaluationError( Evaluate ( Calc ) )

)

Try this and see what it returns:

Let ([

$n = $n + 150 ;

Calc = "getnthrecord (TableA::ChargeFoundSet; $n ) & ¶ & "

];

EvaluationError( Evaluate ( Calc ) )

)

#1204 = Number, text constant, field name or "(" expected

However, running it like this gives me a result. I am so confused why?

Evaluate ( "

GetNthRecord ( TableA::ChargeFoundSet;  3 )

")

Check the value of the variable Calc before it's being evaluated.

Check the value of the variable Calc before it's being evaluated.

Check the value of the variable Calc before it's being evaluated.

It didn't like this

 & ¶ & 

Correct.

Be careful of using Evaluate() on the contents of a field. It opens up the FMP-equivilent of SQL injection attacks that could be used to change global variables.