I have asked this another way in another thread but after doing some reading and testing I can refine my problem.

I have a table with a text datatype field. The field presently contains all of the language for a stored procedure run by a VB client to generate a recordset for a report at runtime. I need to modify the language of this field. I cannot do it from the Query Analyzer because you cannot use ntext or text datatype in a Query Analyzer query. I try and run this from VFP with a SQLExec statement (where I retrieved the value of the field that was modified in the first place) and upon trying to update the field I retrieved, I get a -1 returned (meaning that it failed). I try and run it from Access 2000 using the SQLSpecific query screen and I get the same error as the Query Analyzer error. How do you get all of the text into the field programatically once you can get the field to a variable? FYI, the length of the field is 7263 characters, which is under the varchar(8000) limit, if that means anything.

Thanks,

Bill