Let's say I just want to display every item description and quantity in a html window called by a custom POS button. How would I use SQL within the html file to do this? I tried to pare down the drilldown.htm file, but I hit too many bumps in the road and finally gave up. I hope someone can give me a simple example so I can move forward.
I just want to display the results of:
SELECT description, quantity FROM Item