Error code 194
lazarus / 16-Databases

----------------------------------------------------------------------
talorigomat · 2017-03-23 09:20

A colleague received the following error message: conGov: Execute: -
error code 194.  The error message was generated by TIBConnection. 
I'm using Firebird database and didn't find this error code in their
documentation.  Does anyone know what this is?  I haven't been able to
replicate the error.  My current assumption is that the program lost
connection to the database at some point.

----------------------------------------------------------------------
rvk · 2017-03-23 09:31

194 isn't a Firebird specific code. Firebird has codes beginning with
33xxxxxxx.
See https://firebirdsql.org/file/documentation/reference_manuals/refer
ence_material/Firebird-2.1-ErrorCodes.pdf

194 isn't in there either.

But searching for SQLCodes I found -194 (notice the negative).
http://dcx.sap.com/1101/en/saerrors_en11/sa-errors-by-sqlcode.html

-194 could be "No primary key value for foreign key '%1' in table
'%2'"
http://dcx.sap.com/1101/en/saerrors_en11/errm194.html

But if the error isn't reproducible maybe it's time to log these
errors (including their description) in an errorlog in your program.

----------------------------------------------------------------------
talorigomat · 2017-03-23 15:34

Thanks rvk.  You've given me an avenue to explore.  I have now done an
error logging routine since this occurred.  In the screenshot I was
sent (see attachment) there wasn't a minus sign in front of the
number.