inserting ntext from Visual Basic 6.0

[msilka]

I have a SQL 2000 database table with an ntext field.
I want to execute a stored procedure from VB 6.0 that will
insert a record into this table.

I created an ado command object in VB and appended the parameters for the fields which I will be inserting.

For the ntext field what is the TYPE variable for the CreateParameter statement?

Thank you

 

[NoCoolHandle]

I think you are looking for adWChar or adVarWChar where the W stands for Wide or 2byte character..

There is also an adLongChar and adLongVarWchar, but I think it is the adWChar you need..

HTH

Rob

 

[msilka]

Thank you,

That did the trick.