Hi !!

Objective - to take data from 3 different tables - header, detail and footer and merge it into one file - and move the file into a sub directory - with a customized file name

e.g. - move 2g011304.txt .\gefu\2g011304.txt - which works at the command prompt - the same thing when it is executed in VFP using the run command - returns a bad command or file name message.

Code to achieve this

RUN TYPE &vheader >>&vFinalGefu ' merging files
RUN TYPE &vdetail >>&vFinalGefu ' merging files
RUN TYPE &vfoot >>&vFinalGefu ' merging files


This command - returns a bad command or filename message - in the command prompt - also part of the .prg file - which is being run

run move &vfinalgefu &vto 'Code to move a file (with a derived filename) into a subdirectory

where - vfinalgefu = "2g011304.txt" and vto= ".\gefu\2g011304.txt"

What could be the possible reason ?? - for this msg and Also - is there a better way - of achieving this


Rgds,

KB