On 12/12/2018 11:00 AM, Dimitry Sibiryakov sd@... [firebird-support] wrote:

12.12.2018 16:45, Robert Tulloch tultalk@... [firebird-support] wrote:

Interesting last message.

   Binaries are not allowed in this list. Use Ctrl-C to copy error message text and Ctrl-V 
to paste it into mail directly.
   If you use Windows command-line console, "select" and "copy" commands are in system menu.
   Code calling your SQL is useless for diagnostic UDF errors (unless this query is 
executed in isql w/o error). UDF code and its declaration are useful.

I did execute the statement in ISQL for testing (outside of my program) and got the error messages the image of which were deleted.


Error message when run from program in IDE
First chance exception at $7C812FD3 . Exception class EIBInterBaseError with message 'Unable to complete network request to host "ws1".
Error writing data to the connection.
An established connection was aborted by the software in your host machine.
'. Process IBConsole.exe ($A54)

Obviously something I cannot expect help with based on my emails.

Best regards

The statement do prepare

Statement: SELECT cast (RDB$RELATION_NAME as varchar(32)) AS TABLE_NAME, cast (RDB$INDEX_NAME as varchar(32)) AS
INDEX_NAME, RDB$STATISTICS from rdb$indices WHERE sNullIf( cast( rdb$system_flag as VARCHAR(32) ),  cast( 0 as VARCHAR
(32) ) ) = 0 order by RDB$STATISTICS
PLAN SORT ((RDB$INDICES NATURAL))