Announcements
Patch('[dbo].[t_sst_AccessList]', Defaults('[dbo].[t_sst_AccessList]',{Name: TextInput4.Text, eMail: TextInput5.Text})
I'm trying to use Patch with 2 textboxes on a form and insert record into sql server via a button ?
Dave
@Anonymous
You appear to be a missing a single bracket.
Patch('[dbo].[t_sst_AccessList]', Defaults('[dbo].[t_sst_AccessList]'),{Name: TextInput4.Text, eMail: TextInput5.Text})
If this does not solve the issue can you please tell me what is happening when you attempt to PATCH? Does a new record get created? Is data missing?
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
missing bracket and thanks !!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 220 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 139