Database Table Maintenance 2

6933

About This Space

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

Last updated on December 18, 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

11587

Connect 4 App

Have some fun with this Connect 4 application!

klaw

Alex

11378

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

10561

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

8627

Consuming a Web Service

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

klaw

7726

Consuming a Web Service 2

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

klaw

7629

Database Table Lookup 3

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

klaw

7550

Database Table Lookup 2

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

klaw

7530

Focus Demo

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

klaw

7310

Database Table Lookup

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

klaw

7199

Consuming a Web Service 3

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

klaw

7176

Database Table Maintenance

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

klaw

7027