Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Dimitry Sibiryakov
26.06.2015 15:33, Brian Vraamark wrote: > I guess that count(*) before FB3 was 4 bytes (SQL_LONG) but in FB3 it is 8 > bytes (SQL_INT64). You guess right. -- WBR, SD. -- Monitor 25 network devices or servers for

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Brian Vraamark
Hi again, Sorry. I was thinking on sqln (which I'm setting to 1). It works after setting sqllen to sizeof(ISC_LONG). I have been using this code with FB 1.5 and 2.0 for almost 10 years without problems and without setting sqllen. I guess that count(*) before FB3 was 4 bytes (SQL_LONG) but in FB

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Dimitry Sibiryakov
26.06.2015 14:19, Brian Vraamark wrote: >> I see that you don't set sqllen. > I do. This is the complete code regarding XSQLDA: So, you still proclaiming that data buffer is 8 bytes long. There is nothing to wonder at that Firebird client clean 8 bytes before storing value. > I have to c

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Brian Vraamark
Copy/paste didn't work correctly. I have corrected the code: Brian Vraamark -Oprindelig meddelelse- Fra: Brian Vraamark [mailto:[email protected]] Sendt: 26. juni 2015 14:20 Til: For discussion among Firebird Developers Emne: Re: [Firebird-devel] SQL_LONG is filled with 8 bytes

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Brian Vraamark
I do. This is the complete code regarding XSQLDA: paramBuffer = new char[XSQLDA_LENGTH(1)]; if (paramBuffer==NULL) { internalError = BERR_OUT_OF_MEMORY; return 0; }; tmpXSQLDA = (XSQLDA *) paramBuffer; tmpXSQLDA->version = SQLDA_VERSION1; tmpXSQLDA->sqln = 1; tmpXSQLDA->sqld = 1; tmpXSQLD

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Dimitry Sibiryakov
26.06.2015 14:06, Brian Vraamark wrote: > Only difference is putting it after prepare always results in 0 in the second > element: I see that you don't set sqllen. -- WBR, SD. -- Monitor 25 network devices or ser

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Brian Vraamark
Hi, I have tried both. It's the same result. Only difference is putting it after prepare always results in 0 in the second element: 0x0003 0x 0x 0x I have not recompiled our code, so it is using the old FB2 ibase.h, but from what I can see XSQLDA hasn't changed. B

Re: [Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Dimitry Sibiryakov
26.06.2015 13:31, Brian Vraamark wrote: > I use the following code Did you that before calling isc_dsql_prepare() or after? -- WBR, SD. -- Monitor 25 network devices or servers for free with OpManager! OpManager i

[Firebird-devel] SQL_LONG is filled with 8 bytes.

2015-06-26 Thread Brian Vraamark
Hi, I get stack corruption in firebird 3 Beta 1 32Bit. Using XSQLDA allocated with XSQLDA_LENGTH(1) I use the following code: unsigned long returnedID; tmpXSQLDA->sqlvar[0].sqltype = SQL_LONG; tmpXSQLDA->sqlvar[0].sqldata = (char *)&returnedID; The select is "select count(*) from MyTable".

Re: [Firebird-devel] employee db build broken

2015-06-26 Thread Alex Peshkoff
On 06/26/2015 01:32 PM, Alex Peshkoff wrote: > On 06/25/2015 06:46 PM, Adriano dos Santos Fernandes wrote: >> On 25/06/2015 08:29, Alex Peshkoff wrote: >>> On 06/24/2015 07:59 PM, Adriano dos Santos Fernandes wrote: >>> >>> Crashs with clang ang gcc. >>> I.e. it's not compiler issue. That's go

Re: [Firebird-devel] employee db build broken

2015-06-26 Thread Alex Peshkoff
On 06/25/2015 06:46 PM, Adriano dos Santos Fernandes wrote: > On 25/06/2015 08:29, Alex Peshkoff wrote: >> On 06/24/2015 07:59 PM, Adriano dos Santos Fernandes wrote: >> >> >>> Crashs with clang ang gcc. >> I.e. it's not compiler issue. That's good. >> >>> A sleep before the "system" call does not

[Firebird-devel] ADO.NET provider 4.6.4.0

2015-06-26 Thread Jiří Činčura
More info http://blog.cincura.net/233511-ado-net-provider-4-6-4-0-for-firebird-is-ready/ . -- Mgr. Jiří Činčura Independent IT Specialist -- Monitor 25 network devices or servers for free with OpManager! OpManager is we