Oracle Primary Key must be in UPPER CASE
please add to your documentation that the constructor for accessing an ORACLE table must have the Key field in UPPER CASE...
Your documentation:
$dg = new C_DataGrid("SELECT * FROM emp", array("empno"), "emp");
has to be:
$dg = new C_DataGrid("SELECT * FROM emp", array("EMPNO"), "emp");
otherwise you get this error:
Notice: Undefined index: myid in C:\xampp\htdocs\phpGridEnterprise\server\classes\clNotice: Undefined index: empno in C:\xampp\htdocs\phpGridEnterprise\server\classes\cls_util.php on line 68
It took me a long time to figure this out
1
vote
David M
shared this idea
-
Jon
commented
I am receiving this same error.
SQL Server 2008
PHP7
Uppercase did not resolve... help!!
-
AdminRichard
(Admin, phpGrid)
commented
Oracle queries are not case sensitive by default. What Oracle ver do you have?