StrataFrame Forum

RE: Issue with _Insert and _Update

http://forum.strataframe.net/Topic33615.aspx

By Sean Kelly - 3/6/2024

i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA