ihave input field of date doamin


and i want fidn the record in table with that date


i have written some thing like this..

select tccom001.date
from tccom001
where tcccom001.date = { input.date}


input date has same domain as tabel field


its giving errror during comp[ilation

Type mismatch combined non combined

sory

the code is


where tccom001 = {:input.date }

Hi,

the curly braces in the where condition are used with combined fields, so simply try:

where tccom001.date = :input.date

Regards,
Juergen

Hi,

As Juergen said, try without the curly braces. This rule varies based on Porting Set.

e.g. For Porting Set 8.9a.01 it will compile but in 8.4a,01 it won't.

Thanks Juergen and bhushan

It resolved