can not create editable grid view in some table

Applications Grid / Reports
#1

It tell me sql error i try another table it can create only this table it have problen

CREATE TABLE presell (
id int(11) NOT NULL AUTO_INCREMENT,
refid int(150) NOT NULL,
productcode varchar(100) NOT NULL,
productname varchar(200) DEFAULT NULL,
qutiy int(11) NOT NULL,
price decimal(11,2) NOT NULL,
stockcut enum(‘n’,‘y’) NOT NULL DEFAULT ‘n’,
datecreate datetime DEFAULT NULL,
timestamp timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
order enum(‘y’,‘n’) NOT NULL DEFAULT ‘n’,
PRIMARY KEY (id),
UNIQUE KEY myIndex (refid,productcode) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4139 DEFAULT CHARSET=utf8;

#2

Re: can not create editable grid view in some table

whats the sql error?

#3

Re: can not create editable grid view in some table

Error while accessing the database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘order from presell LIMIT 0,10’ at line 1
SelectLimit(SELECT id, refid, productcode, productname, qutiy, price, stockcut, datecreate, timestamp, order from presell, 10, 0)

#4

Re: can not create editable grid view in some table

What application are you trying to create? Grid, form …?

If grid, what sql are you using?

#5

Re: can not create editable grid view in some table

I can create your table without problems. Are you sure you use quotes around the column names? Especially column “order”, because this is a reserved word. By using quotes around the column name this should be ok.

From mysql documentation: A reserved word can be used as an identifier if you quote it.

Also in a select you must use quotes around reserverd words. Your select should be (works for me):
select id, refid, productcode, productname, qutiy, price, stockcut, datecreate, timestamp, ‘order’
from presell
LIMIT 0 , 100