FiveTech Software tech support forums

No vale Sr. Joao, yo preciso un recorte "trimmed" y no un recorte de unas posiciones determinadas
Gracias en todo caso

... like TABs, CRLF(EOL), EOF, EOpage, etc. If an optional list of characters is provided in the second parameter, these characters also are trimmed. Eg: cStr := CRLF + CHR(9) + "<<<*** GOOD ***>>>" + CRLF + CHR( 26 ) FW_AllTrim( cStr, "<>*" ) --> ...

... values is a memo-field. fixed now. * FW_ArrayAsList( aArray, [cDelim = ","], [lTrim = .f.] ) If the new 3rd param is .t., strings are trimmed. * New function FW_CRC8( cStr ) --> nCRC8 (source\function\fwcrc8.c) http://forums.fivetechsupport.com/viewtopic.php?f=6&t=40052&p=239014#p239014 ...

... style and this is how Windows displays text with trailing spaces with this style. Does not "trim" the string and then right-align the trimmed string. However, we can think of an enhancement by trimming the string and right-align when the Get does not have focus. Just thinking ... Whether ...

... * XBROWSE: - New DATA lVarChar in TXbrwColumn class: While editing array browses user can enter longer text than the present value and the text is trimmed while saving. Applies only for character values in arrays. - Positioning of BtnAction in GetBar when the application is themed is not correct. ...

Is codigo VarChar(6) ?

Such behavior can be expected when you save data with trailing spaces.
In any RDBMS like MySql, it is a good practice to save trimmed data.

Please try
DELETE FROM <table> WHERE RTRIM(codigo) = '<yourvalue>'

Hi Antonino
Database is BD2 on iSeries IBM and field CODICE is CHAR(15) (not VARCHAR) but when recordset read table chars are trimmed:
Field CHAR(15) in DBU = "123456abc "
field read = "123456abc".

which database are you using? the column is char(15) or varchar(15)?
On our application on SQL Server we have all column "char" and the spaces are not trimmed.
they are trimmed with varchar

... ) --> sum of the field Returns zero if the field is not numeric. * function FW_DbfToExcel(). Enhancement: All values of character fields are trimmed while exporting to Excel. * function FW_ArrayToDBF(). When storing into a memo field of DBFCDX, the data can be an array also. * XBROWSE: - ...

... use 3 fields: First, last, and company names. If the customer is not affiliated with a company, then I put their name, ( Last + First, NOT trimmed ... leave the spacing in place ) into the company field. I use the index on the Company field for searches and ordering in the xbrowse. It NEVER ...

... ) , nAge1, nAge2, dDate1, dDate2, lMarried1, lMarried2 ) // field < oCust:last > needed to be filtered // 'AC' must be replaced with the trimmed -> cLast ( from the get-field ) // 2 must be replaced with LEN( cLast ) // works with fixed values :!: oCust:SetFilter( " SUBSTR( UPPER( ...

* TDATABASE: - Data was being trimmed while saving to memo fields. Now data is saved along with trailing spaces if any without trimming. http://forums.fivetechsupport.com/viewtopic.php?f=6&t=36178 * Enhanced Active command of Dialog: ...

... has status=" " How does I Refilter with empty string? Refilter does not work with empty string. Very likely the value that is stored is trimmed and is "" or NULL but not " ". Only way is oRs:SetFilter( "PADR( status, 1 ) = ' '" ) My advice is not to rely ...

... has status=" " How does I Refilter with empty string? Refilter does not work with empty string. Very likely the value that is stored is trimmed and is "" or NULL but not " ". Only way is oRs:SetFilter( "PADR( status, 1 ) = ' '" ) My advice is not to rely ...

Hi all

Why when xBrowse display a column of type char (ALIG LEFT) are trimmed left spaces ?
Is it possible fix this ?

Es.: cStr := " Test" align is "Test"

TIA