Edit/delete/modify button

[Vivek]

Hi,

I am facing a problem when i select a table and press "Show all records" in this page Edit/Delete/Modify button is not displaying. Please help me to solve this problem

I already set primary key set but still its not working.

I am using mysql 4.0.16 and dadabik version is 2.2.1. please let me know how to assign key in table.


Her is the sql script . Its not working with this script.

CREATE TABLE admin (
admin_id int(3) unsigned NOT NULL default '0',
uid varchar(20) NOT NULL default '',
pwd varchar(20) NOT NULL default '',
name varchar(30) default NULL,
is_active char(1) NOT NULL default 'Y',
is_deleted char(1) NOT NULL default 'N',
added_on datetime NOT NULL default '0000-00-00 00:00:00',
modified_on datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (admin_id),
KEY NewIndex (admin_id)
) TYPE=MyISAM;


Vivek

 

[Jeff]

U need to go to "admin.php" and select the appropriate table u want to work with. After that, scroll down a little and u should see fields marked "allow user to edit/delete/modify this table?" or something similar. Click on the permissions u want to give yourself. It should be that simple.

Cheers!

 

[Vivek]

Hi,

Thankyou for your reply.

I have try the option given under "admin.php" file. But When i install any database from "admin.php" file it gives a error as follows.

"You database does not have any primary key set."

but i have declare primary key in database

CREATE TABLE admin (
admin_id int(3) unsigned NOT NULL default '0',
uid varchar(20) NOT NULL default '',
pwd varchar(20) NOT NULL default '',
name varchar(30) default NULL,
is_active char(1) NOT NULL default 'Y',
is_deleted char(1) NOT NULL default 'N',
added_on datetime NOT NULL default '0000-00-00 00:00:00',
modified_on datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (admin_id),
KEY NewIndex (admin_id)
) TYPE=MyISAM;

Please help to solve this problem

 

[Eugenio]

Vivek wrote:

> Hi,
>
> Thankyou for your reply.
>
> I have try the option given under "admin.php" file. But When
> i install any database from "admin.php" file it gives a error
> as follows.
>
> "You database does not have any primary key set."

[....]

Duplicated post, see here:
http://www.dadabik.org/forum/read.php?f=2&i=234&t=231



(Latest version of DaDaBIK when this message was posted: 2.2.1)