The expression contains an invalid string constant

Hi,

Can anybody help me with this:
test_dting.Select("[Pmt. Ref No] = "+get_txn).Count > 0

The output error:
image

Hi,

I’m assuming [Pmt. Ref No] is a column name and get_txn is a variable, can you try this below and see if it works?

test_dting.Select("[Pmt. Ref No] = ’ “+get_txn+” ’ ").Count > 0

1 Like

Hi,

image

:frowning:

Thanks!

Hi, Is your column name is like [Pmt. Ref No] or just Pmt. Ref No? If its just Pmt. Ref No, then remove the brackets.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.