FiveTech Software tech support forums

... must have something embedded in there because the filter doesn't work. I would write a routine to replace all the fake blank fields with all real blanks. Of course, you first need to find out which non-blank characters are showing visually as blanks. Finally, you can add a routine to check for ...

... ). However they must have something embedded in there because the filter doesn't work. I used Advantage Architect to also try to filter out the blanks, but that doesn't eliminate them either. Does anyone have suggestions for a really good DBF file repair tool ? Lots claim to be but I think they ...

Code: Select all  Expand view

oBrw:lDisplayZeros  := .F.

This is the right way and recommended by FWH.
This shows all numeric zeros and empty dates as blanks.
This setting applies to the entire Browse.

If we want this setting only to some columns, then use

Code: Select all  Expand view

oCol:lDisplayZeros := .F.

... to the field, save the record, unlock it. This happens in milliseconds and no other user on the network will have access. 2) Fill the data with blanks in variables, edit the variables with all the data, then in your Save method, lock the file, append the record, calculate and put the number ...

... to the field, save the record, unlock it. This happens in milliseconds and no other user on the network will have access. 2) Fill the data with blanks in variables, edit the variables with all the data, then in your Save method, lock the file, append the record, calculate and put the number ...

... Pads numbers with zeros instead of blank spaces R Nontemplate characters are inserted X Adds DB (debit) after negative numbers Z Formats zeros as blanks ( Encloses negative numbers in parentheses ! Converts alphabetic characters to uppercase Picture mask The picture mask must be separated by a ...

... Fixed. - @Z picture format: With this picture format, empty numeric values should be displayed as blanks when the get is not in focus. This is the standard behaviour of Clipper and (x)Harbour. But FWH displays 0 in all gets with and without focus. ...

... behaviour of Clipper and (x)Harbour without FWH is that "0.00" is displayed only in the Get having focus. Gets not having focus display blanks only and not digits. But FWH till version 19.12 displays "0.00" in all Gets whether having focus or not. This is fixed in 20.01. Now ...

... behaviour of Clipper and (x)Harbour without FWH is that "0.00" is displayed only in the Get having focus. Gets not having focus display blanks only and not digits. But FWH till version 19.12 displays "0.00" in all Gets whether having focus or not. This is fixed in 20.01. Now ...

... Pads numbers with zeros instead of blank spaces R Nontemplate characters are inserted X Adds DB (debit) after negative numbers Z Formats zeros as blanks ( Encloses negative numbers in parentheses ! Converts alphabetic characters to uppercase Picture mask The picture mask must be separated by a ...

I use FWH 1905, and your advise does not work, the xBrowse row show blanks cols. Sorry, there is a small bug in xbrowse. Please try this sample. #include "fivewin.ch"function Main()   local oCn, oRs, oDlg, oFont, oBrw   oCn ...

Mr. Rao:

I use FWH 1905, and your advise does not work, the xBrowse row show blanks cols.

an other clue?

Regards

hi Marc, thank you, that's good solution.
But is SET EXACT ON a good solution too?

why CHAR fields in recordest lose right blanks ?

Hi I have this field in recordset: oRs:Fields("CODICE"):value Field CODICE in table is CHAR(15) but in oRs object it lost right blanks. inside table I have due article: 1st article "5224366010" 2nd article "5224366010V10" when field oRs:Fields("CODICE"):value ...

hi Mr. Rao
field ARTICOLO is 15 char len and FW_DbfToExcel() exports that field in column A without RTRIM blanks but with blanks until 15th character:
"0009533597 " and not "0009533597"
how can I to solve it inside function?
thank you