Here's a sample that just throws it to a datagrid for testing:
Dim cn As OdbcConnection
cn = New OdbcConnection("Driver={Progress OpenEdge 10.2A driver};Host=yourhostname;PORT=yourport;DB=yourdatabasename;UID=youruserid;PWD=yourpassword")
'or create an ODBC dsn on the machine and use this -->...
Thanks for the replies. I've been at a loss so I removed the join condition from the query leaving just a simple query with the date condition... apparently the to_date has been working. FYI both these syntaxes work:
where AdSchedule.PublishDate = TO_DATE ('6/13/2011')
where...
Can someone tell me how to properly construct a date compare using the Progress 10.2A driver in VB .Net 2010 program. The code below does not cause an error but the result set is not filtered by the date criteria. The field is a DATE type on the Progress database, I've tried all sorts of date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.