AnsweredAssumed Answered

ExecuteSQL Problem

Question asked by mr.voyager on Dec 5, 2015
Latest reply on Dec 7, 2015 by okramis

Hi everyone,

 

I'm trying to adapt the Outer Join Demo of the Kevin Frank.

Only one diffrence than the demo is that I have 70 Columns.

 

Problem is in the $$theArray variable. It's getting blank results (except first six columns).

But, if I write the SELECET clauses with 30 repetition in the eSQL, there is no problem. Everything works fine.

When i expand the column with SELECT clauses its working so weird like this.

I'm pulling my hair out - What's my wrong?

 

Thanks in advance for any help,

 

Recep

 

 

PS: Here is my $$theArray variable script;

 

Let ( [

x1 = GetValue ( $$YemekIDList ; 1 );

x2 = GetValue ( $$YemekIDList ; 2 );

x3 = GetValue ( $$YemekIDList ; 3 );

x4 = GetValue ( $$YemekIDList ; 4 );

x5 = GetValue ( $$YemekIDList ; 5 );

x6 = GetValue ( $$YemekIDList ; 6 );

x7 = GetValue ( $$YemekIDList ; 7 );

x8 = GetValue ( $$YemekIDList ; 8 );

x9 = GetValue ( $$YemekIDList ; 9 );

x10 = GetValue ( $$YemekIDList ; 10 );

x11 = GetValue ( $$YemekIDList ; 11 );

x12 = GetValue ( $$YemekIDList ; 12 );

x13 = GetValue ( $$YemekIDList ; 13 );

x14 = GetValue ( $$YemekIDList ; 14 );

x15 = GetValue ( $$YemekIDList ; 15 );

x16 = GetValue ( $$YemekIDList ; 16 );

x17 = GetValue ( $$YemekIDList ; 17 );

x18 = GetValue ( $$YemekIDList ; 18 );

x19 = GetValue ( $$YemekIDList ; 19 );

x20 = GetValue ( $$YemekIDList ; 20 );

x21 = GetValue ( $$YemekIDList ; 21 );

x22 = GetValue ( $$YemekIDList ; 22 );

x23 = GetValue ( $$YemekIDList ; 23 );

x24 = GetValue ( $$YemekIDList ; 24 );

x25 = GetValue ( $$YemekIDList ; 25 );

x26 = GetValue ( $$YemekIDList ; 26 );

x27 = GetValue ( $$YemekIDList ; 27 );

x28 = GetValue ( $$YemekIDList ; 28 );

x29 = GetValue ( $$YemekIDList ; 29 );

x30 = GetValue ( $$YemekIDList ; 30 );

x31 = GetValue ( $$YemekIDList ; 31 );

x32 = GetValue ( $$YemekIDList ; 32 );

x33 = GetValue ( $$YemekIDList ; 33 );

x34 = GetValue ( $$YemekIDList ; 34 )

 

];

 

ExecuteSQL ( "SELECT a.\"__id\" ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" ) ,

( SELECT Porsiyon FROM vl_UPLITEMS AS b WHERE \"_idYMK\" = ? AND PlanTarihi = ? AND \"_idOgun\" = ? AND \"_idMUS\" = a.\"__id\" )

 

FROM MST AS a"

 

; "•" ; "" ;

 

x1 ; UPL::PlanTarihi ; UPL::_idOgun ;

x2 ; UPL::PlanTarihi ; UPL::_idOgun ;

x3 ; UPL::PlanTarihi ; UPL::_idOgun ;

x4 ; UPL::PlanTarihi ; UPL::_idOgun ;

x5 ; UPL::PlanTarihi ; UPL::_idOgun ;

x6 ; UPL::PlanTarihi ; UPL::_idOgun ;

x7 ; UPL::PlanTarihi ; UPL::_idOgun ;

x8 ; UPL::PlanTarihi ; UPL::_idOgun ;

x9 ; UPL::PlanTarihi ; UPL::_idOgun ;

x10 ; UPL::PlanTarihi ; UPL::_idOgun ;

x11 ; UPL::PlanTarihi ; UPL::_idOgun ;

x12 ; UPL::PlanTarihi ; UPL::_idOgun ;

x13 ; UPL::PlanTarihi ; UPL::_idOgun ;

x14 ; UPL::PlanTarihi ; UPL::_idOgun ;

x15 ; UPL::PlanTarihi ; UPL::_idOgun ;

x16 ; UPL::PlanTarihi ; UPL::_idOgun ;

x17 ; UPL::PlanTarihi ; UPL::_idOgun ;

x18 ; UPL::PlanTarihi ; UPL::_idOgun ;

x19 ; UPL::PlanTarihi ; UPL::_idOgun ;

x20 ; UPL::PlanTarihi ; UPL::_idOgun ;

x21 ; UPL::PlanTarihi ; UPL::_idOgun ;

x22 ; UPL::PlanTarihi ; UPL::_idOgun ;

x23 ; UPL::PlanTarihi ; UPL::_idOgun ;

x24 ; UPL::PlanTarihi ; UPL::_idOgun ;

x25 ; UPL::PlanTarihi ; UPL::_idOgun ;

x26 ; UPL::PlanTarihi ; UPL::_idOgun ;

x27 ; UPL::PlanTarihi ; UPL::_idOgun ;

x28 ; UPL::PlanTarihi ; UPL::_idOgun ;

x29 ; UPL::PlanTarihi ; UPL::_idOgun ;

x30 ; UPL::PlanTarihi ; UPL::_idOgun ;

x31 ; UPL::PlanTarihi ; UPL::_idOgun ;

x32 ; UPL::PlanTarihi ; UPL::_idOgun ;

x33 ; UPL::PlanTarihi ; UPL::_idOgun ;

x34 ; UPL::PlanTarihi ; UPL::_idOgun

 

)

 

)

Outcomes