>Has any successfully created a remote view of an Oracle table using a parameter on a date field? I have tried putting
where Oracle_Table_Name.Begin_Date > ?lcBgnDate and get a return error of "No Result Set has been returned by the server."
>
>But if I actually put
...Begin_Date > '10/01/1995', I get a result set.
>
>Any success with this out there?
Just a shot in the dark, but is there any chance that something is getting lost in the translation of the date? Are you using DTOC() to get your character date, and if so, are you sure that DTOC is returning the date in the format you expect?
Erik Moore
Clientelligence