Re: [soci-users] Bulk inserting into decimal fields on SQL Server via ODBC Backend

2014-01-28 Thread Andrew Grafham
On 27 January 2014 17:18, Vadim Zeitlin wrote: > On Mon, 27 Jan 2014 17:13:29 + Andrew Grafham < > andrew.graf...@gmail.com> wrote: > > AG> Is there a way of accurately bulk inserting into a decimal field in SQL > AG> server? > > Sorry for the bad news but no, there is no support for inserti

Re: [soci-users] Bulk inserting into decimal fields on SQL Server via ODBC Backend

2014-01-27 Thread Vadim Zeitlin
On Mon, 27 Jan 2014 17:13:29 + Andrew Grafham wrote: AG> Is there a way of accurately bulk inserting into a decimal field in SQL AG> server? Sorry for the bad news but no, there is no support for inserting string values in SQL_DECIMAL columns in the current ODBC backend code. Worse, I'm

[soci-users] Bulk inserting into decimal fields on SQL Server via ODBC Backend

2014-01-27 Thread Andrew Grafham
Hi, Is there a way of accurately bulk inserting into a decimal field in SQL server? I'm trying to insert into a table called nets, which has 2 column, an integer column (id) and a decimal(23,6) column (net). This is the code I'm using:- try { session sql("odbc", "DSN=socitest;Uid=sa;