using autosearch value in a calculation expression

rbuser

Hi everyone !

I need to do this :

SELECT .......... , ............,
(case when EXISTS ( SELECT filiere FROM dossier
WHERE filiere <> dossier.filiere
AND DossierN° = REPORT.AUTOSEARCHFIELD[1] )
then 0 ELSE filierel END)
FROM .............

my probleme is to use an autosearch value for the case field.

thanks in advance

nicocizik

Hi Emmanuel,

Are you working in DADE? If so, the use of AutoSearch fields inside a
subselect is not currently supported. If you are creating the autosearch
fields manually in Delphi, take a look at the demo located in the
\RBuilder\Demos\5. AutoSearch\3. AutoSearch Field to SQL Where Clause\...
directory. This example shows how to change the actual SQL in your dataset
based on an AutoSearch field value.

--