script error

[master_student]

hello Guys,

I got this error :

here is my script : Erreur de ligne de script

let vDWDate = date(today()-5,'YYYY-MM-DD');

let vToday = date(today(),'YYYY-MM-DD');

for iDaysBack = 0 to (vToday - vDWDate)

let vNextDay = Date(vToday - iDaysBack, 'YYYY-MM-DD');

test:

load *

;

sql query

next

NoConcatenate

MontantRecouvrementBillCycle:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test;

drop table test;

let vDWDate1 = date(today()-5,'YYYY-MM-DD');

let vToday1 = date(today(),'YYYY-MM-DD');

for iDaysBack1 = 0 to (vToday1 - vDWDate1)

let vNextDay1 = Date(vToday1 - iDaysBack1, 'YYYY-MM-DD');

test1:

load *

;

sql query

next

NoConcatenate

requete2:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test1;

drop table test1;

exit script ;

[prma7799]

Please share your script..

[master_student]

ODBC CONNECT TO SYS_PROD;

let vDWDate1 = date(today()-5,'DD/MM/YYYY');

let vToday1 = date(today()-2,'DD/MM/YYYY');

for iDaysBack1 = 0 to (vToday1 - vDWDate1)

let vNextDay1 = Date(vToday1 - iDaysBack1, 'DD/MM/YYYY');

test1:

load *

;

select ....

where date_id =to_date('$(vNextDay1)' ,'DD/MM/YYYY')

and ...

group  by 1,2,3 ,4) a 

full outer join

(select

where date_id = date_trunc('month', to_date('$(vNextDay1)' ,'DD/MM/YYYY') )

and ......

next ;

NoConcatenate

requete2:

load *,

AutoNumber(MakeDate( Year(date_id), Month(date_id), Day(date_id)), '%Date ID') as [%Date ID]

resident test1;

drop table test1;

exit script ;

[prma7799]

Please terminate your sql statement with ; and try

select ....

where date_id =to_date('$(vNextDay1)' ,'DD/MM/YYYY')

and ...

group  by 1,2,3 ,4) a

full outer join

(select

where date_id = date_trunc('month', to_date('$(vNextDay1)' ,'DD/MM/YYYY') )

and ......

;

[master_student]

I already terminate it with ;

[prma7799]

Could you please share your application ?

[Anil_Babu_Samineni · Accepted solution]

Can you do this for me a while

SET ErrorMode = 0;

//SET ErrorMode = 0;

>>>>>>>>>>>> Script Here <<<<<<<<<<<<<

Trace 'Error Here' & Chr(10) & '$(ErrorMode)';

[master_student]

Thanks  Anil. it works but what was the pb?

[Anil_Babu_Samineni]

Look here ErrorMode ‒ QlikView