thinkphp3.2 连sqlserver数据库,有个表名是BillFormat,结果报错:
:(
208:[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]对象名 'bill_format' 无效。 [ SQL语句 ] : SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [bill_format]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10)
原因是thinkphp3.2把所有表名里面的大写字母转为小写,而且还加了_,
解决方法:
把Model.class.php的第1772行
$tableName .= parse_name($this->name);
改为:
$tableName .= $this->name;