ODBC SQLBindParameter for numeric

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

ODBC SQLBindParameter for numeric

Erwin Brandenberger

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


BST Banking Software Training AG

Chastelstrasse 2
CH-8732 Neuhaus

Phone  +41 55 225 10 20
Fax         +41 55 225 10 29
[hidden email]
Web      www.bst-ag.ch 


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.