Hi,
I wanna use something like a space holder for a prompt textfield. For example, if the user beginns the string with an * I wanna use the operator "CONTAINS" if the user uses a * as a placeholder in his string I wanna use "STARTS WITH".
I tried it with a simple if function, but got only some strange errors.
IF (?Parameter? STARTS WITH '*')
THEN (Database.Table.Field CONTAINS ?Parameter?)
IF (?Parameter? CONTAINS '*')
THEN ((Database.Table.Field STARTS WITH '?Parameter?)
ELSE (Database.Table.Field = '?Parameter?)
END
any help would be appreciated,
Namh
I wanna use something like a space holder for a prompt textfield. For example, if the user beginns the string with an * I wanna use the operator "CONTAINS" if the user uses a * as a placeholder in his string I wanna use "STARTS WITH".
I tried it with a simple if function, but got only some strange errors.
IF (?Parameter? STARTS WITH '*')
THEN (Database.Table.Field CONTAINS ?Parameter?)
IF (?Parameter? CONTAINS '*')
THEN ((Database.Table.Field STARTS WITH '?Parameter?)
ELSE (Database.Table.Field = '?Parameter?)
END
any help would be appreciated,
Namh