FiveTech Software tech support forums

... is it also nessesary to change how the filter will be created ? Current filter : "WIC" $ UPPER( TAG ) .AND. "POLO" $ UPPER( NAAM ) .AND. "WHITE" $ UPPER( KLEUR )

... it is fast. Have you acode snipped where you use Xbrowse Header gets and use temp index instead of filter. You would make local ... Field Tag, Naam, Kleur Filter = "WIC" $ UPPER( TAG ) .AND. "POLO" $ UPPER( NAAM ) .AND. "WHITE" $ UPPER( KLEUR ) Index will be like ...

... with 380.000 records, 32 fields and 7 tags. (242 Megabite) the filter look like : "WIC" $ UPPER( TAG ) .AND. "POLO" $ UPPER( NAAM ) .AND. "WHITE" $ UPPER( KLEUR ) This filter is build with the above function Marc_Setfilter using Xbrowse header gets. The active tag ...

example:
select products
goto top
do while .NOT. eof()
cnaam=TRIM(products->naam) to transform in his real fieldname

select sales
append blank
replace sales->fieldname with ....

select products
skip 1

enddo

... commands become the real record names? select products a=5 b=5.8 set filter to products->niet=" " goto top do while .NOT. eof() cnaam2=TRIM(products->naam) nalias=TRIM(products->alias) @ a,5 say cnaam OF oDlg FONT oFont @ b,12 get nalias OF oDlg SIZE 20,11 picture "999" ...

is working : aConvert = { { "code", "A" }, { "naam", "B" } } is working : aConvert = { { "code", 1 }, { "naam", 2 } } Good. is Not working : aConvert = { { "code", "id" }, { "naam", ...

I noticed this : is working : aConvert = { { "code", "A" }, { "naam", "B" } } is working : aConvert = { { "code", 1 }, { "naam", 2 } } is Not working : aConvert = { { "code", "id" }, { "naam", ...

... tried to get this code working the correct way. It is probably simple, but i have a bad day i think :twisted: I have a Xbrowse with a field "NAAM". That field will be splitt into a array to have every single word (hb_aTokens) Then there will be build btnbmp's for every word. Klikken ...

... situation? The compiling is OK but when launching I got an error message ..... select temp2 goto top do while .NOT. eof() calias:=temp2->alias cnaam:=temp2->naam select temp1 sum all temp1->&( calias ) to ntotalias oPrn:say(nRow, 10*fntArial2:nWidth, cnaam, fntArial3) oPrn:say(nRow, ...

... to find all values of the selected record Result shoud be the values of the folowing fields... aData[1,1] = Code .or. aData[1] = code aData[1,2] = Naam ..... rest of all the fieldnames = Value function Testobj()   local cText,oXmlDoc,oXmlIter,oTagActual   local nDepth, nDone:=0, cData:=""  ...

... do You get the field-type infos and sizes from. regards Uwe :?: Uwe, My csv files that I receive always include a first line with headers : Code,Naam,Prijs,Maatplus,Minafn,Verpak,Stock 11103250,splitleder amerikaantje gestr.palmverst.,Prijs op aanvraag,,12,120,V 11105100,rundsplit geel gev. gestr.kap,Prijs ...

// Here I want based on the current colomn to put the Seek data in that field /* if oBrw:oCol() = 2 oRec:SetDefault( "naam_1", oBrw:cSeek ) elseif oBrw:oCol() = 3 oRec:SetDefault( "straat", oBrw:cSeek ) oRec:SetDefault( oBrw:SelectedCol():cExpr, oBrw:cSeek )  It ...

... I was able to have a dynamic header in xbrowse based on the active year : J_2019, J_2018, J_2017,... (So this works) oBrw[1]:cHeaders := { 'Code','Naam','Gemeente','Dat_LST','J_'+str(year(date()),4),'J_'+str(year(date())-1,4),'J_'+str(year(date())-2,4),'J_'+str(year(date())-3,4),'J_'+str(year(date())-4,4),'Totaal' ...

oCn:Insert(...) works in all versions. Please see this part of your code: { oBrw:naam, oBrw:voornaam, oBrw:p2017, cPloeg, date() }  oBrw:naam returns the column object, not value. That is the error. You should be using { oBrw:naam:Value, ...

... to insert a new row in a database 'changes' so I can trace changes that have been made by others. oCn:Insert( "changes", "bond, naam, voornaam,oldploeg,newploeg,datum", { oBrw:naam, oBrw:voornaam, oBrw:p2017, cPloeg, date() } ) The insert should do this, but nothing happens ...