On 10/03/2015 06:19, liviuslivius wrote:
>
> one more change is needed 
>
> OutMessage = record
>               relationId: SmallInt;
>               relationIdNull: SmallInt;
>               relationName: Array[0..93] of AnsiChar; <== here is the change
>               relationNameNull: SmallInt;
>       end;
>
>
Changed, thanks. Also changed SmallInt of "null indicators" from
SmallInt to WordBool.

Karol, I also created an UDR demo for a selectable stored procedure.

https://github.com/asfernandes/fbstuff/commit/161e1bb98f6321cff87afe24ca1050a23b8a2e10

You should build it and copy the pascaludr.dll file to <fbroot>/plugins/udr

Then declare in the database:

create procedure gen_rows_pascal (
    start_n integer not null,
    end_n integer not null
) returns (
    result integer not null
)
    external name 'pascaludr!gen_rows'
    engine udr;

And use:

select * from gen_rows_pascal(2, 5);

Result:

2
3
4
5


Adriano


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to