[firebird-support] Question on UDF's

Hi: Any insight appreciated. Installed FB 2.5 on win 10. Using IB_SQL.exe for access. GDB is from an old IB 6.02 which works flawlessly on XP I have several of my UDF libs in udf dir When I open w IB_SQL. exe and look at UDF's all I get showing are 6 from ib_sql and shows error "Unexpected

[firebird-support] ibmgr32.hlp

Hi: Anyone know where to get a copy of ibmgr32.hlp Thanks

[firebird-support] Why am I getting this message

wisql32.exe execute query FB 2.5 uninstalled long ago. SHOW VERSION can't format message 17:10 -- message file C:\WINNT\firebird.msg not found Registry cleaned.

Re: [firebird-support] Why am I getting this message

Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 2018-11-16 02:28, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > wisql32.exe execute query > > FB 2.5 uninstalled long ago. > > SHOW VERSION > can't format message 17:10 -- message file C:\WINNT\firebi

Re: [firebird-support] udf dll

On 12/12/2018 11:00 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 16:45, Robert Tulloch tult...@hughes.net [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

Re: [firebird-support] udf dll

On 12/12/2018 12:05 PM, Robert Tulloch wrote: On 12/12/2018 11:00 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 16:45, Robert tullochtult...@hughes.net [firebird-support] wrote: Interesting last message. Binaries are not allowed in this list. Use Ctrl-C

[firebird-support] udf dll

Hi   My udf is not working. Very strange error message. Exciting challenges I execute any old SQL statement and Ok. Run this and not ok. 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

Re: [firebird-support] udf dll

On 12/12/2018 12:17 PM, Robert Tulloch tult...@hughes.net [firebird-support] wrote: On 12/12/2018 12:05 PM, Robert Tulloch wrote: On 12/12/2018 11:00 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 16:45, Robert tullochtult...@hughes.net [firebird-support

Re: [firebird-support] udf dll

On 12/12/2018 12:34 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 18:05, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Error message when run from program in IDE First chance exception at $7C812FD3 . Exception class EIBInterBaseError with message

Re: [firebird-support] udf dll

On 12/12/2018 2:04 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 19:26, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Not using firebird at all. In this case you are in wrong support list. Hi:   Never mind the dll/udf Statement: SELECT

Re: [firebird-support] udf dll

On 12/12/2018 2:04 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.12.2018 19:26, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Not using firebird at all. In this case you are in wrong support list. There is no other support list

[firebird-support] Question on IB components

Hi:   Trying to get old app using IB components to connect to FB 2.5. Should these components work with FB 2.5? Have all source etc. Thanks Best regards

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

:29, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > IB 6 > > Interesting: > > If I run > > 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 0 = 0 AN

[firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

IB 6 Interesting: If I run 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 0 = 0 AND RDB$SYSTEM_FLAG = 1 order by RDB$STATISTICS DESC The result set is all the system tables. Running

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 2/28/2019 12:54 AM, hele...@iinet.net.au [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 2/27/2019 2:44 PM, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Hi:   I just ran this select 'MEMPAY1' AS TABLE_NAME,

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

AM, Robert Tulloch tult...@hughes.net [firebird-support] wrote: On 2/28/2019 12:54 AM, hele...@iinet.net.au [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 2/27/2019 2:44 PM, Robert Tulloch tult...@hughes.net <mailto:tult...@hughes.net> [firebird-s

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

Thanks. I am familiar with using parameterized queries (Perl). All the same. Best regards On 2/28/2019 2:38 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 28-2-2019 18:06, Robert Tulloch tult...@hughes.net [firebird-support] wrote: > Fi

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 2/27/2019 1:27 PM, hele...@iinet.net.au [firebird-support] wrote: Robert Tulloch wrote, >[Mark Rotteveel] >  No, the flag is null, not 0, otherwise = 0 had worked, and is null > had not. You appear to be using a query tool that renders null as 0. Such as the GUI tool that was distributed

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

On 2/27/2019 2:44 PM, Robert Tulloch tult...@hughes.net [firebird-support] wrote: Hi:   I just ran this select 'MEMPAY1' AS TABLE_NAME, 'M1ID' AS INDEX_NAME, cast(RDB$STATISTICS as varchar(32)) as RDB$STATISTICS from rdb$indices where RDB$SYSTEM_FLAG is null or RDB$SYSTEM_FLAG = 0 order

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

No, the flag is null, not 0, otherwise = 0 had worked, and is null had not. You appear to be using a query tool that renders null as 0. Can I send you a screenshot of the flags in RDB$RELATIONS?

Re: [firebird-support] Re: Question: RDB$SYSTEM_FLAG = 0 No Results

On 2/27/2019 6:38 PM, hele...@iinet.net.au [firebird-support] wrote: select RDB$RELATION_NAME, RDB$INDEX_NAME, RDB$SYSTEM_FLAG from rdb$indices; Thanks for clarification. Using above, mine are all NULL.

Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results

I don't have InterBase 6, but I tried on Firebird 1.5, and I have to use `RDB$SYSTEM_FLAG IS NULL` for your query to return non-system indexes, and that is because the flag is 1 for system, and null for non-system on that version, and as far as I know that was inherited from InterBase 6. Hi: