dpQuery - variable in WHERE

[Balewski]

Hi all,

I am trying to use a variable in dpQuery in WHERE section:

bit32 x=00000000000000000000000000000001;

dpQuery("SELECT '_online.._value' FROM '*.konfig.grupa*' WHERE ('_online.._value'&\\""+x+"\\")==\\""+x+"\\" " ,tab);

it does not find anything.

when I do it like this:

dpQuery("SELECT '_online.._value' FROM '*.konfig.grupa*' WHERE ('_online.._value'&00000000000000000000000000000001)==00000000000000000000000000000001 " ,tab);

it works fine.

Any help?

Thanks.
Michal

[dbindernagel]

The query you are creating for the dpQuery is different than the query in your working example.

Code: Select all

SELECT '_online.._value' FROM '*.konfig.grupa*' WHERE ('_online.._value'&"00000000000000000000000000000001")=="00000000000000000000000000000001" 

Code: Select all

SELECT '_online.._value' FROM '*.konfig.grupa*' WHERE ('_online.._value'&00000000000000000000000000000001)==00000000000000000000000000000001