Then we'd all know for sure. The difference being that, apparently, it's adjusting properly between UK data format and US date format. I think that must be a bug. But then, of course, the user has to be careful not to open the query in Design View, and especially not to save it that way. Hi, I would like to set a simple criteria in a query. Does anyone has any idea what is the problem? Thank you for your help! This thread is locked.
You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit.
Dirk Goldgar. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Dirk Goldgar's post on October 16, Thank your for your answer! Yes No. Sorry this didn't help. Thanks for your feedback. All of my subqueries run fine, it's when I put them together that I get that error. I'm using an ODBC connection to build the data so I'm not sure how to set the precision or scale for the fields.
I am trying to run the following query and keep getting this error. This thread is locked. This code, using pypyodbc 1. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
Collectives on Stack Overflow. Learn more. Asked 6 years, 8 months ago. Active 6 years, 8 months ago. Viewed 2k times. I am using pypyodbc 1. I have also tried by using the delay of 0. Improve this question. Gord Thompson k 28 28 gold badges silver badges bronze badges. User User 2, 6 6 gold badges 32 32 silver badges 57 57 bronze badges. Add a comment. Active Oldest Votes. Improve this answer.
0コメント