ODBC SQLBindParameter for numeric

Поиск
Список
Период
Сортировка
От Erwin Brandenberger
Тема ODBC SQLBindParameter for numeric
Дата
Msg-id VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com
обсуждение исходный текст
Список 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.png@01D418EC.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.brandenberger@bst-ag.ch
Web      www.bst-ag.ch 

cid:image002.png@01D418EC.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.

 

Вложения

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Sam Liapis"
Дата:
Сообщение: Does ecpg understand forward declarations?
Следующее
От: "Dimitrova, Ekaterina Buryanova"
Дата:
Сообщение: ECPG ---> preproc.y