Access tables with dot in the name

PHPMaker General Discussion (PHPMaker)
1

Hi, Is there a way to access tables that have a dot in the name? I’m using a SQL database.Does not work
$sbm_row = ExecuteRow(“SELECT * FROM ACTB.TableName WHERE refnumb=‘$number’”);Works
$sbm_row = ExecuteRow(“SELECT * FROM ACTBTableName WHERE refnumb=‘$number’”);Thank you

2

If you meant MS SQL Server, you may quote the names, e.g. [ACTB.TableName].Note: It is better not to use dots in table name because dots are used to separate identifiers, see:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms187879(v=sql.105)