Thank you!
Maybe one last question on the subject.
If i do my dbr.import and I have select from my resulting table all inside of my report, so user can see what exactly he has uploaded - the issue I have is that dbr.import works perfectly fine, all validations work etc, but I can't seem to find the way to force refresh screen, so under "upload file" dialog box I can show results of my select from table with uploaded data.
I have tried adding dbr.refresh but it does not seem do just a single refresh, rather it forces periodic refresh even with no parameters.
Here is my code:
select 'dbr.editable', '[Description]', 'sp_DBR_UploadVendorItems_edit_descr', 'vID=ID', 'type=autosize';
select 'dbr.editable', '[PartNumber]', 'sp_DBR_UploadVendorItems_edit_partno', 'vID=ID', 'type=autosize';
select 'dbr.editable', '[Mfg]', 'sp_DBR_UploadVendorItems_edit_mfg', 'vID=ID', 'type=select', "select=select distinct mfg from ssn.VendorItems";
select 'dbr.editable', '[Cond]', 'sp_DBR_UploadVendorItems_edit_cond', 'vID=ID', 'type=select', "select=select distinct destval from ssn.xref where dest='SSN' and domain='Condition'";
select 'dbr.editable', '[Qty]', 'sp_DBR_UploadVendorItems_edit_qty', 'vID=ID', 'type=autosize';
select 'dbr.editable', '[PriceUSD]', 'sp_DBR_UploadVendorItems_edit_prusd', 'vID=ID', 'type=autosize';
select 'dbr.editable', '[PriceEUR]', 'sp_DBR_UploadVendorItems_edit_preur', 'vID=ID', 'type=autosize';
select 'dbr.javascript', "function confirmdel(obj) {return confirm('Delete item \\''+$(obj).parent().children().eq(2).text()+'\\'?');}";
select 'dbr.report', 'sp_DBR_UploadVendorItems_del', '[del]', 'hiddendiv', 'inID=ID', 'event=click', 'callbefore=confirmdel';
select 'dbr.import.options', 'skip_header', 1; /* Treat first line as header and skip it */
select 'dbr.import.options', 'extra_columns', vSelectedVendor;
select 'dbr.import', 'sp_DBR_UploadVendorItems_do';
select 'dbr.import.finish', 'sp_DBR_UploadVendorItems_finish';
select ID, VendorName, Description, PartNumber, Mfg, Cond, Qty, PriceUSD, PriceEUR,
'dbr.purehtml:<div class="i_delete"></div>' as '[del]'
from ssn.VendorItemsUpload;
select 'dbr.keepwithnext';
select 'dbr.embed_object', 'saved';
select 'dbr.embed_object', 'cancelled';
select 'dbr.keepwithnext';
select 'dbr.button', 'Save';
select 'dbr.report', 'sp_DBR_UploadVendorItems_save', 'saved';
select 'dummy';
select 'dbr.button','Cancel';
select 'dbr.report', 'sp_DBR_UploadVendorItems_cancel', 'cancelled';
select 'dummy';
