problem with oracle database [SOLVED]

Talk about working with different database types

Moderator: alexandrleonenko

deeptibaghel
Newbie
Newbie
Posts: 2
Joined: Jun 26th, '09, 11:38

problem with oracle database [SOLVED]

Postby deeptibaghel » Jun 26th, '09, 11:46

I am trying to use php datagrid with oracle database.
The problem is that it fetches all the row ids (rid) as -1 , hence no data shows in edit mode.
Also it show the warning for the primary key field, though it is a primary key of number datatype.
I have attached screenshots depicting the same.
The version is PHP DataGrid Pro version 5.0.4

Please help.
Attachments
grid2.zip
(22.2 KiB) Downloaded 231 times

deeptibaghel
Newbie
Newbie
Posts: 2
Joined: Jun 26th, '09, 11:38

Re: problem with oracle database

Postby deeptibaghel » Jun 29th, '09, 07:46

I could solve it myself, in the line specifying the primary key, the column name must be given in capital as oracle returns it in capital
like
$primary_key = "ID";
instead of
$primary_key = "id";

Deepti


Return to “Databases: different types implementation”