ODBC SQLBindParameter for numeric - Mailing list 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

BST Banking Software Training AG

Chastelstrasse 2
CH-8732 Neuhaus

Phone  +41 55 225 10 20
Fax         +41 55 225 10 29
Mail       erwin.brandenberger@bst-ag.ch
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.