Hi everyone,
I'm getting an error in Framework Manager when I execute the following:
This query contains an error and can not be executed.
select * from
(select A.CAR_ID from
CARS A )
It is recommended that you view the query feedback on the "Query Information" tab.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 4: Syntax error near "end-of-statement".
Is there something I'm missing?
Thx alot for your time
Quote from: gosoccer on 20 Nov 2015 09:43:36 AM
Hi everyone,
I'm getting an error in Framework Manager when I execute the following:
This query contains an error and can not be executed.
select * from
(select A.CAR_ID from
CARS A )
It is recommended that you view the query feedback on the "Query Information" tab.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 4: Syntax error near "end-of-statement".
Is there something I'm missing?
Thx alot for your time
Can you explain what you are trying to achieve?
MF.
I'm trying to show values from two rows into one row. Please see:
http://www.cognoise.com/index.php?topic=29468.new;topicseen#new
So, I went after using Select * from (select but getting error)
I have the following scenario:
Case ID Activity Date Updated
11111 Bill Paid 09/25/2015
11111 Received Bill 08/01/2015
Now, I need to show ON THE SAME ROW in Report Author:
CASE ID Current Activity Prior Activity Date Updated
11111 Bill Paid Received Bill 09/25/2015
So, Received Paid needs to show in the same Row showing the latest
information with the 09/25/2015 Date.
Thx for your time.