Re: appendChunk method resulting in incorrect data

Should this work?

Not sure. I know it works for SP's, not sure it works for adhoc commands (I
cannot remember whether I have tried it)
But then so far you have not said what your provider is.

Try changing your example to this, just for final checks

Command1.CommandText = strSQL
Command1.CommandType = adCmdText
Command1.Prepared = true
Command1.Parameters.Refresh

Are the parameters filled in?

Stephen Howe


.