ODBC SQLBindParameter for numeric

From: Erwin Brandenberger <erwin(dot)brandenberger(at)bst-ag(dot)ch>
To: "pgsql-interfaces(at)lists(dot)postgresql(dot)org" <pgsql-interfaces(at)lists(dot)postgresql(dot)org>
Subject: ODBC SQLBindParameter for numeric
Date: 2018-09-27 09:34:46
Message-ID: VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

How should be the content of SQL_NUMERIC_STRUCT when writing to DB ?

I used the same as reading, but it will not work.

Sample: 0.200000 [for decimal(9, 6) as dbcolumn]

{precision=6 '\x6' scale=6 '\x6' sign=1 '\x1' ...}
6 '\x6'
6 '\x6'
1 '\x1'
0x000000cfae63cbfb "@\r\x3"
64 '@'
13 '\r'
3 '\x3'
0 '\0'
...

ret = SQLBindParameter(hstmt, idx, param, SQL_C_NUMERIC, SQL_NUMERIC, numeric.GetPrecision(), numeric.GetScale(), numeric.GetAsNumericStruct(), 0, data->GetResultLength64());

What is wrong with this call ?

Reading works, writing not !
Erwin Brandenberger
Head of Engineering
[cid:image001(dot)png(at)01D418EC(dot)81160740]
BST Banking Software Training AG
Chastelstrasse 2
CH-8732 Neuhaus
Phone +41 55 225 10 20
Fax +41 55 225 10 29
Mail erwin(dot)brandenberger(at)bst-ag(dot)ch<mailto:erwin(dot)brandenberger(at)bst-ag(dot)ch>
Web www.bst-ag.ch<http://www.bst-ag.ch/>
[cid:image002(dot)png(at)01D418EC(dot)81160740]
Please consider the environment before printing this email
BST Banking Software Training AG (BST) Email Disclaimer:
This e-mail is for the intended recipient only and may contain confidential or privileged information. If you have received this e-mail by mistake, please contact us immediately and completely delete it (and any attachments) and do not forward it or inform any other person of its contents. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, amended, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Neither BST nor the sender accept liability for any errors or omissions in the content of this message which arise as a result of its e-mail transmission. Please note that all e-mail communications to and from BST may be monitored.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dimitrova, Ekaterina Buryanova 2018-12-04 23:45:22 ECPG ---> preproc.y
Previous Message Sam Liapis 2018-08-01 07:10:51 Does ecpg understand forward declarations?