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

[Joe Boyle]

but it could be because you can't have arrays in Oracle or any RDB.

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.


-----Original Message-----
From: Joe Boyle [mailto:atla38@dsl.pipex.com] 
Sent: 13 January 2005 17:32
To: 'Stefan Thibeault'; 'powerh-l@lists.sowder.com'
Subject: RE: QTP Error - Bracketed options are not enclosed in one of (),{},
[], or <>.

Just saw that the items are different, so nope, must be a bug.

Regards, Joe.


-----Original Message-----
From: Joe Boyle [mailto:atla38@dsl.pipex.com] 
Sent: 13 January 2005 17:30
To: 'Stefan Thibeault'; 'powerh-l@lists.sowder.com'
Subject: RE: QTP Error - Bracketed options are not enclosed in one of (),{},
[], or <>.

Could it be that qtp is aware that an item cannot be both gt 0 and = 0 at
the same time ?

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Stefan Thibeault
Sent: 13 January 2005 17:17
To: powerh-l@lists.sowder.com
Subject: QTP Error - Bracketed options are not enclosed in one of (),{}, [],
or <>.

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
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.