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.
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? |