Extracting RTF data in RecordSet

[neal0169]

Hi,

I'm trying to pull RTF data stored in an MSDE database in an ntext field using sql and I keep getting truncated results. As far as I can tell, I'm only getting the last approx. 80 characters from the db, which includes some RTF code.

I'm pulling other fields (some are ntext) and am having to problems with those, it's just the one stored as RTF.

I didn't design the database schema, I'm just trying to pull data already entered to keep from replicating steps.

Any help would be greatly appreciated.

BN

[neal0169]

I switched my connection type to ADO from RDO. That allowed me to pull the entire contents of the field into my VB code, however, I wasn't able to hold the value past a couple lines of code execution.

My remedy to that was to assign the value to a variable then close the connection. I actually had three fields that were necessary for my project that were of the nText type, so I repeated the steps outlined here three times in the code.

The next problem was the RTF codes in the results which I handled by pasting to a RichTextBox in my form, then writing the RichTextBox.Text value out to my finished php file.

This might all sound like hacking, but it works. If anyone has suggestions for making it a little more elegant, I'm all ears.