Hi All,

When I am creating a job of aquery, I am getting following error.

Query with extra select form can not be added to job.


Best regards


Pinakin

I have not been able to run a query from a job. Something to do with queries actually running in company 000. I've always created a new session and then placed that into a job instead.

Hi,

The query needs to have hardcoded values in the where clause if needed.
For example if your query is

select tiitm001.item
from tiitm001
where tiitm001.item >= tiitm001.item.f
and tiitm001.item <= tiitm001.item.t


You'll probably receive the message 'Query with extra select form can not be added to job.'

you need to change it to something like this

select tiitm001.item
from tiitm001
where tiitm001.item >= "ITM"
and tiitm001.item <= "ITMZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ"

or

|Open Range
select tiitm001.item
from tiitm001


This way the query can be added to a Job

Regards

Alex