|
View previous topic :: View next topic
|
| Author |
Message |
saagu
New User
Joined: 15 May 2008
Posts: 41
Location: Chennai
|
|
|
|
Hi,
While inserting into a table, I am getting -181 (DATETIME value is not valid) error. I have lot of date and time fields in that table. Is there any way to know which column of the table is causing -181 issue? |
|
| Back to top |
|
 |
Ragav86
New User
Joined: 27 Jan 2010
Posts: 37
Location: chennai
|
|
|
|
up to my view its not possible to find the exact field which causing -181..
check whether all the value in valid range? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
if you would pull your head out of your butt and realize that
| Quote: |
| which column of the table is causing -181 issue? |
is the wrong perspective.
proper approach is:
which host variable is causing the problem? |
|
| Back to top |
|
|
AjmalMohammed
New User
Joined: 02 Jun 2010
Posts: 10
Location: My Cubicle, Hyderabad, India
|
|
|
|
Hi Saagu,
I suggest you download and install Abend Assist. Its a really cool application, helped me a lot solving sqlcode errors.
Good day  |
|
| Back to top |
|
|
|
|
