I'm trying to create and impex in a way that i can feed the result of flexible query to the impex
INSERT_UPDATE PriceRow;product(code, $catalogVersion)[unique=true];unit(code[unique=true,default=pieces]);currency(isocode)[unique=true];price"#% impex.initDatabase("""); //DB details "#% impex.includeSQLData(""SELECT item_t1.p_code FROM products "",""pieces"",""USD"",""15"");"
so that i can update the price rows for a list of products in one go but it does'nt seems to be working as no price rows are added but it is also not giving any errors when i'm executing this in bean shell.
Please suggest