FiveTech Software tech support forums

Time Zone conversions Here is an example converting our local time to UTC and then NewYork time ( UTC Offset now -5:00 ) function TimeZoneConversions()   local tDateTimeLocal, tDateTimeUTC, tDateTimeNYC   tDateTimeLocal ...

... ) FROM_UNIXTIM( nUnixTime ) Please note that in this case unix timestamp or in Seconds. Not milli seconds. We need to take care of conversions. Please note that FWH functions deal with the UnixTime in millliseconds whereas MySql functions deal with Seconds. Examples: ? oCn:QueryResult( ...

... environment to UTF8, i.e. source code (UEStudio) and database DBF/MariaDB. From now on, I no longer have to worry about the encoding. No more conversions between the code pages HB_OemToAnsi()/HB_AnsiToOem(). Of course also no AnsiToUtf8()/UTF8ToAnsi(). No more 'garbled' characters due to incorrect ...

... i do not have Problem with XBROWSE, i do have Problem with DrXlsx LIB When the new version FWH2309 is released, you do not need to any utf8 conversions on your own. FWH will do this conversion while using DrXlsx. ok i will wait and try "your" Way from XBROWSER()

... using DrXlsx by the new FWH interface to this library All look identical https://imagizer.imageshack.com/v2/xq70/923/3jG1n6.png Conversions from OEM to ANSI and ANSI to UTF8 are all done automatically and correctly by FWH without any code written by the programmer. Personally ...

... the work a programmer needs to do is to set oBrw:lOemAnsi := .t. or oCol:lOemAnsi := .t. for the required columns and then export to Excel. All conversions will be automatically taken care by the FWH interface to DrXlsx. Hope we can not make it easier than this. Sample which i used have > ...

... ENDDUMP  https://imagizer.imageshack.com/v2/xq70/922/HEVmrJ.png If you run this test as it is you will also see that these conversions work well with Drxlsx as well as Excel. When you use these functions directly on your DBF, it fails. That should be expected. Reason: As ...

the first parameter of this function is a string.
string conversions depend on codepage.
invalid codepage may create problems at any point.

... write to the dbf. In the above case it took about 35 seconds. This function also does some basic validation of data types and suitable data type conversions. https://imagizer.imageshack.com/v2/xq90/924/Wk3TKm.png

In case you are using built-in FWH MariaDB/MySql library, you need not worry about it. The library automatically takes care of the conversions. Example Usage: oRs:photo := MEMOREAD( "photo.jpg" )oRs:Save()  Without opening the table as rowset: oCn:Insert( cTable, ...

... …“ ist ein Blindtext" )        memowrit(cHtmlOrUrl, cHtml)     PrintHtml(cHtmlOrUrl,1,.t.)  You will bring this kind of conversions (coded) into a xbrowse replacement i suspect in order to manipulate the conversion data into a browse ?

... do it. They give good quality and we keep improving the quality. You can reduce a lot of coding. Also if you give the file name directly, lot of conversions will be avoided and you get better quality output. About printing alpha images: Your printer needs to support alpha printing. Not all printers ...

... Now, do not bother to replace local variables with their values. Just use Exec() method like this, using exactly the same expession without any conversions: oReservation:Exec( < ||   SET FILTER TO AllTrim( FIELD->TYPE ) == AllTrim( cTypeRoom ) .and. FIELD->NUM ...

... of the globe. I hope and I want a product of Fivetech that is compatible with the dbf files the same we use in our applications without making conversions and reconversions in and output, I think this is the desire of all or rather the majority of users of fivewin and Harbor

Now, we need to convert numbers and dates to string values before calling addstring(). These conversions at Harbour level are a bit less efficient than in C level. Can you handle these conversions inside the method automatically? I would prefer to keep it as simple as ...