FiveTech Software tech support forums

... This is what we call Wide Char. Some sample characters: https://imagizer.imageshack.com/v2/xq70/924/X5iuAK.png Now, let us concatenate all UTF8 chars (6th column) and display: 9AÜĞత Unicode system is a family of different encodings all of which are aimed at uniquely representing ...

superscript characters of space or volume

Please give some examples and let us try now.
Any character can also be expressed in utf8. Then we can concatenate all utf8 characters

... look exacty alike and in fact both represent the same character. But both are different. When compared, both are not equal and also we can not concatenate both the strings. Nothing to do with FW_SetUnicode() and nothing to do with any Codepage To see the point clearly, let is try this sample. ...

... ) JS: cNwName = cUsrName.toUpperCase(); To know how many chars FW: nChars := len( cUsrName ) JS: nChars = cUsrName.length; And off course you can concatenate several methods in one single line : aNames = cUsrName.toUpperCase().split(' '); I'm not saying JS is better language than FW, it has several ...

... .t. )  4) Such large export of data should be attempted on local server. 5) Increase max_allowed_packetsize suitably and concatenate more than one update statement with ";" so that the total size of the combined sql does not exceed 80% of the max_allowed_packetsize. ...

XBrowse or some other browse is not the issue. The second sql statement results in a 2nd recordset different from the 1st recordset. You can not concatenate both recordsets. Hope you agree. Do you plan to replace the 1st record set with 2nd recordset? While browsing one of the recordsets the user ...

... involve multiple Recordsets, opening on demand and swapping them on the basis of navigational needs. Unfortunately there is no way to append or concatenate recordsets. This adds quite a bit complexity to coding but can be done if it is really worthwhile. What we may lose in the process are sort, ...

To All Using the same logic to concatenate in the Substring parameters as I did the nproj .. here is the working Sql Statement. Thanks Rick Lipkin nLen := len(ltrim(str(nProj)))nLen++cSQL := "Select * from Coproposal ...

James, Are you saying that SQL can concatenate unlike data values automatically? Are unlike data values always converted to string, or could you add a date + 10 and get a date ten days after the date specified? (I'm not sure why you might ...

... ADO TABLES INDEX LIST TO {   {"TABLE1",{"COD1","COD+NCOD2+DCOD3"}... Are you saying that SQL can concatenate unlike data values automatically? Are unlike data values always converted to string, or could you add a date + 10 and get a date ten days ...

Sorry, should have been dtoc() not ctod()

Richard and Gale

Thank you both .. been a long day and I am headed home. I will let you both know in the morning ..

Happy New Year!
Rick Lipkin

Is startdate and endingdate fields a date type or character type.
You may need to convert them to character. { || ctod(startdate)+CRLF+ctod(endingdate) }

Rick Maybe the version , nevertheless you can do it in another way by calling a function in the columns definition instead of { || STARTDATE+ENDINGDATE } { || FUNC1() } .... STATIC FUNCTION FUNC1() RETURN STARTDATE + ENDINGDATE This will work as i use it since very long time, after you may format wi...

Richard Sorry about the quotes .. I re-compiled but I did not get any data with this code :( .. I am using Fwh1203 .. don't know if that has any bearing on the results. Rick Lipkin // ad run in these publications         REDEFINE xBROWSE oLbxC      ;         RECORDSET oRsAdvtBill       ;         COL...