How to solve the error "The query builder failed."
-
Hi.. I m using mysql database. In my table adapter, I have 2 queries. Query(1) INSERT INTO comment (commentID, reviewID, commentStatus, submitterID, commentDate, lastUpadatedDate) VALUES (?commentID, ?reviewID, ?commentStatus, ?submitterID, ?commentDate, ?lastUpadatedDate) Query(2) INSERT INTO commentdetail (commentDetailID, commentID, commentType, locator1, locator2, comment, remark) VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2, ?comment, ?remark) i can add the Query(1). but everytime i tried to add Query(2) displays the following error. The query builder failed. Attempted to read or write protected memory. This is often an indication that other memory is corrupt. i need urgently.. Could anyone know how to solve this error,Please? thanks in advance.
-
Hi.. I m using mysql database. In my table adapter, I have 2 queries. Query(1) INSERT INTO comment (commentID, reviewID, commentStatus, submitterID, commentDate, lastUpadatedDate) VALUES (?commentID, ?reviewID, ?commentStatus, ?submitterID, ?commentDate, ?lastUpadatedDate) Query(2) INSERT INTO commentdetail (commentDetailID, commentID, commentType, locator1, locator2, comment, remark) VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2, ?comment, ?remark) i can add the Query(1). but everytime i tried to add Query(2) displays the following error. The query builder failed. Attempted to read or write protected memory. This is often an indication that other memory is corrupt. i need urgently.. Could anyone know how to solve this error,Please? thanks in advance.
-
Hi.. I m using mysql database. In my table adapter, I have 2 queries. Query(1) INSERT INTO comment (commentID, reviewID, commentStatus, submitterID, commentDate, lastUpadatedDate) VALUES (?commentID, ?reviewID, ?commentStatus, ?submitterID, ?commentDate, ?lastUpadatedDate) Query(2) INSERT INTO commentdetail (commentDetailID, commentID, commentType, locator1, locator2, comment, remark) VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2, ?comment, ?remark) i can add the Query(1). but everytime i tried to add Query(2) displays the following error. The query builder failed. Attempted to read or write protected memory. This is often an indication that other memory is corrupt. i need urgently.. Could anyone know how to solve this error,Please? thanks in advance.
Haven't used MySql really so just guessing here. In the second statement, you have a potentially reserved word
commentand alsoremark. Try removing them from the statement:INSERT INTO commentdetail
(commentDetailID, commentID, commentType, locator1, locator2)
VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2)The need to optimize rises from a bad design. My articles[^]