>Mark,
>
>I use parameterized views with dates all the time. For example one view has
>"Audit_.DATESCHED >= ?pdDateFrom AND Audit_.DATESCHED <= ?pdDateTo". The only thing that I may suggest is look at the passing of a date vs. a character.
>
>You said that "where Oracle_Table_Name.Begin_Date > ?lcBgnDate"
>doesn't work, but "...Begin_Date>'10/15/95' " does. I see characters instead of dates in your where clause. If I add hard coded dates to views (which I don't do anymore) I always use the FP syntax {10/15/95} to represent the date.
>
>I hope this helps a little considering all the help you passed along!
>
>Kevin
The problem is with the actual creation of the view. I am issuing a
Create SQL View ... as select ... from ... where Begin_Date > ?ldBgnDate ... . I get the error in the creation of the view. Ultimately it never gets created so I am never able to pass a date, character or otherwise. The variable, ldBgnDate, does not even exist when I try to create the view. This also happens if I try this via the view designer. I am using the most recent MS ODBC drivers for Oracle. What drivers do you use?
TIA.
Mark McCasland
Midlothian, TX USA