Skip to Content

WEBI sql to regulat SQL (ORACLE)

Hello All,

I am in the process to build an exchel file that is connected to the DB and automatically updates some tables.

I made a 'select' tab where I have inserted the queries that VBA is find. I copied and pasted the queries from the BO, yet the message is that 'From keyword not found where expected'.

I tried to clean the webi sql, but it does not working.

ie.

SELECT (STOCK_PRICES_adj_0.TRADE_DAY), TRIM(SSP.STOCKS.ISINCODE), TRIM(SSP.STOCKS.ASHSCODE) FROM SSP.STOCK_PRICES STOCK_PRICES_adj_0, SSP.STOCKS, SSP.STOCK_MARKET_REL STOCK_MARKET_REL2 WHERE ( (STOCK_PRICES_adj_0.STOCKS_CODE=SSP.STOCKS.CODE AND STOCK_PRICES_adj_0.ADJUST_TYPE = 0) ) AND ( STOCK_MARKET_REL2.STOCKS_CODE=SSP.STOCKS.CODE ) AND ( ( ( decode(SSP.STOCKS.STATUS,0,'Ενεργή',1,'Παροπλισμένη','Αγνωστο') ) = 'Ενεργή' AND ( SSP.STOCKS.DATE_WITHDRAWN ) IS NULL ) AND STOCK_MARKET_REL2.STOCK_MARKETS_CODE IN ( '1' ) AND STOCK_PRICES_adj_0.DATE_OF_TRADE BETWEEN to_date(@Prompt('Εναρξη Περιόδου','D',,,)) AND to_date(@Prompt('Λήξη Περιόδου','D',,,)) )

any omment here?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 07, 2019 at 09:28 PM

    1st.: there is , missing after FROM SSP.STOCK_PRICES

    2nd.: If you do not use SQL in BO, @prompt will not work. (it is BO specific)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.