From: Romel <ste...@ya...> - 2008-03-25 09:25:13
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> </head> <body bgcolor="#ffffff" text="#000000"> I try to add a new order but error as below.<br> <br> <div class="error"> <p><b>Database Error</b> : <br> Cannot add or update a child row: a foreign key constraint fails</p> </div> <b>Database SQL Failure</b> : The SQL that failed was<br> INSERT INTO salesorderdetails ( orderlineno, orderno, stkcode, unitprice, quantity, discountpercent, narrative, poline, itemdue) VALUES (0, 544, '0012', 30, 120, 0, '', '', '2008/04/05' )<br> <br> Thanks<br> <br> </body> </html> |