The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Getting error when Passed macro in Read database operator for comparison
sgnarkhede2016
Member Posts: 152 
Contributor II
in Help
Hello,
I have account_info_date in format "01/01/2016 00:00:00 AM IST"
SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION
WHERE INSTITUTION_ID=%{institution_id} and ACCOUNT_INFO_DATE=%{account_info_date}
Getting missing right parenthesis or SQL not ended properly error
I have account_info_date in format "01/01/2016 00:00:00 AM IST"
SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION
WHERE INSTITUTION_ID=%{institution_id} and ACCOUNT_INFO_DATE=%{account_info_date}
Getting missing right parenthesis or SQL not ended properly error
0
Best Answer
-
jwpfau
Employee-RapidMiner, Member Posts: 303 
RM Engineering
Hi,
can you try to put single quotes around the macros?SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE FROM FA_FIN_INDICATOR_COMPUTATION
WHERE INSTITUTION_ID='%{institution_id}' AND ACCOUNT_INFO_DATE='%{account_info_date}'
Greetings,
Jonas0
