Make sales order comments bigger

[DannyC]

OK, found the cause of the exception.

Unfortunately it was your code, not mine
Row comes first, then column.
so this works fine.

Code: Select all

((FarPoint.Win.Spread.CellType.TextCellType)_salesOrderForm.grdLines.ActiveSheet.Cells[Row, _salesOrderForm.grdLines.ActiveSheet.Columns["PartNo"].Index].CellType).MaxLength = 1000;

I can now physically enter in 1000 chars into the comments but as per OP they're not going to be entered by a user, the comments come from a quote. Moot point anyway.
When I save the sales order, I'm only left with the first 200 chars.

It's something on save that is doing it.

[Mike.Sheen]

OK, found the cause of the exception.

Unfortunately it was your code, not mine

Row comes first, then column.

Oops!

When I save the sales order, I'm only left with the first 200 chars.

It's something on save that is doing it.

Yep - I've checked the code for the save of the sales order line and this is the setting of the SQL Parameter for the comment text:

Code: Select all

SQLParam = New SqlParameter("@HistoryText_Comment", System.Data.SqlDbType.VarChar)
SQLParam.Value = Left(HistoryText, 200)
SQLCmd.Parameters.Add(SQLParam)

Maybe add a handler on SaveEnding and do a little loop issuing UPDATE SO_Lines SET HistoryText = '{SalesOrderLine.CommentText}' WHERE InvoiceLineID = '{SalesOrderLine.RecID}' for each line which is a comment line.

FWIW V8 does not truncate comments to 200 characters on save, and the DisplayLine method also does not set the MaxLength to 200, but Integer.MaxValue.

[DannyC]

add a handler on SaveEnding and do a little loop

Ah ha! That was the trick.

Really appreciate the help Mike.

[DannyC]

The attached plugin works OK to get the details from inventory & add it as a comment line to a quote.

I've discovered, after client had reported it still truncates to 200 chars, that when the partno is entered on the quote line, it correctly brings the Aux3 value into the quote.
I have been testing by hitting <tab> after the partno is entered, but they are in the practise of using <enter>, not <tab>.
Using <enter> jumps to the next line and puts the cursor into the partno field.

It's when the cursor is put in the PartNo field (now a comment) that the extended chars are truncated to 250 (or 255?) characters.

I've been fiddling about with different plugin code but I can't find the correct syntax for keeping the MaxLength at 1000 chars when the comment has focus.

Can you assist?