UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Save Data On Powerapps On Premise Gateway    
 
   
carlo
post Sep 13 2019, 05:20 AM
Post#1



Posts: 98
Joined: 12-February 15



Hi

I have connect in pwa gataway SQL database.. to save records which command to use collect .. forall or patch???


thank

Carlo
Go to the top of the page
 
RobKoelmans
post Sep 13 2019, 06:29 AM
Post#2



Posts: 489
Joined: 25-November 14
From: Groningen, Netherlands


It's much better to work 3-tier between PA and SQL-server by Flow (for a whole collection of reasons).
Flow converts a collection automatically to JSON and you can write the JSON variable directly to SQL with Exec Query embedded in a statement that uses OpenJSON

Like: Insert into table1 (col1, col2) SELECT col1,col2 FROM OpenJson(@json);

Rob

Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st November 2019 - 09:21 AM