FiveTech Software tech support forums

Hi, In my program I put conditional formating, and also formuls on cells in excel. The problem is that I don't have to put it on all the cells (so I can use range). So what I do now is put is on each cell that need it, the condition. ...

To see how the second method works, first test this small sample XBROWSER "STATES.DBF" SETUP ( oBrw:bRClicked := { |r,c,f,o| ;   o:aselected := { 2,3,4 }, o:ToExcel(), o:aselected := {} } )  thank mr. rao, I use recordset, so how could be the ...

This is not provided as a part of ToExcel() method. However, there are two ways of doing it. Approach-1 a) SetFilter to the condition. oBrw:Refresh() b) ToExcel() c) Clear filter and oBrw:Refresh() Approach-2 a) Prepare an array of RecNo()s to be exported. Example: aRecNo := {}( ...

Guys:
With xbrowse I want send data to excel using :toExcel but only those registers that meet some condition
and not all data that is displayed in the xbrowse

is it posible?, could you give me an example, please

Thank you

No please.
Instead you may use

Code: Select all  Expand view

oRs:Locate( "last = 'ge' .and. first = 'aa'" ) //--> lfound
 

The search condition should be in dbf syntax.

Taavi,

Html has the onchange event that allows you to execute a javascript function. That function you could easily test your validation and if it does not meet the condition put the focus again in the field. I'll look at simulating it ...

... on server or network resources. 2nd method. - Only required records are retrieved from the server. - But each time we change the filter/where condition, we need to retrieve the new data again. Everytime this places strain on server and network resources. So, depending on the size of the table ...

... next set filter. oRs:=oCn:RowSet('bigdata')oRs:SetFilter('datano = 555') In this situation, load all table to client. To change condition, oRs:SetFilter('datano=666') again. or with sql statement. oRs:=oCn:RowSet('select * from bigdata where datano = ?', {555}) ...

driessen wrote:DBF-files with CDX RDD

I am not expert as other friends, but I do not expect speed in dbf condition via internet. VPN is just a security.

I have the same problem like you. I have started to migrate my application MariaDB quickly. I expect more speed than dbf.

I didn't understand your answer. I´m speaking of hundreds records. Can't I specify a condition to select the rows ?

Iris, if the condition to set the colors is very complicated, I advise you to use a function that returns the corresponding color array oBrw:bClrStd := { || MyColors( oBrw ) }.../...Function MyColors( oBrw ...

... upper right corner of the dialog, and 4.- Press the ALT+F4 keys to close the dialog), the variable" lSelecc "should remain in .F. This condition is met in the first three cases, but fails in 4 (ALT+F4) that puts the variable in .T. as if you had clicked on the "Select" button. ...

Thank you Mr. Nages, I use ! Deleted() in index condition to solve this issue. Please do NOT use FOR conditions in Indexes. The purpose of indexes is also to speed up queries (FILTERS). The RDD does not consider indexes with FOR conditions for optimization. ...

... 2. These are issues relating to using the (x)Harbour function OrdKeyCount() but not XBrowse. Thank you Mr. Nages, I use ! Deleted() in index condition to solve this issue.

... [bWhile], [nNext], [nRecord], [lRest] ) // DBF Load( [cWhere] ) // MySql table Load( [aParams] ) // mysql query Reloads the data with the new condition / or existing condition Eg: oData:Load() // reloads the data using the exsiting bFor/cWhere oData:Load( "INVNUM=99" / { || "INVNUM=99" ...