Multi-Step Error
Posted: Tue 17 Jun 2008 17:13
Using Delphi 7, sDac 4.50.35
Microsoft SQL Server: 09.00.3054
Microsoft SQL Native Client: 9.00.3042.00
No other code changes, just updated from 4.35.
I am getting this when posting a record, but only if I modify a memo field (defined as a tfmtMemo, used as RTF, attached to another third party component, but that is common in most of my forms) before posting.
Any ideas where I should look?
The RECUID is defined as autoinc in the table definition.
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Parameter[19] :RecUID - invalid ParamType (Status = 1h).
Here is the log from dbmonitor from the post event.
C:\Bin62\sme5.exe
C:\Borland\Delphi7\Bin\delphi32.exe
6/17/2008 9:31:09 AM n/a SQL Server monitoring is started. Complete
6/17/2008 9:31:09 AM 0:0.187 Connect: @ Complete
6/17/2008 9:51:39 AM n/a SQL Execute: INSERT INTO Issue
(UID, Article, Priority, Title, Problem, AssignedTo, NotifyCustomer, DateIn, Closed, HitCount, Modified, Assigned, WhoEdit, EditDateTime, EditCount, EditModule, New, TakenByUID, TakenBy)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SET ? = SCOPE_IDENTITY()
:UID(String[20],IN)='CI061708095133203002'
:Article(LargeInt,IN)=16
:Priority(Integer,IN)=0
:Title(String[1],IN)='a'
:Problem(FmtMemo,IN)={\rtf1\ansi\ansicpg0\uc1\deff0\deflang0\deflangfe0{\fonttbl{\f0\fnil Arial;}{\f1\fnil\fcharset0 Arial;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\s0\fi0\li0\ql\ri0\sb0\sa0 Left;}{\*\cs1\f0\fs20 Normal;}}
\uc1
\pard\s0\fi0\li0\ql\ri0\sb0\sa0\itap0 \plain \cs1\f0\fs20 a\par}
:AssignedTo(String[0],IN)=''
:NotifyCustomer(Boolean,IN)=False
:DateIn(DateTime,IN)=6/17/2008
:Closed(Boolean,IN)=False
:HitCount(Integer,IN)=0
:Modified(Boolean,IN)=False
:Assigned(Boolean,IN)=False
:WhoEdit(String[5],IN)='ADMIN'
:EditDateTime(DateTime,IN)=6/17/2008 9:51:39 AM
:EditCount(Integer,IN)=1
:EditModule(String[17],IN)='Issues 6.2.10.106'
:New(Boolean,IN)=False
:TakenByUID(String[5],IN)='ADMIN'
:TakenBy(String[13],IN)='Administrator'
:RecUID(LargeInt,IN/OUT)= Error
Microsoft SQL Server: 09.00.3054
Microsoft SQL Native Client: 9.00.3042.00
No other code changes, just updated from 4.35.
I am getting this when posting a record, but only if I modify a memo field (defined as a tfmtMemo, used as RTF, attached to another third party component, but that is common in most of my forms) before posting.
Any ideas where I should look?
The RECUID is defined as autoinc in the table definition.
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Parameter[19] :RecUID - invalid ParamType (Status = 1h).
Here is the log from dbmonitor from the post event.
C:\Bin62\sme5.exe
C:\Borland\Delphi7\Bin\delphi32.exe
6/17/2008 9:31:09 AM n/a SQL Server monitoring is started. Complete
6/17/2008 9:31:09 AM 0:0.187 Connect: @ Complete
6/17/2008 9:51:39 AM n/a SQL Execute: INSERT INTO Issue
(UID, Article, Priority, Title, Problem, AssignedTo, NotifyCustomer, DateIn, Closed, HitCount, Modified, Assigned, WhoEdit, EditDateTime, EditCount, EditModule, New, TakenByUID, TakenBy)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SET ? = SCOPE_IDENTITY()
:UID(String[20],IN)='CI061708095133203002'
:Article(LargeInt,IN)=16
:Priority(Integer,IN)=0
:Title(String[1],IN)='a'
:Problem(FmtMemo,IN)={\rtf1\ansi\ansicpg0\uc1\deff0\deflang0\deflangfe0{\fonttbl{\f0\fnil Arial;}{\f1\fnil\fcharset0 Arial;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\s0\fi0\li0\ql\ri0\sb0\sa0 Left;}{\*\cs1\f0\fs20 Normal;}}
\uc1
\pard\s0\fi0\li0\ql\ri0\sb0\sa0\itap0 \plain \cs1\f0\fs20 a\par}
:AssignedTo(String[0],IN)=''
:NotifyCustomer(Boolean,IN)=False
:DateIn(DateTime,IN)=6/17/2008
:Closed(Boolean,IN)=False
:HitCount(Integer,IN)=0
:Modified(Boolean,IN)=False
:Assigned(Boolean,IN)=False
:WhoEdit(String[5],IN)='ADMIN'
:EditDateTime(DateTime,IN)=6/17/2008 9:51:39 AM
:EditCount(Integer,IN)=1
:EditModule(String[17],IN)='Issues 6.2.10.106'
:New(Boolean,IN)=False
:TakenByUID(String[5],IN)='ADMIN'
:TakenBy(String[13],IN)='Administrator'
:RecUID(LargeInt,IN/OUT)= Error