John Baird
Coatesville, Pennsylvania, United States
General information
Title:
Date/Time and Parameterized views
I am using an access database as a remote source during the development of
an application using remote views. My problem is that access only allows
Date/Time as a field type, and I want to return a cursor using a
parameterized view based on a date.
IOW, I want the program to select all records from the access database into
a cursor base on a user entered date. If I enter a date, there is no
match, for I am not entering the time portion. If I enter the date and the
time portion, the cursor returns with values, but if I try just the date, I
get nothing.
I have tried using functions to convert the parameter, but I keep getting
ODBC errors indicating that they are unsupported functions.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only