General OLEDB Error

[Anonymous]

Hi guys:

What is wrong with this statement :

CONCATENATE(thirdtable$(l))

select EventsTimeline.ID

FROM EventsTimeline where EventsTimeline.ComplexTypeID =$(complexid);

swuehl‌

stalwar1‌

[swuehl]

And your variable complexid expands to...?

[Anonymous]

there is a value inside comlexid variable which is  : 00000000-0000-0000-0000-000000000000

[Ricardo_Gerhard]

Dear Yaman,

  Is this message been displayed on Qlikview or Qlikview? When something wrong happens, the message should be displayed then you can understand.

  Please, catch the full message from when loading data or try to run the query without variables.This, could be a problem like Stefan already mentioned.

[Anonymous]

Thanks Mr.Ricardo

I saw these messeges :

[swuehl]

Try putting single quotes around your variable expansion in the where clause.

[Anonymous]

Thanks it is working now...