FoxInCloud
Error formatting columns in a grid
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Sep 29, 2014 @ 03:48am
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Sep 29, 2014 @ 06:15am
Nothing changes...
What if you add 'R' to .Format?
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Sep 29, 2014 @ 07:26am
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Sep 29, 2014 @ 08:28am
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Sep 29, 2014 @ 08:59am
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Sep 30, 2014 @ 12:00am
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Sep 30, 2014 @ 01:04am
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Oct 15, 2014 @ 05:52am
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
OK thanks
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Oct 15, 2014 @ 06:29am
Ciao Michele
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
1/ did you apply the patch I was suggesting?
2/ could you try this:
- create your cursor blank in form.Load() (select ... from ... where .F. into cursor ...)
- assign the columns.controlSource in grid.Init()
- refresh the cursor in Form.init() based on the parameters passed
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Oct 15, 2014 @ 07:43am
It works....
Ciao Michele
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
Ciao Michele
1/ did you apply the patch I was suggesting?
2/ could you try this:
- create your cursor blank in form.Load() (select ... from ... where .F. into cursor ...)
- assign the columns.controlSource in grid.Init()
- refresh the cursor in Form.init() based on the parameters passed
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
Re: Error formatting columns in a grid FoxInCloud Support - Thierry N.
Michele
Oct 16, 2014 @ 12:18am
Ciao Michele,
It works....
Ciao Michele
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
what works? (1) alone, (2) alone, or (1) and (2)?
Generally speaking, FoxInCloud is mainly designed for a 'regular' usage of VFP:
- open data sources in form.Load() and/or form.DataEnvironment
- assign .ControlSource at design time and/or at control.Init()
- form.Init() mainly does requery() based on the parameters passed
It works....
Ciao Michele
1/ did you apply the patch I was suggesting?
2/ could you try this:
- create your cursor blank in form.Load() (select ... from ... where .F. into cursor ...)
- assign the columns.controlSource in grid.Init()
- refresh the cursor in Form.init() based on the parameters passed
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...
-- thn (FoxInCloud)
Re: Error formatting columns in a grid Michele
Thierry Nivelet (FoxInCloud)
Oct 17, 2014 @ 02:35am
1 and 2 together...
Ciao Michele,
It works....
Ciao Michele
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
Ciao Michele,
what works? (1) alone, (2) alone, or (1) and (2)?
Generally speaking, FoxInCloud is mainly designed for a 'regular' usage of VFP:
- open data sources in form.Load() and/or form.DataEnvironment
- assign .ControlSource at design time and/or at control.Init()
- form.Init() mainly does requery() based on the parameters passed
It works....
Ciao Michele
1/ did you apply the patch I was suggesting?
2/ could you try this:
- create your cursor blank in form.Load() (select ... from ... where .F. into cursor ...)
- assign the columns.controlSource in grid.Init()
- refresh the cursor in Form.init() based on the parameters passed
I still have some problems. In this image it is possible to see that in columns where i have zero and i have format='Z' the zero is shown. In another column even if i have inputmask='999,999.99' it is shown 0.0000. In all numeric columns i have format = 'Z'. I need to not show columns with zero value.....or i have to transform it ?
OK thanks
Can you try this?
modify command awHTML
&& in
PROTECTED FUNCTION getHTML_grd_AW_cScript_ctl_txt
&& replace:
CASE m.tcType == 'N'
&& by:
CASE m.tcType == 'N' or !Empty(m.lcMask)
I defined Grid's parameters at design time in the form. In the form's Init() i make a query and then
With .erp_Pageframe1.Page1.Grid1
.RecordSource = "Righe"
.Column1.ControlSource = "Righe->Rbo"
.Column1.InputMask = "999"
.Column2.ControlSource = "Righe->Cod"
.Column3.ControlSource = "Righe->Des"
.Column4.ControlSource = "Righe->Umv"
.Column5.ControlSource = "Righe->Con"
.Column6.ControlSource = "Righe->Npr"
.Column7.ControlSource = "Righe->Ns1"
.Column8.ControlSource = "Righe->Ns2"
.Column9.ControlSource = "Righe->Net"
.Column10.ControlSource = "Righe->Civ"
EndWith
are Column.controlSource defined first time form is instantiated (initialized without any parameter)
IOW, what code do you have in form.init()?
/* Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 -- *//
jQuery.datepicker.setDefaults(Object.extend(jQuery.datepicker.regional['it']||jQuery.datepicker.regional[''], {dateFormat: 'dd/mm/yy', onSelect: function(date){FoxInCloud.EventRequest('DOMEvent','blur', this, date)}, altField: ''}));
FoxInCloud.formActivateObserve('erp_form_documento', null, false);
$('erp_form_documento-doc').disabled=true;
$('erp_form_documento-doc').wlValidAutoNot = true;
$('erp_form_documento-dt1').disabled=true;
$('erp_form_documento-dt1').wlValidAutoNot = true;
!/Mobile/i.test(navigator.userAgent) && jQuery('#erp_form_documento-dt1').datepicker({minDate:null, maxDate:null});
$('erp_form_documento-npr').disabled=true;
$('erp_form_documento-npr').wlValidAutoNot = true;
$('erp_form_documento-com').disabled=true;
$('erp_form_documento-com').wlValidAutoNot = true;
$('erp_form_documento-ccf').disabled=true;
$('erp_form_documento-ccf').wlValidAutoNot = true;
$('erp_form_documento-dcf').disabled=true;
$('erp_form_documento-dcf').wlValidAutoNot = true;
$('erp_form_documento-cde').disabled=true;
$('erp_form_documento-cde').wlValidAutoNot = true;
$('erp_form_documento-dcde').disabled=true;
$('erp_form_documento-dcde').wlValidAutoNot = true;
$('erp_form_documento-mpr').disabled=true;
$('erp_form_documento-mpr').wlValidAutoNot = true;
$('erp_form_documento-dmpr').disabled=true;
$('erp_form_documento-dmpr').wlValidAutoNot = true;
$('erp_form_documento-pag').disabled=true;
$('erp_form_documento-pag').wlValidAutoNot = true;
$('erp_form_documento-dpag').disabled=true;
$('erp_form_documento-dpag').wlValidAutoNot = true;
$('erp_form_documento-btclose').wuValue = true;
(function(){
var dStart = new Date();
var grd = $('erp_form_documento-erp_pageframe1-page1-grid1');
if (grd){
Object.extend(grd, {oGrid: new AW.UI.Grid, oTable: new AW.XML.Table});
var oGrid = $('erp_form_documento-erp_pageframe1-page1-grid1').oGrid, oTable = $('erp_form_documento-erp_pageframe1-page1-grid1').oTable, oTempl;
oGrid.defineControlProperty('DataUpdate', false);
oGrid.defineCellProperty('CurrentControl', null);
oGrid.setSelectorWidth(10);
oGrid.getSelectorTemplate().setStyle('font-weight','bold');
oGrid.setRowCount(0);
oGrid.setCurrentColumn(-1);
oGrid.setCurrentRow(-1);
oGrid.clearColumnModel();
oGrid.setColumnCount(10);
oGrid.setStyle('font-family','Verdana');
oGrid.setStyle('font-size','8pt');
oGrid.setHeaderHeight(19);
oGrid.setSize(undefined,275);
oGrid.setSelectorVisible(true);
oGrid.setRowHeight(17);
oGrid.setScrollBars('vertical');
oGrid.setSize(972,undefined);
oGrid.setColumnIndices([0,1,2,3,4,5,6,7,8,9]);
oGrid.setColumnResizable(true,0);
oGrid.setColumnWidth(50+1,0);
oGrid.setHeaderText('Riga',0);
oGrid.setColumnResizable(true,1);
oGrid.setColumnWidth(140+1,1);
oGrid.setHeaderText('Codice',1);
oGrid.setColumnResizable(true,2);
oGrid.setColumnWidth(279+1,2);
oGrid.setHeaderText('Descrizione',2);
oGrid.setColumnResizable(true,3);
oGrid.setColumnWidth(38+1,3);
oGrid.setHeaderText('U.M.',3);
oGrid.setColumnResizable(true,4);
oGrid.setColumnWidth(90+1,4);
oGrid.setHeaderText('Quantità',4);
oGrid.setColumnResizable(true,5);
oGrid.setColumnWidth(91+1,5);
oGrid.setHeaderText('Prezzo',5);
oGrid.setColumnResizable(true,6);
oGrid.setColumnWidth(60+1,6);
oGrid.setHeaderText('Sc.1',6);
oGrid.setColumnResizable(true,7);
oGrid.setColumnWidth(60+1,7);
oGrid.setHeaderText('Sc.2',7);
oGrid.setColumnResizable(true,8);
oGrid.setColumnWidth(93+1,8);
oGrid.setHeaderText('Netto',8);
oGrid.setColumnResizable(true,9);
oGrid.setColumnWidth(31+1,9);
oGrid.setHeaderText('IVA',9);
/* Column 0 'Column1' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(0);
oTempl.setStyle('text-align','center');
/* Column 1 'Column2' *//
oTempl = oGrid.getHeaderTemplate(1);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(1);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 2 'Column3' *//
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(2);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 3 'Column4' *//
oTempl = oGrid.getHeaderTemplate(3);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(3);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
/* Column 4 'Column5' *//
oTempl = oGrid.getHeaderTemplate(4);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(4);
oTempl.setStyle('text-align','right');
/* Column 5 'Column6' *//
oTempl = oGrid.getHeaderTemplate(5);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(5);
oTempl.setStyle('text-align','right');
/* Column 6 'Column7' *//
oTempl = oGrid.getHeaderTemplate(6);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(6);
oTempl.setStyle('text-align','right');
/* Column 7 'Column8' *//
oTempl = oGrid.getHeaderTemplate(7);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(7);
oTempl.setStyle('text-align','right');
/* Column 8 'Column9' *//
oTempl = oGrid.getHeaderTemplate(8);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(8);
oTempl.setStyle('text-align','right');
/* Column 9 'Column10' *//
oTempl = oGrid.getHeaderTemplate(9);
oTempl.setStyle('text-align','center');
/* -- Text1 (Textbox) -- *//
oTempl = oGrid.getCellTemplate(9);
oTempl.setStyle('text-align','left');
oTempl.setStyle('text-align','left');
oGrid.setSortDirection();
oGrid.refresh();
oGrid.defineRowProperty('tuRow', null);
oGrid.defineRowProperty('Clicked', false);
oGrid.onRowMouseDown = function(event, row){this.setRowClicked(true, row)};
oGrid.onRowMouseUp = function(event, row){this.setRowClicked(false, row)};
oGrid.onCurrentRowChanged = function(row){
var value = this.getRowProperty('tuRow', row);
if (!(this.disabled || value === null)){
if (!this.getRowClicked(row) && FoxInCloud.gridRowChangeDelay > 0){
if (this.nTO) window.clearTimeout(this.nTO);
this.nTO = FoxInCloud.gridMethod.bind(FoxInCloud).delay(FoxInCloud.gridRowChangeDelay, 'wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
else FoxInCloud.gridMethod('wAfterRowChange', $('erp_form_documento-erp_pageframe1-page1-grid1'), value);
}
this.setRowClicked(false, row);
};
oGrid.onKeyBackspace = function(event){
Event.extend(event).stop();
};
oGrid.setSelectedRows([-1]);
oGrid.setSelectedRows([-1]);
oGrid.setSelectedColumns([0]);
oGrid.disabled = true;
oGrid.setCurrentRow(-1);
oGrid.setCurrentColumn(0);
oGrid.disabled = false;
grd.update(oGrid);
}
dStart = new Date() - dStart;
console && console.log && console.log("'erp_form_documento-erp_pageframe1-page1-grid1' grid script took 220 ms to generate on the server, " + dStart + " ms to execute on the browser, total " + (dStart + 220) + " ms.\n" + 'awhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_oxmlchanges() - 38 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_rs() - 1 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_events() - 142 ms\nawhtml.fxp!Ogrid1.gethtml_grd_aw_cscript_() - 181 ms');
})();
$('erp_form_documento-erp_pageframe1-page1-grid1').readOnly=true;
$('erp_form_documento-erp_pageframe1-page1').lActivateSend=true;
$('erp_form_documento-erp_pageframe1-page2').lActivateSend=true;
FoxInCloud.pgfMake('erp_form_documento-erp_pageframe1', 'erp_form_documento-erp_pageframe1-page1', false, [], true, false, 0, 0);
FoxInCloud.documentInit('erp_form_documento');
$('erp_form_documento-erp_pageframe1').pageActivate('erp_form_documento-erp_pageframe1-page1');
/* -- Generated on 29/09/2014 15:33:54 in 1,432 sec by FoxInCloud version 2.10 *//
can you post the javascript generated by FoxInCloud for this form?
you can find it at site root, named as VFPclass.js or form_scx.js
Nothing changes...
What if you add 'R' to .Format?
column.format = "ZR"
I have a grid with some columns that contain numeric values....The problem is that i set column.format = "Z" and column.inputmask = '999' in first column and '999,999,999.99' in other, but the result is always the same..... In Desktop mode it works...