Setfilter in Boolean

sabzam

Dear All I need to filter a boolean field. Is there any difference between

XTable.Setfilter (Field, Format(1));
XTable.Setfilter (Field, '%1', True);
?

Jackal

The same. IMHO

matteo_montanari

sabzam wrote:

Dear All I need to filter a boolean field. Is there any difference between

XTable.Setfilter (Field, Format(1));
XTable.Setfilter (Field, '%1', True);
?

Xtable.SETRANGE(Field, TRUE); ?

Eto

kine

Eto wrote:

Xtable.SETRANGE(Field, TRUE); ?

Eto

<= correct one... 8)

tihomirjur

Always use SETRANGE if possible because it is more efficient for searching the database. Use SETFILTER only if u cant do it with SETRANGE (meaning more complex filters).