SelectionFormula problem

[jewels1]

I have a CR with an SQL statement with an existing where clause. I also want to populate a SelectionFormula to add further criteria from my VB program.

When I put the criteria directly into CR this works, yet when I copy it to VB it gives me an error :

&quot;Error in formula <Record_Selection>
'
'
The remaining text does not appear to be part of the formula.

The VB statement looks like this :
rpt1.SelectionFormula = &quot; {client.client_id} = 1 AND {client.address_id} = 1&quot;


Any ideas, please ?

 

[AAP]

I don't use VB myself, but this often helps in other languages.

rpt1.SelectionFormula = &quot; ({client.client_id} = 1) AND ({client.address_id} = 1)&quot;

Notice the extra brackets. This should clarify the evaluation order of the expression.

 

[paulcat]

Unless the id & address in the above sample is numeric data, they must have single quotes around them if they are to be contained within another string which is enclosed in double quotes. ie:
rpt1.SelectionFormula = &quot; {client.client_id} = '1' AND {client.address_id} = '1'&quot;

Hope this helps.