"Object not accessible. Invalid use of an object" after executeUpdate [closed]

asked 2018-03-15 15:28:15 +0100

RobVld gravatar image

When I run

                stSql = "INSERT INTO `labels` (`NoSAP`) VALUES ("+SAPnr+")"
            oResult = oSQL_Command.executeUpdate(stSql)

on a mariadb database a record will be inserted with the correct value stored in variable SAPnr, but right after that I receive an error "Object not accessible. Invalid use of an object"

What is going wrong??

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by RobVld
close date 2018-03-15 16:02:16.404991


It is solved I was running this query in result loop from another query... just had to rename oResult into oResult2....

RobVld gravatar imageRobVld ( 2018-03-15 16:01:41 +0100 )edit

In the future, you can post this as an answer so that it can be marked as accepted.

Jim K gravatar imageJim K ( 2018-03-16 16:14:36 +0100 )edit