Database Table Maintenance

7195

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

Database Table Lookup

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

klaw

7400

klaw widget sets

Empty template with the basics set up for a quick display.

klaw

5906

Send Email

A demo application that uses the sendmail npm package to send an email.

klaw

6524

Simple Task List With Reset Button

This is a simple task list that stores tasks on a per user basis, and has a reset all button. Good for tasks that must be completed on a regular schedule like daily, weekly or monthly tasks.

klaw

6650

Static Hello World

Static HTML Hello World App

klaw

6536

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

8887

Consuming a Web Service 2

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

klaw

7807

Consuming a Web Service

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

klaw

7920

Connect 4 App

Have some fun with this Connect 4 application!

klaw

Alex

11612

Focus Demo

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

klaw

7463