Premium Only Content
My Hybrid Shopping List -- "Interim" Collections and Persisted Tables- Revised
During final prepping of the previous version, I botched part of the video. Corrected in this version.
====
This video is Part Four of a four-part series:
Part Four explores two functions needed to make the Shopping List work:
-- Persisted tables in the SQL Azure database to retain the current shopping cart between sessions
and
-- The Patch() command for both data insertion and data update.
We wrap up with a look at the final step: moving purchased items from the shopping cart to the permanent database tables in Access.
Part One introduces the concept of Hybrid Access/PowerApps applications and explains why Access developers need to learn more about this approach.
Part Two lets you experience the PowerApps interface, running in a browser. It explains the concept of PowerApps collections -- which can be compared to temporary, in-memory tables.
In Part Two, the emphasis is on using a collection to retrieve a mirror image of a table in the SQL Azure database to improve performance with large recordsets and minimize calls to the server for data.
Part Three explores Filtering and Searching a Collection to return the minimum number of records from that collection to the Items in a Gallery. The final step is Sorting the remaining, filtered set of records for the Gallery. Two approaches to filtering are shown and compared for verbosity and performance.
-
20:28
Nikko Ortiz
20 hours agoShooting Extremely Expensive Guns
171K13 -
8:32
MattMorseTV
17 hours ago $23.99 earnedSchumer just TORCHED $90,000,000,000.
36.8K77 -
51:25
The Connect: With Johnny Mitchell
1 day ago $62.70 earnedInside The REAL Narco State: The Colombian Drug Cartels DOMINATING The Global Cocaine Trade
125K38 -
12:09
GritsGG
18 hours agoTook Down a Cheater on Rebirth To Achieve Victory!
29.5K -
14:12
BlabberingCollector
21 hours agoHBO Show Update, Audible Full Cast Ensemble Updates, Wizarding World Quick Hits!
45.8K2 -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
303 watching -
31:30
The Why Files
7 days agoCodex Gigas | The Devil's Bible and the Nazi Hole to Hell
195K86 -
1:05:26
Man in America
21 hours ago“Poseidon” Doomsday Sub, Microplastics & The War on Testosterone w/ Kim Bright
114K11 -
1:05:57
Sarah Westall
14 hours agoThe Story the DOJ, the FBI and the Media doesn’t want you to Know w/ Christina Bobb
69.7K16 -
2:16:01
IsaiahLCarter
1 day ago $20.67 earnedGraham Linehan: A Mess of Courage and Conviction || APOSTATE RADIO 034
48.1K1