PDA

View Full Version : VDFQUERY - Expressions



Victor M. Diego
4-Oct-2007, 04:05 AM
Hi,
Anyone know how could I make a expression with "CONTAINS" or "IN" in order
to do a "Selection" with VDFQUERY ?
Similar to: (TABLE.Field CONTAINS "XXX")

Thanks,

--
Víctor M. Diego
A.T. MEDTRA, S.L.
Tfno: 34+ 942.23.51.41
e-mail: victor@atmedtra.es


************************************************** **************************
**************
AVISO IMPORTANTE
************************************************** **************************
**************
Este mensaje de correo electrónico y sus documentos adjuntos están dirigidos
EXCLUSIVAMENTE a los destinatarios especificados. La información contenida
puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente
refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO ya
que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o
copia de toda o alguna parte de la información contenida. Gracias.


This e-mail message and any attached files are intended SOLELY for the
addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY
PRIVILEGED information and may not necessarily represent the opinion of A.T.
MEDTRA, S.L. If you receive this message in ERROR, please immediately notify
the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
distribute, print or copy all or part of the contained information. Thank
you.
************************************************** **************************
**************

pkarminsky
4-Oct-2007, 11:50 AM
Hola Víctor

On Selection Tab, add the Table.Field, and in the operator list, select IN.
I have VdfQuery in Spanish, and the operator is "Incluye cadena (IN)"
I'm sending you an example snapshot

Regards
Pedro

"Victor M. Diego" <victor@atmedtra.es> escribió en el mensaje
news:UlMpdEmBIHA.2320@dacmail.dataaccess.com...
> Hi,
> Anyone know how could I make a expression with "CONTAINS" or "IN" in order
> to do a "Selection" with VDFQUERY ?
> Similar to: (TABLE.Field CONTAINS "XXX")
>
> Thanks,
>
> --
> Víctor M. Diego
> A.T. MEDTRA, S.L.
> Tfno: 34+ 942.23.51.41
> e-mail: victor@atmedtra.es
>
>
> ************************************************** **************************
> **************
> AVISO IMPORTANTE
> ************************************************** **************************
> **************
> Este mensaje de correo electrónico y sus documentos adjuntos están
> dirigidos
> EXCLUSIVAMENTE a los destinatarios especificados. La información contenida
> puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente
> refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
> ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO ya
> que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o
> copia de toda o alguna parte de la información contenida. Gracias.
>
>
> This e-mail message and any attached files are intended SOLELY for the
> addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY
> PRIVILEGED information and may not necessarily represent the opinion of
> A.T.
> MEDTRA, S.L. If you receive this message in ERROR, please immediately
> notify
> the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
> distribute, print or copy all or part of the contained information. Thank
> you.
> ************************************************** **************************
> **************
>
>
>
>
>

Peter van Mil
4-Oct-2007, 01:15 PM
Victor,

If you want to use expressions:

(Pos("XXX",TABLE.Field) > 0)

should work (not tested).

Peter van Mil

Victor M. Diego schreef:
> Hi,
> Anyone know how could I make a expression with "CONTAINS" or "IN" in order
> to do a "Selection" with VDFQUERY ?
> Similar to: (TABLE.Field CONTAINS "XXX")
>
> Thanks,
>

Victor M. Diego
8-Oct-2007, 06:36 AM
Thanks Pedro but I want to know how to do that in an expression (botton
expression) because I must use "OR" expressions.

Regards,
Victor


--
Víctor M. Diego
A.T. MEDTRA, S.L.
Tfno: 34+ 942.23.51.41
e-mail: victor@atmedtra.es


************************************************** **************************
**************
AVISO IMPORTANTE
************************************************** **************************
**************
Este mensaje de correo electrónico y sus documentos adjuntos están dirigidos
EXCLUSIVAMENTE a los destinatarios especificados. La información contenida
puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente
refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO ya
que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o
copia de toda o alguna parte de la información contenida. Gracias.


This e-mail message and any attached files are intended SOLELY for the
addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY
PRIVILEGED information and may not necessarily represent the opinion of A.T.
MEDTRA, S.L. If you receive this message in ERROR, please immediately notify
the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
distribute, print or copy all or part of the contained information. Thank
you.
************************************************** **************************
**************



"Pedro Karminsky" <pkarminsky@cantv.net> escribió en el mensaje
news:VYm1yaqBIHA.5772@dacmail.dataaccess.com...
> Hola Víctor
>
> On Selection Tab, add the Table.Field, and in the operator list, select
IN.
> I have VdfQuery in Spanish, and the operator is "Incluye cadena (IN)"
> I'm sending you an example snapshot
>
> Regards
> Pedro
>
> "Victor M. Diego" <victor@atmedtra.es> escribió en el mensaje
> news:UlMpdEmBIHA.2320@dacmail.dataaccess.com...
> > Hi,
> > Anyone know how could I make a expression with "CONTAINS" or "IN" in
order
> > to do a "Selection" with VDFQUERY ?
> > Similar to: (TABLE.Field CONTAINS "XXX")
> >
> > Thanks,
> >
> > --
> > Víctor M. Diego
> > A.T. MEDTRA, S.L.
> > Tfno: 34+ 942.23.51.41
> > e-mail: victor@atmedtra.es
> >
> >
> >
************************************************** **************************
> > **************
> > AVISO IMPORTANTE
> >
************************************************** **************************
> > **************
> > Este mensaje de correo electrónico y sus documentos adjuntos están
> > dirigidos
> > EXCLUSIVAMENTE a los destinatarios especificados. La información
contenida
> > puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no
necesariamente
> > refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
> > ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO
ya
> > que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión
o
> > copia de toda o alguna parte de la información contenida. Gracias.
> >
> >
> > This e-mail message and any attached files are intended SOLELY for the
> > addressee/s identified herein. It may contain CONFIDENTIAL and/or
LEGALLY
> > PRIVILEGED information and may not necessarily represent the opinion of
> > A.T.
> > MEDTRA, S.L. If you receive this message in ERROR, please immediately
> > notify
> > the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
> > distribute, print or copy all or part of the contained information.
Thank
> > you.
> >
************************************************** **************************
> > **************
> >
> >
> >
> >
> >
>
>
>

