softmafia
Posts: 44
|
| Posted: 03/27/2013, 11:23 AM |
|
I keep getting this error when use Editable grid and Record and Grid Builder
Can anybody Help me am tired.
Database Error: 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 (item_id, orderdate, totalcost, quantity, booking_id) VALUES(1, '03/27/201' at line 1
_________________
softmafia |
 |
 |
Lucius
Posts: 220
|
| Posted: 03/27/2013, 3:47 PM |
|
Hi,
Your date format looks weird: '03/27/201'
If that's not it, you should output the full SQL of the insert you try to do and then debug it.
|
|
|
|
softmafia
Posts: 44
|
| Posted: 03/27/2013, 9:53 PM |
|
Hi Lucius i have resolved it
it wasn't My date format that was the problem
it was my access database design that wasn't corresponding
to MySQL so i have corrected the MySQL now
and its OK
_________________
softmafia |
|
|
|
|
