Variables are not ceated in script

[christian77]

Hi:

I have this simple script:

LET vL.StartingDate = num(YearStart(today()));       

LET vL.EndingDate = '20130131';   ////num(today());                                
Calendar:

LOAD
date(recno()+$(vL.StartingDate)-1,'YYYYMMDD')             as SDate

autogenerate($(vL.EndingDate)-$(vL.StartingDate)+1);

for i = 0 to 1 ///NoOfRows(CalendarSAP)-1   /// Uncomment later. It works fine with NoOfRows

LET  vL.LoopingDate = peek('SDate',$(i),'Calendar');
trace $(vL.LoopingDate);

MYTABLE:LOAD date,
     field1,
     field2FROM
[prueba.xls]
(biff, embedded labels, table is [Sheet1$])where date = $(vL.LoopingDate);
next i;
LET vL.Filas = NoOfRows(MYTABLE);   ////DON'T WORK. WHAT CAN I DO

LET vL.Columnas = NoOfRows(MYTABLE); ////DON'T WORK. WHAT CAN I DO

Store * from MYTABLE into MYTABLE.QVD;

//Drop table MYTABLE;

vL.Filas and vL.Columnas don't get created. How can I get that information?

Thank you.

[christian77]

Halleluiah!!!!

I must thank you all. Since flipside was 8 minutes before I have to act in consequence.

World would be much easier if there were not underscores, and other special characters misused. I can’t change that name yet, cause I have to follow client naming system.

Once they gave me a password for an ftp with a slash on it ‘/’. I knew from the beginning it wasn’t going to work.

Thank you all once again.

[christian77]

Hi.

Eveything works fine now. Sometimes I have to change things before I post; Data Confidentiality. I'm not loading from excel, I'm loading from SAP, that's why I have to slice the loading.

Thanks again.