Victor M. Diego
8-Oct-2007, 06:42 AM
Thanks Peter, but that expression doesn't run. My version of VDFQuery
doesn't have the "POS" function.
Regards,

--
Víctor M. Diego
A.T. MEDTRA, S.L.
Tfno: 34+ 942.23.51.41
e-mail: victor@atmedtra.es


************************************************** **************************
**************
AVISO IMPORTANTE
************************************************** **************************
**************
Este mensaje de correo electrónico y sus documentos adjuntos están dirigidos
EXCLUSIVAMENTE a los destinatarios especificados. La información contenida
puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente
refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO ya
que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o
copia de toda o alguna parte de la información contenida. Gracias.


This e-mail message and any attached files are intended SOLELY for the
addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY
PRIVILEGED information and may not necessarily represent the opinion of A.T.
MEDTRA, S.L. If you receive this message in ERROR, please immediately notify
the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
distribute, print or copy all or part of the contained information. Thank
you.
************************************************** **************************
**************



"Peter van Mil" <peter@appvantage.nl> escribió en el mensaje
news:W13XFKrBIHA.2320@dacmail.dataaccess.com...
> Victor,
>
> If you want to use expressions:
>
> (Pos("XXX",TABLE.Field) > 0)
>
> should work (not tested).
>
> Peter van Mil
>
> Victor M. Diego schreef:
> > Hi,
> > Anyone know how could I make a expression with "CONTAINS" or "IN" in
order
> > to do a "Selection" with VDFQUERY ?
> > Similar to: (TABLE.Field CONTAINS "XXX")
> >
> > Thanks,
> >
>

Sture Andersen
8-Oct-2007, 06:43 AM
Hello Victor,

Add this line to procedure reset in vmachine.utl:

send declare_function "Pos" VARTYP_INTEGER "SS" FTYPE.BUILTIN 0 0 FG_STRING

Then you'll have a pos function in VDFQuery.

-Sture

PS! Make a note to yourself that you have edited the file so that you may
repeat the edit on new versions.

Peter van Mil
8-Oct-2007, 12:56 PM
Sture,

Wouldn't it be a good idea to add the POS function to the next version
of VDFQuery?

Regards,

Peter van Mil

Sture Andersen schreef:
> Hello Victor,
>
> Add this line to procedure reset in vmachine.utl:
>
> send declare_function "Pos" VARTYP_INTEGER "SS" FTYPE.BUILTIN 0 0 FG_STRING
>
> Then you'll have a pos function in VDFQuery.
>
> -Sture
>
> PS! Make a note to yourself that you have edited the file so that you may
> repeat the edit on new versions.
>
>

Sture Andersen
9-Oct-2007, 02:31 PM
Yes. Will do.

-Sture

Jim Rose
11-Oct-2007, 07:43 AM
(sigh!!) No rest for a Saint ............

Jim Rose


"Victor M. Diego" <victor@atmedtra.es> wrote in message
news:UlMpdEmBIHA.2320@dacmail.dataaccess.com...
> Hi,
> Anyone know how could I make a expression with "CONTAINS" or "IN" in order
> to do a "Selection" with VDFQUERY ?
> Similar to: (TABLE.Field CONTAINS "XXX")
>
> Thanks,
>
> --
> Víctor M. Diego
> A.T. MEDTRA, S.L.
> Tfno: 34+ 942.23.51.41
> e-mail: victor@atmedtra.es
>
>
>
************************************************** **************************
> **************
> AVISO IMPORTANTE
>
************************************************** **************************
> **************
> Este mensaje de correo electrónico y sus documentos adjuntos están
dirigidos
> EXCLUSIVAMENTE a los destinatarios especificados. La información contenida
> puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente
> refleja la opinión de A.T. MEDTRA, S.L. Si usted recibe este mensaje por
> ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMÍNELO ya
> que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o
> copia de toda o alguna parte de la información contenida. Gracias.
>
>
> This e-mail message and any attached files are intended SOLELY for the
> addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY
> PRIVILEGED information and may not necessarily represent the opinion of
A.T.
> MEDTRA, S.L. If you receive this message in ERROR, please immediately
notify
> the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose,
> distribute, print or copy all or part of the contained information. Thank
> you.
>
************************************************** **************************
> **************
>
>
>
>
>