PDA

View Full Version : Syntax error filter function



Antonio Jiménez
22-Apr-2010, 02:46 AM
Hi,

I get invalid command 'Left' in this filter function:

Left({FAC_D016.ARTICULO},2)<>"FP"

How should it be?

Vincent Oorsprong
22-Apr-2010, 03:47 AM
Antonio,

Is this your full formula?

If it is it should be:

return (left ({FAC_D016.ARTICULO},2)<>"FP")

Antonio Jiménez
22-Apr-2010, 08:32 AM
Thanks Vincent,

I forgot to look in the User's Guide!!

Page 24
An example for building a function that returns the first 10 characters from the name of a customer:
Step1: Double-click the ‘Return’ expression in the middle treeview