using autosearch value in a calculation expression
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com