Import of data in schedule of a source

Hello,

I want to import data directly from a Access database into a schedule in a source. But I don't know how to do it. Is dbimportnode the correct command? And how can I add the typical schedule attributes as for example itemtype or quantity to the schedule table?
I'm able to import data from a database in a global table, but that doesn't help with a schedule.

thanks in advance for all answers,

Matthias

Hi Mattias,

I normally not use database connection, but I think you should do something like this:

treenode schedule = getvarnode(current,"schedule"); 
dbimportnode(schedule,startrow,startcol,numrows,numcols)

Put the code in the OnReset trigger in your Source or replace current with
your Source.

Lars-Olof

Hello Matthias,

I don't know how good you are with flexscript but actually the schedule of a source is nothing more than a table based on a variable node. Just as the global tables are base on a variable node.

if you create a pointer to that particular node:
treenode Schedule = getvarnode( current, "schedule");

you can use all the table commands, such as:
settablesize, settablenum etc..

So if you want to set for instance the quantity on the first line you can write:
int Quantity = 11;
settablenum (Schedule , 1, 4, Quantity );

Of course the name should be changed with "settablestr" ofcourse!

So now you could read in your db in a global table and then create the schedule based on that global table.

Hope this was of any assistance.

Steven

Thanks for your answers. They were very helpful.

I tried now both methods and the method with the table commands works. The only thing I want to mention is that you have to assign the correct data type to each cell/node before you write data in that cell. I used the command nodeadddata for that.

I didn't managed to get the data imported with dbimportnode, but I don't know why. Maybe I didn't tried hard enough.