dumpquery into databundle

Hello,

I am playing around with the SQL functionality in FlexSim 7.1. I have a table that I use to select some data from with the query command and then use the dumpquery (node dumpNode[, num asTable]) command to store the collected data in another node. When I use the dumpquery command with asTable = 1, the data I have selected is stored nicely in the dumpNode , but when I set asTable to 0, only the headers of my original table are stored in the dumpNode as fieldnames, but no bundleentries are added. Has anyone else encountered this problem or know how to solve it?

Esther

Hello Esther,

I've tried this command with bundles and it works perfectly. Maybe your last result of query was empty?!

I've attached a short example for our community

Hello Carsten,

Thanks for your reply. I tried it with a simle table with all fields filled with data and it worked indeed for me as well. The table I was originally using has columns with mixed data (string and num) and empty cells, so the problem may lay there.

Esther