Skip to content

Notification "saved successful" but doesn't create new record

← Datagrid Edit
Be sure to use a single SELECT statement in your constructor. 

$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");

See Working with Complex Query tutorial. The edit/insert in complex query is limited to simple inner joins only.

Keep in mind that any direct editing is always limited to the primary table. Also check out this KB.