Will Table.query() return 0 if select count(*) query does not find any row?

Question

question

Rahul R asked Apr 26, '22 Logan Gold edited Apr 27, '22

Will Table.query() return 0 if select count(*) query does not find any row?

Will Table.query() return 0 if the SQL query looking for count of rows for a specific condition does not find any?

Right now I get a exception - time: 0.000000 exception: FlexScript exception: Invalid row number: 1 in Table.query() result table. at MODEL:/Tools/ProcessFlow/ProcessFlow/Custom Code: Update Inventory_Details table>variables/codeNode

Software Version:

FlexSim 22.1.0

global table

1651001268754.png (114.0 KiB)

Answer 1 · 2022-04-26T21:22:12Z

Logan Gold answered Apr 26, '22 Logan Gold edited Apr 27, '22

I believe if the COUNT() returns a 0, the result table will still have no rows. So for your example, you would want to do something like this:

int ASIN_Index = 0;
Table result = Table.query("SELECT COUNT(*) FROM Inventory_Details WHERE ASIN = 'DFG567'");
if (result.numRows > 0) {
     ASIN_Index = result[1][1];
}
print ("ASIN_Index: ", ASIN_Index);

· 1

Rahul R commented · Apr 26, 2022 at 09:25 PM

Thank you

0 ·

question