I have a table in SQL with a field having a text datatype. The SQL database is administered by a VB Client that I don't have the source for. The text datatype field contains the text (7,300 characters) of a stored procedure that is parsed at runtime to generate a recordset for a crystal report. I have queried the record from VFP into a VFP cursor. I have made the necessary changes and am now trying to update the revised contents to the SQL table from whence it came. I get a -1 on the SQLEXEC. When I try to pass the text to the field, I get an error saying that the text string is greater than 128 characters. When I try to paste this into the SQL Query Analyzer, I get a message that text, and ntext values cannot be passed in the Query Analyzer. I'm trying to figure out how this text ever made it to the table in the first place (probably on an import). Anyway, anyone have any thoughts on how to do this from VFP.

I would be eternally grateful after I get about 8 hours continuous sleep after this one.

Thanks,

Bill