Issue with _Insert and _Update


Author
Message
Sean Kelly
Sean Kelly
StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
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


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Sean Kelly - 8 Months Ago
Trent L. Taylor - 8 Months Ago
Edhy Rijo - 8 Months Ago
Sean Kelly - 8 Months Ago
                     Shawn, Did you regenerate the BO from the BOM?
Edhy Rijo - 8 Months Ago
                         I was going to have you do that very thing next, have you rebuilt the...
Trent L. Taylor - 8 Months Ago
                             Also, in my case, just opening and loading the BOM takes several...
Edhy Rijo - 8 Months Ago
                         yes... if you mean Rebuild
Sean Kelly - 8 Months Ago
                             And i should add... that Larry had me run the DDT outside of VS... as...
Sean Kelly - 8 Months Ago
                                 Yes, that is correct. Do you CRUD settings look something like this:...
Trent L. Taylor - 8 Months Ago
                                     Wow. It's both embarrassing AND a relief. Thank you both for helping...
Sean Kelly - 8 Months Ago
                                         LOL...I am 30+ years in and I just made a rookie mistake 10 minutes...
Trent L. Taylor - 8 Months Ago
Sean Kelly - 8 Months Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search