I have a UDF that needs to takes a couple of CSTRING(255) arguments and returns
CSTRING(8000), but it needs to be able to handle accented characters like in
French..
The UDF is written in C and compiled in MS Visual Studio, using the normal
"char" character type. I tried changing that to
Stackoverflow.com ;-)
but do you think that it's time to upgrade?
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "Robert Tulloch tult...@hughes.net
[firebird-support]" Data: 12.12.2018 21:34
(GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re: [firebi
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
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
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.
--
WBR, SD.
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
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]
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
> 'Unable to complete network request to host "ws1".
> Error writing data to the
I suppose you do some wrong things like:
1. Wrong calling convention – should by „cdecl” not „stdcall”
2. You allocate strings locally and return it to the engine but you should
allocate it by „ib_util_malloc”.
3. Your declaration of udf is wrong.
4. You raise some exceptions inside your udf
…..
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
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
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 it into mail directly.
If you use Windows command-line console, "select" and "copy"
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
Hello:
I am hoping someone can help me out with this.
We recently set up a VPS for use for a remote Firebird database to use
in our desktop application for user authorization. The VPS is a Windows
Server 2008. Initially, I loaded FB 3.0.3, both 64bit and 32 bit
versions. The 32 bit for access
23.04.2018 16:18, tvd...@ymail.com [firebird-support] wrote:
> It seems to be that call to blob_put_segment that becomes slow. At first
> usage of the UDF
> it's almost instant, and after that it takes 15ms for every invocation.
>
> What causes this and can I avoid it?
Data, returned from
Hi all,
I'm using Firebird 2.5.8 and wrote a UDF that "returns" a large (~60MB) BLOB
via an output parameter that's a pointer to a blobcallback by repeatedly
calling blob_put_segment. The instructions for doing so I took from:
https://www.ibphoenix.com/files/Writing-External-Functions.pdf
Hello!
How can i use ib_util in my UDF written is C language if ib_util is written in
C++? (i need ib_util_malloc from there)Is there also a C version available?Or
do i have to write my UDF in C++? (i'm not good in that language)
Thank you!
24.08.2017 15:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> is there any problems if I just declare all UDF's with FREE IT?
Yes, server will have problems trying to free memory that wasn't allocated.
--
WBR, SD.
>You must use ib_util_malloc() to allocate memory in UDF and don't forget
>FREE_IT in declaration to avoid memory leak.
Dimitry, on a similar question, is there any problems if I just declare all
UDF's with FREE IT?
We use dozens of UDF's, but only half of them are declared as FREE IT, and I
24.08.2017 12:00, Nagy Szilveszter nagy_szilvesz...@yahoo.com
[firebird-support] wrote:
> out = (char*)calloc(strlen(str), sizeof(char));
> result = (char*)calloc(j, sizeof(char));
Besides, here and there you forgot about space for terminating null char.
--
WBR, SD.
quot;
<firebird-support@yahoogroups.com>
Para: Firebird-support <firebird-support@yahoogroups.com>
Enviadas: Quinta-feira, 24 de Agosto de 2017 6:41
Assunto: [firebird-support] UDF or/and maybe Charset problem
Hi,
i have an UDF function that runs perfectly on Linux 64 bi
there no a null string?
De: "Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]"
<firebird-support@yahoogroups.com>
Para: Firebird-support <firebird-support@yahoogroups.com>
Enviadas: Quinta-feira, 24 de Agosto de 2017 6:41
Assunto: [firebird-sup
24.08.2017 11:37, Nagy Szilveszter nagy_szilvesz...@yahoo.com
[firebird-support] wrote:
> result = (char*)calloc(j, sizeof(char));
You must use ib_util_malloc() to allocate memory in UDF and don't forget
FREE_IT in
declaration to avoid memory leak.
--
WBR, SD.
Hi,
i have an UDF function that runs perfectly on Linux 64 bit systems. I wanted to
port it to Windows 32 bit, but i'm having problems there.
The UDF was written in C (not C++), compiled on Linux with gcc, everything
works fine.
I compiled the same C file on Windows with MinGW Developer Studio
I’m having a weird error, sometimes the system crashes due to an UDF being not
declared properly :
“invalid request BLR at offset 877 function F_GFORMATD is not defined module
name or entrypoint could not be found”
But I can verify it is declared properly.
The same query runs without
11.08.2017 11:09, keith prosser prosse...@yahoo.com [firebird-support] wrote:
> I'm fairy sure its to with pointers and data.
No, it is about calling conventions. UDFs use cdecl, not stdcall.
--
WBR, SD.
Has anyone had probems with udfs written in Delphi7? I'm getting serious
crashes when I try to pass parameters - but a udf returning an integer with
input parameters works fine.
I am running 32-bit Firebird on a 64bit win 7 machine.I'm fairy sure its to
with pointers and data.
The source
Tested on FB 2.5.7 and 3.02 ubuntu_x64 14.04 (two different machines);
On windows fbx64 works ok.
udf return integer by value.
scenario:
more than 2 connections to db
sql : select count(*) from table where validfield(field) = 1 on each connection
table with > 2 milions record
udf written in
So, if I've got a UDF which is declared as
DECLARE EXTERNAL FUNCTION xxx
INTEGER, INTEGER, INTEGER, INTEGER, INTEGER, INTEGER, INTEGER,
INTEGER, INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'xxx'
MODULE_NAME 'xxx_udf';
these INTEGERs are all 32 bits, right, both on 32 bit
I have a FB 2.5.5 database which I have migrated to FB3 RC2. I use the older
FreeUDFLib.dll. All the procedures of this DLL are in the database reported by
Database Workbench 5. The restore log for the migration shows no errors. This
DLL is in the FB 3 UDF folder. When running a stored
Hello firebird-support@yahoogroups.com!
I am migrating my UDF from windows to linux, but all functions using
string as output when they are used crashes the server.
I suppose it must be related to libib_util.so and its function
ib_util_malloc.
My declaration is the following:
{$IFDEF
-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] *On Behalf Of *liviuslivius
*Sent:* Friday, January 31, 2014 10:22 AM
*To:* firebir d-supp...@yahoogroups.com
*Subject:* [firebird-support] Udf returning VARCHAR
Hi,
i try to find any example of writing
Hello, liviuslivius!
Friday, January 31, 2014, 12:21:37 PM, you wrote:
l i try to find any example of writing and declaring udf function
l returning varchar instead of Char
l without success.
l Is this possible?
yes, but correct way is to use CSTRING.
It can be simply used inside udf, and that
Hi,
i try to find any example of writing and declaring udf function returning
varchar instead of Char
without success.
Is this possible?
regards,
Karol Bieniaszewski
Why don`t you use CAST ( var as VARCHAR(NN)) ?
Bogdan MIHALACHE
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of liviuslivius
Sent: Friday, January 31, 2014 10:22 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Udf
( var as VARCHAR(NN)) ?
Bogdan MIHALACHE
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of liviuslivius
Sent: Friday, January 31, 2014 10:22 AM
To: firebir d-supp...@yahoogroups.com
Subject: [firebird-support] Udf returning VARCHAR
Hi,
i try
: [firebird-support] UDF and Delphi XE3 Blues
Hello.
I am unable to resolve the issue with UDF.
Does anyone have any other suggestions?
Thanks in advance.
2013/10/3 firebirddev firebirddev firebird...@gmail.com
Thanks Sean.
The UDF/DLL is in located in the path described
:* firebird-support@yahoogroups.com [mailto:
firebird-support@yahoogroups.com] *On Behalf Of *firebirddev firebirddev
*Sent:* Wednesday, October 02, 2013 3:13 PM
*To:* firebird-support@yahoogroups.com
*Subject:* [firebird-support] UDF and Delphi XE3 Blues
** **
Hello
Hello.
If this is not the right group, kindly direct me to the right group.
I have created a UDF and I am getting stuck at the following error:
Preparing query: select F_MODULO(3, 2) from rdb$database
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( select F_MODULO(3, 2) from
:13 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] UDF and Delphi XE3 Blues
Hello.
If this is not the right group, kindly direct me to the right group.
I have created a UDF and I am getting stuck at the following error:
Preparing query: select F_MODULO(3, 2) from rdb
://www.elektlabs.cz http://www.elektlabs.cz/
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Sergio H. Gonzalez
Sent: Tuesday, December 04, 2012 3:56 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] UDF 64 bits
On 5-12-2012 10:30, Piotr Olszewski wrote:
Hi again...
One question about UDF on 64-bits Firebird server, do I need to recompile
dll's with 64 - bits RAD?? or can I use compiled with 32 bits Delphi 2007
AFAIU 2007 won't work because it does not have a 64 bit compiler.
You could
One question about UDF on 64-bits Firebird server, do I need to recompile
dll's with 64 - bits RAD?? or can I use compiled with 32 bits Delphi 2007
You have to recompile with 64Bit compiler - either Delphi or FreePascal.
Elmar
: Wednesday, December 05, 2012 10:30 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] UDF 64 bits
Hi again...
One question about UDF on 64-bits Firebird server, do I need to recompile
dll's with 64 - bits RAD?? or can I use compiled with 32 bits Delphi 2007
Piotr
Dnia 2012
Hello... I think I've posted this question before, but now can't find
the thread... Anyway I still have the problem...
An UDF that worked fine in FB 32 bits, in 64 bits doesn't work
This is the DDL:
DECLARE EXTERNAL FUNCTION SG_DES
DOUBLE PRECISION,
CSTRING(50)
RETURNS DOUBLE
Hello
Maybe the problem is that we have to re-compile our dll's as 64
bits.
Piotr
Dnia 2012-12-04 15:56 Sergio H. Gonzalez napisał(a):
Hello... I think I've posted this question before, but now can't find
the thread... Anyway I still have the problem...
An UDF that worked fine
To: firebird-support@yahoogroups.com
Subject: [firebird-support] UDF 64 bits
Hello... I think I've posted this question before, but now can't find
the thread... Anyway I still have the problem...
An UDF that worked fine in FB 32 bits, in 64 bits doesn't work
This is the DDL:
DECLARE
Hi!
What could possibly be wrong with the following UDF?
* Function *
type
TBlob = {packed} record
GetSegment: TISC_BlobGetSegment;
BlobHandle: PInt;
SegmentCount: LongInt;
MaxSegmentLength: LongInt;
TotalSize: LongInt;
PutSegment: TISC_BlobPutSegment;
end;
Nice - this will also fail with the same error:
function BLOBLEN(Value: PBlob): Integer; cdecl;
begin
Result := 1;
end;
I admit I find this very mystifying.
Josef
Hi!
What could possibly be wrong with the following UDF?
* Function *
type
TBlob = {packed} record
On 31.7.2012 14:12, Josef Kokeš wrote:
Nice - this will also fail with the same error:
function BLOBLEN(Value: PBlob): Integer; cdecl;
begin
Result := 1;
end;
I admit I find this very mystifying.
Never mind, found it - the problem was not in the function, but in the
SQL declaration -
Hi,
I might be way off here - but exposed / exposed functions need to be called
with the correct calling convention.
Double check if it should be cdelc vs stdcall
Also check that you declare your EXTERNAL declaration with the same calling
convention (in your case: specify cdelc in your external
Hi!
When I run my UDF (udf_op), I get an error : Bad written UDF detected: pointer
returned in FREE_IT function was not allocated by ib_util_malloc
I use ib_util_malloc in my Win version, no problem there. What should I use in
Linux version? Currently memory allocated with malloc.
SQL:
On 2012-04-17 08:01, ma_golyo wrote:
I use ib_util_malloc in my Win version, no problem there. What should I use
in Linux version? Currently memory allocated with malloc.
Include ib_util.h in your UDF's source (it's located by default in
/opt/firebird/include) or explicitly declare void*
On 16-3-2012 17:13, Kevin Stanton wrote:
Greetings,
I believe I'm down to just 3 UDFs and was wondering if there are any
replacements for:
F_ADDMONTH
F_ADDYEAR
F_AGEINMONTHS
Also, is there a place where I can get a list of all functions for FB
1.56 (and beyond)? I've taken a quick
On 16-3-2012 17:13, Kevin Stanton wrote:
Greetings,
I believe I'm down to just 3 UDFs and was wondering if there are any
replacements for:
F_ADDMONTH
F_ADDYEAR
F_AGEINMONTHS
Also, is there a place where I can get a list of all functions for FB 1.56
(and beyond)? I've taken a quick
One last thing: I'm using FB 1.56.
Thank you,
Kevin
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton
Sent: Friday, March 16, 2012 6:53 AM
To: Firebird Support
Subject: [firebird-support] UDF Question(s)
Greetings,
I'm
Extract(Day from MyDate)
Extract(Month from MyDate)
Extract(Year from MyDate)
DateDiff(Day from FirstDate to SecondDate) (you can substitute Month, Week,
Hour, Minute, Second, and MilleSecond as well.
These are all in FB V2.1
I'm trying to eliminate the need for the FreeUDFLib so I
Oh, FB 1.56 - well good luck then - Jerry
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton
Sent: Friday, March 16, 2012 9:00 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] UDF Question(s)
One last
Thanks for the info Jerry!
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Jerry Sands
Sent: Friday, March 16, 2012 7:02 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] UDF Question(s)
Oh, FB 1.56 - well good luck
: [firebird-support] UDF Question(s)
Greetings,
I'm trying to eliminate the need for the FreeUDFLib so I can have the
option of running Firebird 32-bit or 64-bit.
I believe I'm down to 4 UDFs - are there any replacement for the following:
F_DAY (extracts the day from a passed date)
F_MONTH (extracts
Of Svein Erling Tysvær
Sent: Friday, March 16, 2012 7:05 AM
To: 'firebird-support@yahoogroups.com'
Subject: RE: [firebird-support] UDF Question(s)
Greetings,
I'm trying to eliminate the need for the FreeUDFLib so I can have the
option of running Firebird 32-bit or 64-bit.
I believe I'm down to 4
Try This :
On Fri, Mar 16, 2012 at 8:52 PM, Kevin Stanton
kevin.stan...@rdb-solutions.com wrote:
**
Greetings,
I'm trying to eliminate the need for the FreeUDFLib so I can have the
option
of running Firebird 32-bit or 64-bit.
I believe I'm down to 4 UDFs - are there any replacement
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-
supp...@yahoogroups.com] On Behalf Of Iwan Cahyadi Sugeng
Sent: Friday, March 16, 2012 7:11 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] UDF Question(s)
Try This :
On Fri
Hello, this is related to my previous post... I'm trying to write a UDF
in Delphi... It's declared like this:
function Descuentos(var Suma:currency;Descuentos:pchar):double; cdecl;
export;
DECLARE EXTERNAL FUNCTION SG_DES
DOUBLE PRECISION,
CSTRING(50)
RETURNS DOUBLE PRECISION BY VALUE
65 matches
Mail list logo