ChuckBell
commented
3 years ago Hi,
Not directly, no, but the modification isn’t difficult. You could simply write a special handler as part of parse_error_packet(), add code to execute_query(), or add a function to return the error number (best solution).
Dr. Bell
Hint (warning: not tested):
--- /Users/cbell/source/MySQL_Connector_Arduino/src/MySQL_Cursor.h 2020-09-03 15:37:28.000000000 -0400 +++ ./MySQL_Cursor.h 2021-01-04 14:04:20.000000000 -0500 @@ -79,6 +79,7 @@ void show_results(); int get_rows_affected() { return rows_affected; } int get_last_insert_id() { return last_insert_id; }
-
int get_error() { return conn->read_int(5, 2); }
endif
private:
And in your sketch, do something like this (again, not tested):
if (!cur.execute(query)) { If (cur.get_error() == 75) { Serial.println(“My custom error. “); } else { Serial.print(“ERROR: Wonkification in progress. Error code=“); Serial.println(cur.get_error()); } }
On Jan 4, 2021, at 1:31 PM, quakef4 notifications@github.com wrote:
Hello, I would need to memorize the type of error within a variable: Example this: Error: 75 = Deadlock found when trying to get lock; try restarting transaction. in this case, I would need to memorize the number 75 inside a variable.
Is this possible without making changes to the library?
Thanks in advance!
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/163, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYBOMZJZYVY7JYNLOXLSYICOZANCNFSM4VTMKLXQ.
quakef4
Hello, I would need to memorize the type of error within a variable: Example this:
Error: 75 = Deadlock found when trying to get lock; try restarting transaction.in this case, I would need to memorize the number 75 inside a variable.Is this possible without making changes to the library?
Thanks in advance!