ADO Text field update

Results 1 to 2 of 2

Thread: ADO Text field update

  1. #1
    Join Date
    Dec 1969

    Default ADO Text field update

    I am unable to update a text column in an ms sql6.5 db using ado. I get a right string truncation error at 255 characters. I have tried to use appendchunk without success. I am using the command object and creating my parameters... The fundamental issue seems to be that ado doesn&#039t support the text datatype. If anyone has any info on this please let me know.

  2. #2
    Manoj Guest

    Default RE: ADO Text field update

    Change your stored procedures to accomodate Text fields. It needs specilized processing, plain Insert or Update doesn&#039t work with Text fields[If I am right]. There are functions such as WriteText etc..[Search on the MSDN for these fns.]<BR><BR>-Man

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts