public inbox for [email protected]  

help / color / mirror / Atom feed
From: Erwin Brandenberger <[email protected]>
To: [email protected] <[email protected]>
Subject: ODBC SQLBindParameter for numeric
Date: Thu, 27 Sep 2018 09:34:46 +0000
Message-ID: <VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com> (raw)

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:[email protected]]
BST Banking Software Training AG
Chastelstrasse 2
CH-8732 Neuhaus
Phone  +41 55 225 10 20
Fax         +41 55 225 10 29
Mail       [email protected]<mailto:[email protected]>
Web      www.bst-ag.ch<http://www.bst-ag.ch/;
[cid:[email protected]]
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.



Attachments:

  [image/png] 4BB74BBDBEF14C67819861069ACC61C4[932699].png (6.4K, ../VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com/3-4BB74BBDBEF14C67819861069ACC61C4%5B932699%5D.png)
  download | view image

  [image/png] 28BE3F78862E4210B85665CCFEA5061D[932700].png (16.6K, ../VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com/4-28BE3F78862E4210B85665CCFEA5061D%5B932700%5D.png)
  download | view image

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: ODBC SQLBindParameter for numeric
  In-Reply-To: <VI1PR0101MB2429BB81ECCC0EDB245C98E6AD140@VI1PR0101MB2429.eurprd01.prod.exchangelabs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox