how to call a custom query

From: Frank (farocc..otmail.com)
Date: Thu Feb 01 2007 - 11:33:26 EST

Next message: Malcolm Edgar: "Re: [ANN] New Web Site"

Previous message: Frank: "Re: New user PK id question"
Next in thread: Frank: "Re: how to call a custom query"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

I have the following raw query defined.
SELECT BSYDTAA.BSYPEMP.EMHSP#, BSYDTAA.BSYPEMP.EMYLNM,
BSYDTAA.BSYPEMP.EMYFNM, BSYDTAC.BPRPPCP.PCDEP4, BSYDTAC.BPRPPCP.PCLDDS,
BSYDTAA.BSYPEMP.EMEMP# AS EMEMP, BSYDTAA.BSYPEMP.EMWPH# AS WPHONE FROM
BSYDTAA.BSYPEMP, BSYDTAC.BPRPPCP WHERE BSYDTAA.BSYPEMP.EMHSP# =
BSYDTAC.BPRPPCP.PCHSP# AND BSYDTAA.BSYPEMP.EMDEP4 = BSYDTAC.BPRPPCP.PCDEP4
AND (BSYDTAA.BSYPEMP.EMHSP# IN (1,5)) AND (BSYDTAA.BSYPEMP.EMDOT=0)
AND EMEMP# = ?

How do I call this from code using the SelectQuery and passing in the value?

Thanks

Frank

Next message: Malcolm Edgar: "Re: [ANN] New Web Site"
Previous message: Frank: "Re: New user PK id question"
Next in thread: Frank: "Re: how to call a custom query"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Feb 01 2007 - 11:34:13 EST