Re: Multiple-step OLE DB operation generated errors. Check each OLE DB status value
From: Zhuo (zli_at_micros.com)
Date: 02/17/05
- Previous message: yc: "Saving a array of bytes using ADO"
- In reply to: Brian Bushay TeamB: "Re: Multiple-step OLE DB operation generated errors. Check each OLE DB status value"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 17 Feb 2005 08:39:24 -0500
Thank you Brian. Your way works better. I found my problem. The order of
creating the paramters is important. It has to match with the SQL statement.
I created p4 first then p3. Once I switch the order, it works fine. (p3
should be :p3, that was a typo, when I post on this news group).
"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
> My guess is one of you parameters is of the incorrect type
> qry := TADOQuery.Create(self) ;
> qry.SQL.Text :='INSERT INTO LOGTABLE (SNOTES, SCODE, LID, SMODULE)VALUES
> (:p1, :p2, p3, :p4)';
> qry.Connection := ADOConnection1;
> qry.parameters.paraseSQL(qry.sql.text,true);
>
> qry.ExecSQL;
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com
- Previous message: yc: "Saving a array of bytes using ADO"
- In reply to: Brian Bushay TeamB: "Re: Multiple-step OLE DB operation generated errors. Check each OLE DB status value"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
