HMGforum.com

Posted: **Sun Nov 03, 2019 10:31 am**

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

Posted: **Sun Nov 03, 2019 3:21 pm**

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

Posted: **Sun Nov 03, 2019 4:21 pm**

Thanks !

Serge

HMGforum.com

Open Error DBF with dash

Open Error DBF with dash

Re: Open Error DBF with dash

Re: Open Error DBF with dash