You cannot use {^?} as a placeholder for a string containing a date. You also don't do note='?' to marshal a string parameter through ODBC. ODBC parameters don't work that way as substitution into the string. You need to simply use ? in the SQL Command, like you do for notes=? and cust_id=?. And while you use string and perhaps an numeric var for those, you need a date or datetime var vor that date parameter then.
The other option you have is not use ? at all for the date, but put in the full date string in your sql command, the second format Cyril showed would work. The general country independant format is the format with - instead of /, that is {^YYYY-MM-DD HH:MM:SS} for a datetime or {^YYYY-MM-DD} for a date. You surely can use string formatting to get from a date to that format.
Bye, Olaf.
Main Topics
Browse All Topics





by: CaptainCyrilPosted on 2009-08-11 at 22:59:54ID: 25076033
Let the format be {99/99/9999} or {^9999/99/99}. One of them should work.