|
Written on: 16. 03. 2017 [21:10]
|
|
cvillegas
Claudio Villegas
Topic creator
registered since: 26.10.2016
Posts: 14
|
I have implemented a scrip that generates alarms and stores them in a DB table.
For the interaction with the database I used the "dbReqSQL" function and everything perfect.
However, I can not find the way to read the message or error code when a SQL query is erroneous, it only returns the empty array.
Is there any way to get error messages from the DB after running "dbReqSQL"?
regards
|
|
Written on: 17. 03. 2017 [07:45]
|
|
roman
Roman Savochenko
Moderator Contributor Developer
registered since: 12.12.2007
Posts: 3742
|
"cvillegas" wrote:
I have implemented a scrip that generates alarms and stores them in a DB table.
For the interaction with the database I used the "dbReqSQL" function and everything perfect.
However, I can not find the way to read the message or error code when a SQL query is erroneous, it only returns the empty array.
See here!
Array SQLReq( string req, bool tr = EVAL_BOOL ); — Formation of the SQL-request to the DB, inside (tr=true), outside (tr=false) or no matter (tr=EVAL_BOOL) to transaction. At an error the result's property "err" sets to the error value.
Learn, learn and learn better than work, work and work.
|
