Hello.
I have a set filter expression but the PB is telling that has an syntax error.
What is the right syntax to compare a column to a long variable?
Here is the expression that is returning me an error
parent.dw_listagem_pessoas.SetFilter("estados_id = '"+ string(llIdEstado) +" '")
Hi Rômulo;
Another trick that I do quite often is to use the DW Painter. In this painter, select the DWO you are working scripting. Then proceed to the Filter dialogue (Rows=>Filter menu). In the Filter dialogue, play with the filter expression until it works (use the Verify CB). Once you have that expression working, copy the filter expression back over to your PowerScript area.
HTH
Regards ... Chris
Im inside a button click event
I was typing the column name wrong.
Thanks!