🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Getting error when Passed macro in Read database operator for comparison

User: "sgnarkhede2016"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "jwpfau"
    Altair Employee
    Accepted Answer
    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,
    Jonas