[firebird-support] udf with paramters problem

2017-08-11 Thread keith prosser prosse...@yahoo.com [firebird-support]
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 cod

Re: [firebird-support] udf with paramters problem

2017-08-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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. +++

[firebird-support] FIRST 1 of each iItemID

2017-08-11 Thread venussof...@gmail.com [firebird-support]
Hi all I have a view and the following query which returns multiple records from the view (see below) for each iItemID SELECT iItemID , cID , dDt , bRate FROM vwPriceListHistory ORDER by iItemID, dDt DESC, cID DESC What I want is one first record of each iItemID