cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
schuess3
Level: Powered On

Ant Keep Marching on Patch to New Azure SQL DB

Issue:

Data Source Never Gets Patched

 

Background

  • New Azure SQL DB
  • Connector was established using SQL Admin Credentials Defined when Database was Created
  • Patch Statement is: Patch('[dbo].[CPT_Codes]',Defaults('[dbo].[CPT_Codes]'),{CPT_Code:txtCPT_Code,CPT_Value:txtCPT_Value});Reset(txtCPT_Code);Reset(txtCPT_Value);
  • Ants keep marching across top of screen
  • No Errors 
  • No info

What can i check? Is this possibly a permissions thing cause I used the SQL Admin credentials? 

 

Update

I was able to successfully add data to the database table using the SubmitForm() method. So that confirms the account has the access I need. So my problem must relate to how I am trying to patch() the data.

 

More Updates

I was able to  get the Data Source Patched after creating a new login and user account on the DB with dbo rights. I will say that it sucks that you do not get a GUI Wizard when using SSMS with Azure SQL DBs. I am still fighting with some data source refreshes and unknown runtime errors but i am hoping that gets resolved. 

 

Thanks

Matt

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Ant Keep Marching on Patch to New Azure SQL DB

Hi @schuess3 ,

Have you solved your problem?

Does the txtCPT_Code, txtCPT_Value represent the Text Input box in your app?

 

If the txtCPT_Code, txtCPT_Value represents the Text Input box in your app, please modify your formula as below:

Patch(
'[dbo].[CPT_Codes]',
Defaults('[dbo].[CPT_Codes]'),
{
CPT_Code: txtCPT_Code.Text,
CPT_Value: txtCPT_Value.Text
}
);
Reset(txtCPT_Code);
Reset(txtCPT_Value);

or

Collect(
      '[dbo].[CPT_Codes]',
       {
         CPT_Code: txtCPT_Code.Text, 
         CPT_Value: txtCPT_Value.Text
       }
);
Reset(txtCPT_Code);
Reset(txtCPT_Value);

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Ant Keep Marching on Patch to New Azure SQL DB

Hi @schuess3 ,

Have you solved your problem?

Does the txtCPT_Code, txtCPT_Value represent the Text Input box in your app?

 

If the txtCPT_Code, txtCPT_Value represents the Text Input box in your app, please modify your formula as below:

Patch(
'[dbo].[CPT_Codes]',
Defaults('[dbo].[CPT_Codes]'),
{
CPT_Code: txtCPT_Code.Text,
CPT_Value: txtCPT_Value.Text
}
);
Reset(txtCPT_Code);
Reset(txtCPT_Value);

or

Collect(
      '[dbo].[CPT_Codes]',
       {
         CPT_Code: txtCPT_Code.Text, 
         CPT_Value: txtCPT_Value.Text
       }
);
Reset(txtCPT_Code);
Reset(txtCPT_Value);

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

schuess3
Level: Powered On

Re: Ant Keep Marching on Patch to New Azure SQL DB

Missing the .text was part of the unknown runtime error. And the bulk of the original issue was a SQL Database permissions issue. 

 

Thanks.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 91 members 3,030 guests
Please welcome our newest community members: