How differenct speed of oRs:SetFilter() and oRs:ReFilter?

How differenct speed of oRs:SetFilter() and oRs:ReFilter?

Postby dutch » Fri Sep 01, 2017 2:10 am

I use FWH MySql/MARIADB and use ::SetFilter().
If I need to change filter. What is it best (speed) way?

::SetFilter('rsv_status="O"')
::SetFilter('rsv_status="R"')

or

::SetFilter( {'rsv_status = ?} , { "O" } )
::ReFilter( { "R" } )

Thanks in advance.
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1553
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: How differenct speed of oRs:SetFilter() and oRs:ReFilter?

Postby nageswaragunupudi » Sat Sep 02, 2017 2:16 am

All alternatives work the same way.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10681
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: How differenct speed of oRs:SetFilter() and oRs:ReFilter?

Postby dutch » Sat Sep 02, 2017 7:34 am

Thanks for your kind help, Mr.Rao.
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1553
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 22 guests