[RBASE-L] - BUILDING A FILENAME

[mike epstein sony viao office]

I know that I have done this before but can remember how I did it.

 

SET VAR vfnam TEXT = 'MORDER'

CHOOSE vfdate FROM #VALUES FOR DISTINCT pdate FROM mordrs WHERE pdate >
(.#DATE-12)

SET VAR vfdate1 DATE = .vfdate

SET VAR vfdate TEXT =(SSTRIPI(.vfdate,'/'))

 

SET VAR vfnmndt TEXT = (.vfnam+.vfdate+ '.CSV')  this is file
'morder07012012.csv'

 

 

 

I am trying to export a csv file from a table using gateway .  I was able to
create the filename (above) 

But can't get the filename of the variable ( .vfnmndt)

To list as  f:\rbti\nrbfiles\'morder07012012.csv

 

 

GATEWAY EXPORT csv .VFNMDT +

SELECT QTY PARTID FROM MORDRS WHERE PDATE =.VFDATE1 +

OPTION COL_NAMES OFF +

|HEADER_TEXT SOURCE '.VFNMNDT' +

|SHOW_PROGRESS ON +

|ACTION OPENVIEW

SET TRACE OFF

RETURN