122
Hello,
I added two fields to a custom screen and it seems to read them from the database perfectly. (I followed the tutorial here: http://www.boyerassoc.com/adding-custom-fields-screen-dynamics-sl/.)
However, when I fill the fields in and save, it doesn't seem to be saving back to the database. Can anyone point me to why? I did not have to use an extension table, just two custom fields in a table that was already connected.
Thanks.
*This post is locked for comments
Worked like a champ. Thanks!
Yes, if you requiered insert or update the information, you must have the code...
good luck
I'm only trying to update xhr_employee. So you're saying I need to create the Update1_OnUpdate function and put SQL in there to update the table? I know the record exists so there's no need to check (it has to exist for the screen to work).
Set Customize Level to "All Users" and check again.
If the code is missing, add code in Update1_OnUpdate
1. Check if exists the register on Table (xhr_training)
1.1 If exist use SUpdate1
1.2 If not exist use SInsert1
2. Check if exists the register on Table (xhr_employee )
2.1 If exist use SUpdate1
2.2 If not exist use SInsert1
*This functions are VB Tools for SL
Hello Noe,
That sounds like it exactly. However, I don't see that function. When I go into Customize mode and go into the Visual Basic Editor, there is no Update1_OnUpdate function. I see where I can create it, but it's not there now (and items in the grid are updating fine).
Am I looking in the wrong place?
Hi, you have a extended table.
In Customize Mode, check the code section "Update1_OnUpdate" in this section you must have SINSERT to save data or maybe you have a SQL Script to Insert.
If you have a SQL Script verify the parameters.
The customization had to have saved since the fields are showing on the screen. I will attempt to remove them and put them back and see if I have any luck. I also manage the database so I can definitely tell that the fields aren't being updated.
When you have done some customization on the screen at the end you have to save your changes, maybe they were not saved. you can get the customizations out of the screen when you are in customization mode, there is a tab in the left corner that it says customization, then you clic on it and it displays some options one of them says remove customizations from the screen. And you can check the database with your data base administrator, you can make a query and make sure of it's updating the fields within the database.
I'm not really sure how to get the customization out of there now. The good news is it doesn't appear it was customized before (I was able to pull an old version and there's no *). How can I verify if the table is or isn't getting updated when the screen is saved?
Oh man, you have done exactly that is necessary, you can restart the dynamics sl or clean your customization and do it over, it would be easier for me if I could see your project
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
232,011
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
