Forums
This topic is locked
using dwmx with sql200 can't display ntext field
Posted 09 Jul 2003 18:55:19
1
has voted
09 Jul 2003 18:55:19 david j johnson posted:
I am inserting and updateing records in an sql 2000 database and can display all of my data dynamically except the ntext field. It is blank. How do you make it visible. Replies
Replied 24 Jul 2003 01:44:07
24 Jul 2003 01:44:07 Marcellino Bommezijn replied:
This could be caused by using the datatype "ntext" for this field which is a unicode version of the "text" datatype. You will need to specify the CursorLocation property as a client-side cursor rather than the default server-side cursor.
Replied 25 Jul 2003 17:28:51
25 Jul 2003 17:28:51 Geoff Thomas replied:
Put the ntext fields as the last fields in your sql select statement. I also like using the DW memo text formatting extension