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.
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
need help with Filter
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
- Site Admin
- Mensajes: 9447
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
need help with Filter
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
>
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
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
need help with Filter
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
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
- Site Admin
- Mensajes: 9447
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
need help with Filter
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
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
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com