VFP 愛用者社區

[Bill Chen]

請問如何解決以下的問題,

vfilename = "D:\labelview\copy of abcde.xls"
Append from &vfilename type xls

因為是長檔名, 所以會發生錯誤. 其後我把它改為 "D:\labelv~1\copyof~1.xls"
但仍說找不到檔案.

[garfield]

vfilename = ["D:\labelview\copy of abcde.xls" ]
用"將長檔名標示起來即可.

[winweek]

vfilename = "D:\labelview\copy of abcde.xls"
Append from (vfilename) type xls

[catjoke]

vfilename = "D:\labelview\copy of abcde.xls"
Append from GetShortName(vfilename) type xls

* LONG NAME -> SHORT NAME
FUNCTION GetShortName
LPARAMETERS cPathToConvert
LOCAL cBuf, nBufSize, nShortSize

IF TYPE([cPathToConvert]) # [C] .OR. LEN(cPathToConvert) = 0
* Nothing to convert
RETURN []
ENDIF

DECLARE INTEGER GetShortPathName IN Win32API ;
STRING @cLongPath, ;
STRING @cShortPathBuff, ;
INTEGER nBuffSize

cBuf = SPACE(511)
nBufSize = 511
nShortSize = GetShortPathName(cPathToConvert, @cBuf, @nBufSize)
IF nShortSize > 0
RETURN LEFT(cBuf, nShortSize)
ELSE
RETURN []
ENDIF

ENDFUNC

[yder]

這篇文章討論時間是早在六年前.
六年之後, 對我這個初學者, 還是有超大的幫助.
一舉解決長檔名的困擾.
萬分感謝.

[pilipala]

那應該再看看這兩篇
http://vfp.sunyear.com.tw/viewtopic.php?t=4631&highlight=EXE
http://support.microsoft.com/kb/125046/en-us?spid=7992&sid=global

[goodnight]