Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Simonov Denis via Firebird-devel
Alex Peshkoff via Firebird-devel писал(а) в своём письме Sun, 08 Dec 2019 18:59:12 +0300: On 2019-12-08 16:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely

Re: [Firebird-devel] Consistency of SET BIND grammar

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 17:10, Mark Rotteveel wrote: For consistency of the grammar, I think it is better if the NATIVE option is also prefixed with TO, So instead of SET BIND NATIVE, I think it should be SET BIND TO NATIVE. This would match with the form of SET BIND TO LEGACY, and grammatically, th

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 16:56, Mark Rotteveel wrote: On 08/12/2019 14:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 16:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But SET BIND OF DECFLOAT(16) TO CHAR; select

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 16:55, Mark Rotteveel wrote: On 08/12/2019 13:12, Alex Peshkoff via Firebird-devel wrote: On 2019-12-07 18:18, Simonov Denis via Firebird-devel wrote: I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type do

[Firebird-devel] Consistency of SET BIND grammar

2019-12-08 Thread Mark Rotteveel
For consistency of the grammar, I think it is better if the NATIVE option is also prefixed with TO, So instead of SET BIND NATIVE, I think it should be SET BIND TO NATIVE. This would match with the form of SET BIND TO LEGACY, and grammatically, this also makes more sense to me, because you

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Mark Rotteveel
On 08/12/2019 14:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But SET BIND OF DECFLOAT(16) TO CHAR; When yo

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Mark Rotteveel
On 08/12/2019 13:12, Alex Peshkoff via Firebird-devel wrote: On 2019-12-07 18:18, Simonov Denis via Firebird-devel wrote: I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type does not work. SET BIND OF DECFLOAT (34) TO

Re: [Firebird-devel] Documentation of DPB format of SET BIND

2019-12-08 Thread Mark Rotteveel
On 08/12/2019 14:28, Alex Peshkoff via Firebird-devel wrote: On 2019-12-08 15:47, Mark Rotteveel wrote: In the documentation of set bind[1], it says: """ Value of clumplet with isc_dpb_set_bind tag in DPB should be specified as a set of partially formed SET BIND statements, i.e. with prefix SE

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Simonov Denis via Firebird-devel
Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But SET BIND OF DECFLOAT(16) TO CHAR; select NORMALIZE_DECFLOAT(4300) as n1, QUANTIZE(2, 9.9) as n2,

Re: [Firebird-devel] Documentation of DPB format of SET BIND

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-08 15:47, Mark Rotteveel wrote: In the documentation of set bind[1], it says: """ Value of clumplet with isc_dpb_set_bind tag in DPB should be specified as a set of partially formed SET BIND statements, i.e. with prefix SET BIND OF is omitted, separated by semicolons. """ Accordin

[Firebird-devel] Documentation of DPB format of SET BIND

2019-12-08 Thread Mark Rotteveel
In the documentation of set bind[1], it says: """ Value of clumplet with isc_dpb_set_bind tag in DPB should be specified as a set of partially formed SET BIND statements, i.e. with prefix SET BIND OF is omitted, separated by semicolons. """ According to the code[2], using a comma is also poss

Re: [Firebird-devel] SET BIND OF

2019-12-08 Thread Alex Peshkoff via Firebird-devel
On 2019-12-07 18:18, Simonov Denis via Firebird-devel wrote: I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type does not work. SET BIND OF DECFLOAT (34) TO CHAR (46); - OK SET BIND OF DECFLOAT (34) NATIVE; Can not co