FiveTech Software tech support forums

... (RecordSet with adUseServer) are *mostly* unidirectional and single pass, used mainly for fast single pass processing. Even this is not generally desirable and may result in wrong results because we lose the benefit of snap-shot query benefits. What we mostly use is RecordSet with adUseClient ...

... type 'T' To extract only the truncated date dValue := FW_TTOD( oRs:Fields( "DTFIELD" ):Value ) When you want to assign empty date it is desirable to assign AdoNull() eg: oRs:Fields( "DTFIELD" ):Value := AdoNull() // instead of CtoD( "" ) Note: Recent versions of SQL ...

... := If( x, -1, 0 ) ) }  So, 1) It is better to use BIT fieldtype than TINYINT for logical values. In the longrun, it is desirable to convert TINYINT as BIT fields. 2) It is safer to use FWAdoCreateTable(...) function to create tables. 3) DataRow is not big obstacle. We ...

... newer clients. While older clients are always compatible with newer servers the opposite is not true. It should be noted that it is not always desirable to stay with old clients. Newer servers introduce new functionality and services that are only available with the corresponding new client. ...

... enable warnings for undeclared variables while compiling. That is the reason you did not notice this. Please remove ROUND clause and it is always desirable to have "OF oDlg"

... bEditValid is to return whether the value entered by the user is valid of not. You may replace the value by oGet:oGet:VarPut or oGet:cText. It is desirable not to direcly write to database here because that may have unexpecte side-effects like this. It is agreed that in some situations we need ...

... arrow keys do not work during execution of oCol:bEditValid. Up/Down keys work only after validation is completed and browse is refreshed. It is desirable not to write inside a valid function but to keep its functionality limited to return valid status. If we want to change the user's input we ...

... sub-continent. To set / change the format, call the function: FWNumFormat( cInternational, ; // 'A' or 'E' .or. 'I" lUseThousandSep ) It is desirable to set the format at the beginning of the program Example: FWNumFormat( 'A', .t. ) XBrowse automatically builds picture clause of Numeric ...

... as an additional way to start edit. Single click is used for cell navigation. For browses where users are required to do lot of data-entry, it is desirable to enable Fastedit mode where pressing a data key triggers edit and after edit the next editable cell is ready for edit. We can also configure ...

This can happen if any row is added during runtime.
If a row is added or deleted, we should call oCol:WorkMergeData() and oBrw:Refresh().

In case you are browsing DBF it is desirable to SET FILTER TO !DELETED() so that oBrw:keyNo() always returns a correct value.

... end. You may use any DBFs in the samples folder. Note: By default, xbrowse creates bOnPostEdit codeblocks internally. They work efficiently. It is desirable not to override these default codeblocks with user codeblocks.

... high-end or dedicated products in speed, quality or size-optimization. If for a project, generation of PDFs is required on large scale, it is desirable that we may use special libraries like emf2pdf, etc. This must be the difference.

... so that : obj:<colname> returns value of the column and obj:<colname> := x sets the new value of to the colname Optional but highly Desirable Methods: 1) Seek( cSeek, lSoftSeek, lWildSeek ) // if the method exists, XBrowse uses this for incremental seeks. XBrowse uses only 1st and ...

... or any alias used in the report are not disturbed by any action in any other window. If we want to use export to Excel feature, it is highly desirable to use MODAL preview. If you are still facing any problem even after observing the above, please post a sample program to reproduce the problem ...

... forth. ( Single line skips may be ok but skipping by large number of lines may be a little slow ) If the purpose is basically readonly it is more desirable to create an index table once and use it to browse whenever needed.