DSXchange

I do not have much SQL knowledge so I need some help please. I have a SQL statement within a Server routine and I call the DSExecute command but within the statement I only want to bring back 1 answer I know there is the ROWNUM but it does not seem to like it If this ROWNUM is correct do I put it in...

Seem to have sorted the problem.

Its in the wrong table space so this may sort it

There are double quotes within a set of single quotes.
The double quotes denote that we are using a variable and placing it in the SQL statement.

The pipe does not seem to be the problem as we also have the same style of SQL statement in another routine (which works) and it brings back the correct info.

The entry parameters are InCurrencyFrom InCurrencyTo InTransactionDate This is the Code CurrencyFrom = Trimf(Trimb(InCurrencyFrom)) If Trimf(Trimb(InCurrencyTo)) = '' OR IsNull(Trimf(Trimb(InCurrencyTo))) Then CurrencyTo = 'USD' End Else CurrencyTo = Trimf(Trimb(InCurrencyTo)) End If Trimf(Trimb(InT...

I have the following SQL running witin a server routine but I keep getting an error. Has anyone any ideas. The SQL is "SELECT J_C1CRR , '|', J_C1CRRD FROM PS_JWS_F1113 WHERE ROWNUM = 1 AND J_C1RTTY = 'S' AND J_C1CRCD = '":CurrencyFrom:"' AND J_C1CRDC = '":CurrencyTo:"' AND J...