Hi, Mark - 

Using PB 2019 R3, I'm unable to reproduce the issue you are experiencing. I created a test external source DW data object that contains a string(5000) data column named "info". In a test window, I initialized the DW control in it's Constructor event with InsertRow(0). to create and see one row. In a command button is the following script:

Long ll_rc

dw_1.SetColumn("info")
ll_rc = dw_1.Paste()

MessageBox("Paste Results","RC = " + String(ll_rc))

Using Notepad++, I copied 4,412 characters of text from a file into the Windows Clipboard. Running the test app and clicking the command button to run the above script results in the following:

Showing that 4,412 characters were pasted into the DW's "info" data column, and I can see all of the pasted text in the column.

This test took only a few minutes to set up. Can you attempt to do same/similar with a new, external source DW and test window? If it works, then the problem you're experiencing in your app is in the DW, the data, or the code. You may need to provide some more, specific information as to the source of the data being copied (Word document, spreadsheet, etc.), the DWobject definition for the column object (from exported DW source, for example), and the code you are using to perform the paste operation.

Best regards, John

Hi Mark;

   How is that column defined in the DWO's "specification" pane?

Regards ... Chris

Did you make sure that either "Auto Horizontal Scroll" (or "Auto Vertical Scroll" for free form DW) is checked in the painter properties for that column?

Apart from all the good advice,

Edit the source code of your dw and check what's specified in the column's type. Probably char(1024) which you'll have to change to char(5000).

regards.

John,

When I recreate what you did with a new window and datawindow, I see the same behavior.  I get an ll_rc of 0.

Thanks,

Mark

Chris, Ronnie, and Miguel,

The specification pane shows Type of char(5000) and the datawindow source shows type=char(5000).  The datawindow is a tabular datawindow and I've tried with the column having the Auto Horizontal Scroll checked and unchecked (and all combinations with the Auto Vertical Scroll and Horizontal Scroll Bar and Vertical Scroll Bar checked / unchecked) and still experiencing same behavior.  Very odd.

Thanks,

Mark

Everyone,

Sorry for another message but I found a workaround.  Instead of having the users paste directly into the datawindow, I added a Paste command button which gets the value from the ClipBoard and does a SetItem with it.  That seems to be working.  Should've thought of that earlier.

Thanks for the responses!

Mark