Clarion ODBC driver and date comparisons

questions
1

Using Clarions’s ODBC driver through RazorSQL, and having trouble finding any real help anywhere. Muddling through. Trying to find the correct syntax to filter a dataset against a date value. Seem simple, just cannot get the driver to accept anything as yet. Help?

2

finally found it: … where MyField >= {d ‘2016-01-01’}

1 Like
3

Escape Sequences in ODBC -

Date, Time, and Timestamp Literals

https://msdn.microsoft.com/en-us/library/ms710282(v=vs.85).aspx

1 Like