Re: [Firebird-docs] 2.5.4 ReleaseNotes P.73

2015-08-19 Thread Paul Vinkenoog
Hi all,

 Tsutomu is right. param1 is the parameter with a 'normal' SQL data type
 (i.e. not SQL_NULL). So if it is not NULL, XSQLVAR.sqldata should point
 to the value and XSQLVAR.sqlind should be set to 0 (indicating NOT NULL).

To be exact: XSQLVAR.sqlind should *point to* a 0 value.

Paul

--
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs


Re: [Firebird-docs] 2.5.4 ReleaseNotes P.73

2015-08-19 Thread Mark Rotteveel
On Wed, 19 Aug 2015 09:23:20 +0900, Tsutomu Hayashi tomnek...@gmail.com
wrote:
 Hi All
 
 Now I am translating version2.5.4 ReleaseNotes to Japanese.
 
 I think this is mistake, isn't it? Abount SOME_COL = ? OR ? IS NULL
 Predication
 
 
 ---
 • If “param1” is not NULL, the language interface is required to
 assign the correct value for the first parameter, set the
 XSQLVAR.sqlind to NOT NULL and leave XSQLVAR.sqldata NULL.
 ---
 
 fix this
 
 ---
 • If “param1” is not NULL, the language interface is required to
 assign the correct value for the first parameter, set the
 XSQLVAR.sqlind to NOT NULL.
 ---

As far as I can tell the existing text is intentional and correct. It
tries to convey that the value of XSQLVAR.sqldata is irrelevant for
parameters in ? IS NULL (and therefor is best left NULL).

Mark

--
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs


[Firebird-docs] 2.5.4 ReleaseNotes P.73

2015-08-18 Thread Tsutomu Hayashi
Hi All

Now I am translating version2.5.4 ReleaseNotes to Japanese.

I think this is mistake, isn't it? Abount SOME_COL = ? OR ? IS NULL
Predication


---
• If “param1” is not NULL, the language interface is required to
assign the correct value for the first parameter, set the
XSQLVAR.sqlind to NOT NULL and leave XSQLVAR.sqldata NULL.
---

fix this

---
• If “param1” is not NULL, the language interface is required to
assign the correct value for the first parameter, set the
XSQLVAR.sqlind to NOT NULL.
---

Best Regards,

+++

From Hayashi tomneko tsutomu
Mail: tomnek...@gmail.com
Web: http://www.tomnekosoft.com

+++

--
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs