nodes - NodeJS ODBC library not returning affectedinserted rows as result

I am resorting to asking the minds of StackOverflow to help me identify what it is I'm doing wrong. I have written a NodeJS app that connects to a Microsoft Fabric database. I am using an ODBC connection via the npm ODBC library. I cannot, for the life of me, seem to get the number of rows inserted after an insert statement runs. The connection is fine and the row gets inserted but the results are always empty. Here is the sample code directly from the ODBC npm page:

const odbc = require('odbc');

async function commitTransaction() {
    const connection = await odbc.connect(`${process.env.CONNECTION_STRING}`);
    await connection.beginTransaction();
    const insertResult = await connection.query('INSERT INTO MY_TABLE VALUES(1, \'Name\')');
    await connectionmit();
    // INSERT query has now been committed
}

commitTransaction();

My expectation would be the insertResult variable contains a relevant response which includes the number of rows inserted. The relevant part of the connection string is that I'm using this driver: ODBC Driver 18 for SQL Server as Microsoft Fabric documentation states the ODBC Driver must be version 18 or higher.

Any help in identifying what it is I am doing wrong would be greatly appreciated! Thank you!

const odbc = require('odbc');

async function commitTransaction() {
    const connection = await odbc.connect(`${process.env.CONNECTION_STRING}`);
    await connection.beginTransaction();
    const insertResult = await connection.query('INSERT INTO MY_TABLE VALUES(1, \'Name\')');
    await connectionmit();
    // INSERT query has now been committed
}

commitTransaction();

Any help in identifying what it is I am doing wrong would be greatly appreciated! Thank you!

Share Improve this question asked Feb 17 at 18:04 Matt Crysler 8853 gold badges11 silver badges23 bronze badges

Add a comment |

1 Answer 1

Sorted by: Reset to default 0

I am an idiot. The log statement was converting the result to a string which truncates the metadata that comes with it and only returns the array of results, of which there are none. I am able to access the result directly via

...
const insertResult = await connection.query('INSERT INTO MY_TABLE VALUES(1, \'Name\')');
console.log(insertResult.count);
...

Apologies for the misunderstanding but sometimes talking out the problem with a text editor is helpful :)

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

nodes - NodeJS ODBC library not returning affectedinserted rows as result - Stack Overflow

1 Answer 1

与本文相关的文章

评论列表(0)