FYI I am using DWCS4 with all the latest extension relevant to what I am trying to accomplish.
I added the fields to the ps3_products table with some data. I also added the new form fields to the Product_Insert page via code view. Now, when I attempt to edit the Products_Insert page by clicking on the Insert Record (ps3_products) server behavior, the data assist extension opens fine, but it cannot locate the database table in question. That is, in the General Configuration database area of the window I see:
Trigger: Button insert pressed
Table: ***No Table Found
and there are no tables to choose from in the drop down menu.
As you would expect with the above:
The session variable key column is blank ("no column found" is available in the drop down
Store As: WADA_Insert_Products
I know the Product_Insert page worked fine (prior to any changes), so I am unclear why data assist cannot find the table. This is the first time I have tried to access the server behavior though. When I close out of the extension window, the appropriate area of code is highlighted, and it looks like what needs to be edited, but I would prefer to use the extension.
When I get this to work I will edit the Product_Update page.
As a side note, it takes a long time (3-5 minutes) for the extension to open. I see a blank insert record wizard window and a file activity window until the extension finally opens. Most of the time the file activity window is "not-responding" until it wakes up, and sometimes it goes back and forth bewteen responding and not responding.
Another FYI, there are a number of record set and dynamic list menu server behaviors (especially on the product_update page) with the red exclamation point, and I have not edited this page yet. Shouldn't these be resolved at some point too?
Any help with any of the above would be greatly appreciated.