Versions Compared

Old Version 6

changes.mady.by.user Eliot Muir

Saved on

compared with

New Version 7

changes.mady.by.user Eliot Muir

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleHow would I modify the source of the data being served up?

Look at APP/APPpull.lua to see how the data needs to be formatted.

In a real application you would most likely be querying the data from a SQL database and then formatting it in the same way as the application.

If you want to add additional web services then edit this code from main:

Code Block
local APPaction={}
APPaction["/"] = APProot
APPaction["/ExcelExport.xlsm"] = APPspreadSheet
APPaction["/push"]             = APPpush
APPaction["/pull"]             = APPpull

And define additional functions.

You can specify which table to populate in excel by editing the Table column entry in the Query table. That can be done purely in excel without altering the back end code.

Image Added
Expand
titleWhy does the code use a non standard escaping format for special characters?

Writing code in Visual Basic for Applications is challenging, so I chose a format that’s simple to parse and generate in VB, avoiding the need for a complex parser.

Since we control both ends of the ‘pipe’ in this case it makes sense to do it this way.

...