Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Syntax error on set filter expression

  1. How-to
0
Votes
Undo
  1. Rômulo Sorato
    Rômulo Sorato
  2. PowerBuilder
  3. Friday, 27 September 2019 17:13 PM UTC

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) +" '")

  1. PowerScript (PS)
Richtexteditcontrol not rendering properly after b...
Automated UI Testing Tool
Accepted Answer
James Pendarvis
James Pendarvis Accepted Answer Pending Moderation
  1. Friday, 27 September 2019 17:38 PM UTC
  2. PowerBuilder
  3. # Permalink 
string Var1 
Var1 = string(long(llIdEstado))
parent.dw_listagem_pessoas.SetFilter("estados_id = '"+ var1 +" '")


This might work.
Comment
Load more comments
Rômulo Sorato
  1. Rômulo Sorato
  2. Friday, 27 September 2019 18:01 PM UTC
i removed but still not working.

Im inside a button click event
  1. Helpful
Rômulo Sorato
  1. Rômulo Sorato
  2. Friday, 27 September 2019 20:02 PM UTC
It´s working now.

I was typing the column name wrong.

Thanks!
  1. Helpful
Michael Kramer
  1. Michael Kramer
  2. Sunday, 29 September 2019 13:29 PM UTC
NOTE: Watch out for the space before final single quote. Say llIdEstado = 56. In that case the filter expression above becomes >>estados_id = '56 '
  1. Helpful
There are no comments made yet.
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 27 September 2019 18:52 PM UTC
  2. PowerBuilder
  3. # 1

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

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 27 September 2019 17:41 PM UTC
  2. PowerBuilder
  3. # 2

Hi  Rômulo;

  Try it without the single quotes ...

 parent.dw_listagem_pessoas.SetFilter("estados_id = "+ string(llIdEstado) )

Regards ... Chris

Comment
Rômulo Sorato
  1. Rômulo Sorato
  2. Friday, 27 September 2019 17:46 PM UTC
I had already tried this way, but still not worked
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.