Hi Sergey,
You are right, but the problem occurred when I created a cursor on a field which contains file names.
Fullpath() returns the current path for all the records.
SELECT Distinct fullpath(Names) AS FileNames FROM MyTable;
WHERE NOT allt(TableNames) == "" INTO CURSOR Tables
Did I make a mistake or what?
Thank you,
Ali
>>Hi everybody,
>>
>>When I use
fullpath() , it returns “full path and file name” in one place, yet it returns only full path in other cases. How can I force it to return “full path + file name” always?
>>
>>Thank you,
>
>Hi Ali,
>
>I'm not sure what you mean. If you pass file name, FULLPATH() will return file's full name (path + file name) if it can find the file along VFP search path. If it cannot find the file, it still returns full file name but the path is current VFP directory. If you call FULLPATH() with empty string, it'll return current VFP directory.