Open Error DBF with dash

[serge_girard]

Does anybody know how to avoid this error:
It appears when opening a DBF with a dash char in it's name. Open the DBF file with a DBF viewer is no problem

Code: Select all

Subsystem 	DBFNTX
Subcode	1001
CanDefault	True
CanRetry	True
Description	Open error
Operation	
Filename	03012014-F0001.dbf
Oscode	2
Gencode	21
Severity	2

Thanks, Serge

[edk]

Hi Serge.

The problem is not the file name but Alias, which, if not declared, will take the file name. From what I remember, Alias cannot begin with a digit, it cannot contain a dash, comma, semicolon, spaces, period, etc.

Code: Select all

cDBF:='03012014-F0001.dbf'
Select 1
use &(cDbf) alias &(IF(IsDigit(hb_FNameName(cDBF)), '_', '') + StrTran(hb_FNameName(cDBF), "-","_"))
msgdebug(alias())
EDIT EXTENDED

[serge_girard]

Thanks !

Serge