Hello,

I have added a memo field to the Opportunity Products and Add Opportunity products datagrids

System:Insert  Opportunity Common:

    'Extended Notes for proposals column
    Set col = grdProducts.Columns.Add(14)
    col.FieldName = "PROPOSAL" 'DNL
    col.Caption = Application.Translator.Localize("Ext Notes")
    col.Width = 40

The basic funtionality works and proposals are bing  produced however it became appearent that there were some issues.

1)When this field is clicked in the Opportunity Products grid an edit box appears contains the current memo data, a greyed out OK button that is activated if a text change is introduced, and a cancel button. If the user clicks outside of this edit box or another process gets focus this box simply dissapears along with any changes. Users are forced to click the OK button contantly so that their edit is not lost.

2) In the Add Opportunity Products grid this box appears to opperate in the same way. A user can add product and immediatly edit the extended desription. After clicking OK and retuning to the Opportunity Product grid, the edited data appears to be there but the database has not in fact been updated. I'm pretty sure I can find a way to fix this problem with a refresh somewere in the code.

My question is how can I get some control over this DataGrid Memo Edit sub-control and/or it's events? It would be a shame to have to abandon this built in functionality that is so close to working and start from scratch with some form of custoe memo edit window.

what version of SLX and what hot fixes???

You're on the Opp Products Grid and you're trying to change a Products.Proposal field????Can't do that......

If this is new OppProducts.Proposal field then there is a bunch of work to do with the out of the box Opp Products Recordset and grid.....a BUNCH of work.....

Thanks for the response,

Version: SLX 7.5.2.2151  - SP3

I did add a new database field of type memo (tdata) to both the Product and OpportunityProduct tables and yes, there are a dozen or so other small changes to record sets etc. When I started this I naively hit upon something called the Product Wizard and was able to add an edit windos for this memo field with virtually no supporting code. With that testing done I made the required changes to the Opportunity Product tab, developed the report and moved it to the live system. That’s when pricing behavior became an issue. It seems that the Product Wizard that was so easy to add an edit windows was from a time when price calculations were done differently in SLX.

Users scraped by with small workarounds but it was not very pleasing. That’s when I decided to add the fields to the product grid. At first I assumed that I would have to code an editing window but then found an article mentioning the addition of memo fields to grids as a type 14. I jumped on that and found it had built in editing! I pushed that to the live system and withdrew the Product Wizard only to find this issue with the built in edit window either having visibility turned off or the object getting nulled out with loss of focus.

I have been unable to find an event that would capture this so that the changes can be saved. Any loss of focus when the edit box is open causes the issue. An outlook meeting notification, an incoming phone call, or just clicking on a browser to get more information. Other than this editing issue everything else is working well.

The bottom right hand side illustrates the memo field edit box:

RUN SLXPROFILER and see what the SQL is doing....one issue is that memo fields can have quotes in them and I think SLX is firing off straight SQL UPDATE statements for a grid change.....but you will have to dig into the Opp Product Subsystem and debug this for your self. There are several how to's up here on the Opp Product RecordSet grid subsystem.....

Since editing and updating work as long as you stay in the edit box I'm pretty sure its not the memo fields content that is affecting it. Also I have a stand-alone program that pops a datagrid and adds a memo and even if it is empty it exibits the same behavior.

Since I can get no information on on this datagrid sub object's proporties or events I am biting the bullet and adding an edit window. Appearently this is a feature that is not actually used in SLX so never fully tested.

Thanks for the input.

I've used type=14 columns before and never noticed an issue....of course, I probably was sober enough to type INSIDE the box lines.....