I have noticed that inserting a check box in xBrowse has changed .. Please review my code and let me know what I am doing wrong ?
The Ado Fieldtype is YesNo .. and has worked in prior versions ..
Thanks
Rick Lipkin
ps TestXbr3.prg is not working either .. just have a column .T. or .F. for Married Column
- Code: Select all Expand view
REDEFINE xBROWSE oLBXB ;
RECORDSET oRsDetail ;
COLUMNS "QTY", ;
"INVENTORY ID", ;
"INVENTORY TYPE", ;
"ITEM DESCRIPTION", ;
"PRICE", ;
"LOCATION", ;
"COVERED BY WARRANTY" ;
COLSIZES 45,120,70,310,65,80,50 ;
HEADERS "Qty", ;
"Part Number", ;
"Type", ;
"Description", ;
"Price", ;
"Location", ;
"Warranty" ;
ID 172 of oWorkB ;
AUTOCOLS LINES CELL
// row numbers
ADD oCol to oLbxB AT 1 DATA oLbxB:KeyNo() HEADER 'Ln' size 23 //PICTURE '9999'
oLbxB:aCols[1]:nDataStrAlign := AL_LEFT
oLbxB:aCols[1]:nHeadStrAlign := AL_LEFT
// extention
ADD oCol TO oLbxB AT 7 DATA {|x| x := _CalcExt( oRsDetail:Fields("Qty"):Value,;
oRsDetail:Fields("Price"):Value )} HEADER 'Ext' size 65
if ! empty(oCol := oLbxB:oCol( "COVERED BY WARRANTY" ))
oCol:SetCheck( { "ON", "OFF" } )
oCol:cSortOrder := nil
endif