Recent

Author Topic: Error code 194  (Read 3285 times)

talorigomat

  • Jr. Member
  • **
  • Posts: 96
Error code 194
« on: March 23, 2017, 10:20:02 am »
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.
Lazarus 1.8.0Rc4, Windows 10

rvk

  • Hero Member
  • *****
  • Posts: 6111
Re: Error code 194
« Reply #1 on: March 23, 2017, 10:31:54 am »
194 isn't a Firebird specific code. Firebird has codes beginning with 33xxxxxxx.
See https://firebirdsql.org/file/documentation/reference_manuals/reference_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

  • Jr. Member
  • **
  • Posts: 96
Re: Error code 194
« Reply #2 on: March 23, 2017, 04:34:32 pm »
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.
Lazarus 1.8.0Rc4, Windows 10

 

TinyPortal © 2005-2018