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 ;

[Anil_Babu_Samineni]

Script line Error, Can you please show error in image? Which line and please high light the line

[master_student]

[prma7799]

Please remove this "sql query"  and try  or comment that word .

Or

write proper statement in here

test:

load *

;

[master_student]

by sql query i mean : select * from xxx ....

[prma7799]

Please try to debug script one by one then you will get exact issue ...

[jonathandienst]

The sql statement has no semicolon to terminate it:

for iDaysBack = 0 to (vToday - vDWDate)

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

  test:

  load *

  ;

  sql query

next

[master_student]

the pb is with the next statment whene i comment it the sql query works but brings data of today only...

[master_student]

I didn't get your message what i am supposed to do?

Thanks

[master_student]

Any help please ??

Thanks