Database Table Maintenance

7076

About This Space

This is a full database maintenance CRUD application with view, change, add, and delete capabilities

Last updated on November 19, 2019

Public Permissions: View Open/Fork Run Comment

Database Table Maintenance

This template illustrates a basic database maintenance CRUD application. It utilizes a Rich Display File with multiple screens.

API

pjs.query() - Execute an SQL query
pjs.defineDisplay() - Create a Rich Display object from json definition
display.screen.execute() - Display a screen and wait for user to respond
display.grid.replaceRecords() - Clear and add records to a Rich Display Grid

Be the first to comment:

Comments

Write Preview Markdown: bold italic code link

Post

More Spaces By klaw (@klaw)

Filters:

Popular Recent

Connect 4 Multiplayer App

This is a variation on the Connect 4 App that will enable multiplayer support.

klaw

11642

Connect 4 App

Have some fun with this Connect 4 application!

klaw

Alex

11460

Creating Record Paging Buttons

Expanded version of the Grid template to add additional paging buttons and modify how the data is supplied to the Grid widget.

klaw

Alex

10639

How to set focus on screen re-display.

A Rich Display File application that stored the focus in a hidden field and uses that field to apply focus when the screen is re-drawn.

klaw

8694

Consuming a Web Service

This app consumes a web service and display the information in a grid

klaw

7783

Consuming a Web Service 2

This app consumes a web service and display the information in a grid

klaw

7683

Database Table Lookup 3

This interactive app prompts the user for key fields to lookup a database record and displays the results

klaw

7595

Database Table Lookup 2

This interactive app prompts the user for key fields to lookup a database record and displays the results

klaw

7584

Focus Demo

A simple Rich Display app that shows how to focus a widget via JavaScript

klaw

7344

Database Table Lookup

This interactive app prompts the user for key fields to lookup a database record and displays the results

klaw

7273

Consuming a Web Service 3

This app consumes a web service and display the information in a grid

klaw

7241

Database Table Maintenance 2

This is a full database maintenance CRUD application with view, change, add, and delete capabilities

klaw

6983