Is the following code correct? I'm trying to pull a query result and dump it into a table called TEST:
Table RESULT = Table.query("SELECT * FROM [MANUF SCHEDULE], [ITEM MASTER] \ WHERE [MANUF SCHEDULE.NODE ID] = 101 AND [MANUF SCHEDULE.DATE] = 11 AND \ [MANUF SCHEDULE.SKU] = 121523"); RESULT.cloneTo(Table("TEST"));
If I wanted to make some values variable is this ok?
Table RESULT = Table.query("SELECT * FROM [MANUF SCHEDULE], [ITEM MASTER] \ WHERE [MANUF SCHEDULE.NODE ID] = $1 AND [MANUF SCHEDULE.DATE] = $2 AND \ [MANUF SCHEDULE.SKU] = $3", /*1*/ current.NODE_ID, /*2*/ Table("CONFIG")[1][2], /*3*/ index); RESULT.cloneTo(Table("TEST"));
Index is the counter for a cycle.