I am trying to use a Decode Query to define a DataTable method which looks like this:
SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC),
'D', CONCAT('CLETS Query RECORD #', IDX),
'V', (SELECT CONCAT(CONCAT(CONCAT('***** LOI NEARBY EVENTS: ', AEVEN.NUM_1), ' TYPE: '), LOI_DATA.SOURCE) FROM aeven WHERE eid = LOI_DATA.IDX),
'S', (SELECT CONCAT('***** SPECIAL SITUATION *****: ', MSG) FROM SP_ST WHERE mslink = LOI_DATA.IDX)
)
FROM LOI_DATA
WHERE (LOI_DATA.EID=:EID)
Notice that I am using a parameter ":EID"
When I finish the TableAdapter Wizard I get this error:
Generated SELECT statement.
Error in list of function arguments: 'SELECT' not recognized.
Error in list of function arguments: ',' not recognized.
Error in list of function arguments: ')' not recognized.
Unable to parse query text.
In design view my TableAdapter method has no parameter: "GetComments()"
Anyone got an idea how to handle Decode queries? Is a parameterized decode query even supported? Can I circumvent the GUI and do it manually?
Thanx -Chabo