>Hello All,
>
>I'd like to append one text file into a table but when I put that text file into directory name which is contain space in it, VFP will give an error message "Unrecognized command..."
>
>eg.
>directory name= "h:\project finance\" failed.
> change to = "h:\project_finance\" success
>
>used syntax:
>m_file=getfile()
>appe from &m_file sdf
>
>
>is there any specific command to handle this problem.
Yep - don't use macro expansion if you can avoid it; you create your own problems for the command line parser in the example above, because the space in the macro-expanded line is seen as a peparator. You could encapsulate the macro expansion in quotes, but using name resolution instead would avoid the problem neatly, and is faster as well! For the example above, try:
m_file = GETFILE()
APPEND FROM (m_file) SDF
or if you didn't need to save the file name at all beyond the APPEND:
APPEND FROM (GETFILE()) SDF