Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor II

General OLEDB Error

Hi guys:

What is wrong with this statement :

CONCATENATE(thirdtable$(l))

select EventsTimeline.ID

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

swuehl

stalwar1

Tags (1)
6 Replies
MVP
MVP

Re: General OLEDB Error

And your variable complexid expands to...?

yamananalytic
Contributor II

Re: General OLEDB Error

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

dcj
Valued Contributor II

Re: General OLEDB Error

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.

yamananalytic
Contributor II

Re: General OLEDB Error

Thanks Mr.Ricardo

I saw these messeges :

111.png

MVP
MVP

Re: General OLEDB Error

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

yamananalytic
Contributor II

Re: General OLEDB Error

Thanks it is working now...