Javascript - help getting variable out of function [solved]

[kaotkbliss]

I'm using this node module, dbffile to try and get a count of records in a database.

I want to modify their existing example:

DBFFile.open('[full path to .dbf file]')

    .then(dbf => {

        console.log(`DBF file contains ${dbf.recordCount} rows.`);

        console.log(`Field names: ${dbf.fields.map(f => f.name)}`);

        return dbf.readRecords(100);

    })

    .then(rows => rows.forEach(row => console.log(row)))

    .catch(err => console.log('An error occurred: ' + err));

 

to just simply return the dbf.recordCount to be used later in the script.

 

if I do:

DBFFile.open(dbfFilePath + '/' + csvData.DATANAME)
   .then(dbf => {
        qty = dbf.recordCount;
    })
   .catch(err => console.log('An error occurred: ' + err));

 

I simply get "undefined" later in my script.

 

If I try:

qty = DBFFile.open(dbfFilePath + '/' + csvData.DATANAME)
    .then(dbf => {
       return dbf.recordCount;
   })
   .catch(err => console.log('An error occurred: ' + err));

 

Then I get Promise {pending}

Edited September 29, 2018 by kaotkbliss
Marking as solved as I didn't end up needing this code

[kaotkbliss]

I ended up going a different route. To actually do what I need to do later with the records I'm using a different dbf module and while it's helpfile didn't say anything about it, I found where it does in fact log the number of records in it's processing so I was able to use that.