>>>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?<<
>
>I am using MSORCL10.DLL Version 2.00.006325 dated 1/7/97 -- an older one obviously. A client is using the Intersolv Oracle driver (version?) with success. What is the data type of 'Begin_Date'
>
>Kevin

Begin_Date is a date field, but I am getting the error on the creation of the view. The error {#1463] returned is "No Result Set has been returned by the server." Creating is only supposed to establish the view structure and ignore any parameters with respect to the data type. The data type of the parameter is determined when the view is actually used. I think I will try it by initializing the parameter with an Oracle formatted date [e.g., '30-MAY-99'].