QTP Error - Bracketed options are not enclosed in one of (), {}, [], or <>.

[Stefan Thibeault]

Hello,

I made a change to a select statement in a QTP (PowerHouse  8.19.C4)
and got the following error:

Executing request ONE ...
-------------------------------------------------------------------------------
The permanent subfile will be overwritten.
   File:  WDC1015
-------------------------------------------------------------------------------
Bracketed options are not enclosed in one of (), {}, [], or <>.


RUN QTP.CURRENT.COGNOS;INFO="";  XL=" *PHLIBXL  *ORDBA
ORACLEXL.PUB.ORACLEM"
Program terminated in an error state. (CIERR 976)

I change this select from

SELECT IF EMP-STATUS = "AF"

to

SELECT IF EMP-STATUS = "AF" AND ( &
	(LEAVE-DATE-LEFT(1) GT 0  AND LEAVE-DATE-RET(1) EQ 0) OR &
	(LEAVE-DATE-LEFT(2) GT 0  AND LEAVE-DATE-RET(2) EQ 0) OR &
	(LEAVE-DATE-LEFT(3) GT 0  AND LEAVE-DATE-RET(3) EQ 0) OR &
	(LEAVE-DATE-LEFT(4) GT 0  AND LEAVE-DATE-RET(4) EQ 0) OR &
	(LEAVE-DATE-LEFT(5) GT 0  AND LEAVE-DATE-RET(5) EQ 0) OR &
	(LEAVE-DATE-LEFT(6) GT 0  AND LEAVE-DATE-RET(6) EQ 0) OR &
	(LEAVE-DATE-LEFT(7) GT 0  AND LEAVE-DATE-RET(7) EQ 0) OR &
	(LEAVE-DATE-LEFT(8) GT 0  AND LEAVE-DATE-RET(8) EQ 0) ) 

Does anyone have any ideas?


Thanks,

Stefan