Never mind, I thinks me found the problem with this old hacked up dbproc.
thanks anyway.
-----Original Message-----
From: Kevin Wilson
Sent: Friday, October 07, 2005 11:36 AM
To: Maxdb (E-mail)
Subject: Problem using TIME datatype in dbproc
Importance: High
Why does this return "Integrity constraint violation;-8006 POS(1) Data types
must be compatible"? The field in rectbl is a TIME datatype.
CREATE DBPROC SP_UPDATE_TIME(
IN REC_ID FIXED (10,0),
IN UPDTIME TIME
)
AS UPDATE MYDB.RECTBL SET UPDTIME = :UPDTIME WHERE REC_ID = :REC_ID;
Thanks for the help.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
