Re: appendChunk method resulting in incorrect data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


<everymn@xxxxxxxxx> wrote in message
news:4l108393dgaevm0oo85chu54n9cgilsfog@xxxxxxxxxx
Ralph,

I don't see any difference in this behavior when I declare as
adFldLong.

Could you tell me where you found this description of Refresh. I've
only ever seen code where that method is used to with a Command whose
type is adCmdStoredProc. Here I'm just trying to populate parameters
of a Command that is adCmdText.

I just tried the following but when I look at the command object after
the Refresh, the properties collection has a count of 0

connection1.ConnectionString = strConn
connection1.CursorLocation = adUseClient
connection1.Open

Set Command1 = New ADODB.Command
strSQL = "UPDATE ado_test SET C29 = ? WHERE C1 = ?"
Set Command1.ActiveConnection = connection1
Command1.CommandText = strSQL
Command1.CommandType = adCmdText
Command1.Parameters.Refresh

Should this work? If so then we might have a problem with our driver
not returning the data properly.
Thanks
Eric


I apparently missed that you were using not using a SP.

I don't think you can use ApppendChuck with adCmdText. But I don't know for
sure, only that I have never tried it. It has worked for me using a SP, with
Set NoCount Off, adFldLong, and adCmdStoredProc.

AppendChuck behavior has always been a bit squirrelly and very dependent on
the specific Provider and data access library versions.

Listen to Mr. Howe. He's the local expert.

Not sure where I grabbed the quote from. It comes for a loose assortment of
notes I have taken through the years. I am always embarrassed about not
providing proper credit.

-ralph


.

Relevant Pages