FiveTech Software tech support forums

... EDITABLE   NEXTreturn nil  But all this kind of lengthy code is not necessary for using XBrowse. Not only unnecessary, but also not desirable and nor recommended. What all you wanted to do, excepting the colors can be done using this short code. #include "fivewin.ch"function ...

... It is not even necessary to keep the connection alive, because FWHMySql reconnects to server when necessary. (from FWH 16.12 onwards) But it is desirable to keep the connection alive for better performance. We suggest to keep the session alive not by keep using dummy select every 30 seconds, ...

... EMG said, readability of code is more important. Please write your code in such a way that you can understand it even after ten years. It is also desirable that even other programmers can read and understand your code. I see also the very interesting oneliners of Xbrowser We purposefully made ...

... Even using Print to PDF kind of drivers generate better output. For occasional use, FWSavePreviewToPDF() does the job. But for bulk jobs, it is desirable to use external libraries or drivers, dedicated for this purpose, paid or free.

... a column for the incremental search, and when the user started typing, the keys entered would show up in the first row GET field. This is still a desirable feature if you can implement it. Tim

... use their UTF8 counter parts viz., HB_UTF8CHR(), HB_UTF8LEFT(), HB_UTF8RIGHT(), HB_UTF8SUBSTR(), HB_UTF8STUFF(), HF_UTF8LEN(). It is once again desirable to review the application programs and any 3rd party libraries they are using and make appropriate rectifications. Same way PAD() or PADR() ...

... use their UTF8 counter parts viz., HB_UTF8CHR(), HB_UTF8LEFT(), HB_UTF8RIGHT(), HB_UTF8SUBSTR(), HB_UTF8STUFF(), HF_UTF8LEN(). It is once again desirable to review the application programs and any 3rd party libraries they are using and make appropriate rectifications. Same way PAD() or PADR() ...

... When we assign NULL, server does not use Default value. Server thinks that we wanted the value to be NULL overriding the default value. So it is desirable to assign DEFAULT. This can be done either by omitting the assignment in SQL statement of specifically assigining DEFAULT. Now, how do we ...

... are read. Note: It is expected that the users are well acquinted with the issues, side-effects and possible inaccuracies while using LIMIT clause. Desirable to be thorough with MySql documentation. By far using Limit/Offset is safer when ordered by primary key. Option (3): oCn:RowSet( cSql, aParams, ...

...     { "state", "REFERENCES states(code)" }, ;      // remaining fields } )  It is desirable to define this relationship at the time of creation of the table than adding the constraint later, because column definition should exactly ...

... nCol, cText, [nWidth], [nHeight], [oFont], [cAlign], [nClrText], [nClrBack] ) --> nLastRowInPixels All coordinates are in pixels. nWidth: It is desirable to provide nWidth parameter. nHeight: If we do not now how much height the entire text requires to be printed, set nHeight to NIL. cAlign: ...

... rows (to be called during runtime only). Mostly useful in case of data sources with variable width fields like arrays, recordsets, etc. (Not desirable to be used with fixed width fields like DBF partculary when inline editing is enabled) (e) Improvement: Fast Edit now works with MarqueeStyle ...

... different ANSI and Unicode windows at the sametime and also one window/dialog to contain some Ansi and some Unicode controls. But for now it is desirable to have the entire application either as Ansi or as Unicode. However even in a Unicode application, every effort has been makde to maintain ...

... FW_SetUnicode(.t.) and rebuild the application. The entire application works with any language and many language at the same time. It is highly desirable to increase the field widths of all character fields by 2 to 3 times. Present Limitations: ADO/OLE do not work, due to Limitations of (x)Harbour. ...

... different ANSI and Unicode windows at the sametime and also one window/dialog to contain some Ansi and some Unicode controls. But for now it is desirable to have the entire application either as Ansi or as Unicode. However even in a Unicode application, every effort has been makde to maintain ...