If rdTypeLONGVARCHAR is a SQL Server TEXT column (and I think it is) then
the answer is that you can't do this. RDO 1.x can't have "large" columns as
There is a binding threshold parameter which controls what is considered to
be "large" but in SQL Server you have CHAR and VARCHAR which can be up to
255 characters wide and then TEXT and IMAGE which are up to 2Gb wide.
To manipulate TEXT and IMAGE data you are supposed to use the GetChunk and
AppendChunk methods. (Note that there is a bug and if you use AppendChunk
you MUST assign a value to another (small) column at the same time or the
data won't be saved.)
If the data isn't too big (no more than the SQL statement length limit)
then you can usually construct a SQL Insert, Update or Exec statement and
use the Execute method on that.
Quote:> I'm trying to use RDO PreparedStatements to run SQL Server 6.5
> stored procedures. One of the stored procedures updates several fields
> in the database. I can't set the value of one of the parameters (whose
> type is rdTypeLONGVARCHAR) to a string -- Visual Basic tells me
> "Can't assign value to unbound parameter". The way I read this error
> message, I can't set a parameter corresponding to an SQL Server Text
> field. Is that correct? If so, then how should I update this field from
> RDO if I'm supposed to use stored procedures to access the database?