In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

need help with Filter

Xailer professional forum in English
Responder
jemstv
Mensajes: 133
Registrado: Mar Jul 27, 2010 3:56 pm

need help with Filter

Mensaje por jemstv »


Hi again;
on a multi page tfolder
on page 1 i save a fielda that i want to use as a filter on
a tdbbrowse so only records matching that value of filedA are shown
cant find good samples of set filter...
tried harbor but get internal error
thanks in advance
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9447
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

need help with Filter

Mensaje por ignacio »

Josemo,
The filter value must be a expression recognized by the underlying database
system. In case of SQL datasources it must be a valid WHERE clause. In case
of DBF datasets it must be a expression compatible with the SET FILTER
command.
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info
http://www.xailer.com/forum
http://www.xailer.com/dokuwiki
"Josemo" <magjem[at]sbcglobal[dot]net> escribió en el mensaje de
noticias:4c952391$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>
> Hi again;
>
> on a multi page tfolder
> on page 1 i save a fielda that i want to use as a filter
> on
> a tdbbrowse so only records matching that value of filedA
> are shown
>
> cant find good samples of set filter...
> tried harbor but get internal error
>
> thanks in advance
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
jemstv
Mensajes: 133
Registrado: Mar Jul 27, 2010 3:56 pm

need help with Filter

Mensaje por jemstv »

thanks for the reply..
is set filter the way to go or is set relation of the dbfs better?
is it possible to get an example of each? I cant find one in samples that i can follow
thanks
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9447
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

need help with Filter

Mensaje por ignacio »

Josemo,
oDbf:SetFilter( "NAME = 'JOHN'" )
Regards,
--
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info
http://www.xailer.com/forum
http://www.xailer.com/dokuwiki
"Josemo" <magjem[at]sbcglobal[dot]net> escribió en el mensaje de
noticias:4c97306a$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> thanks for the reply..
>
> is set filter the way to go or is set relation of the dbfs
> better?
>
> is it possible to get an example of each? I cant find one
> in samples that i can follow
>
> thanks
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Responder