Database Table Lookup 2

About This Space

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


Last updated on December 4, 2019

Public Permissions:   View   Open/Fork   Run   Comment  

Database Table Lookup Template

This template provides an example of a simple database inquiry and the use of database-driven components.

Database Driven Auto-Complete

The customer number textbox provides auto-complete functionality that shows available customer numbers, along with the corresponding customer names. The user simply starts typing into the box to see available choices.

Screenshot

This functionality is accomplished without any extra Node.js code thanks to the database-driven widget capabilities found in NodeRun. The textbox widget has the following properties set for auto-complete:

  • choices database table
  • choices options field
  • choices value field

Screenshot

Other properties can help further refine the auto-complete functionality:

  • choices selection criteria
  • choices parameter value
  • max choices
  • contains match
  • case sensitive

Retrieving Full Customer Information

Customer information is retrieved and then placed on the screen using pjs.query(), which accepts an SQL statement along with any parameters to bind to the SQL. The results of pjs.query() are returned into a JavaScript array without the need for a callback function. This simplifies top-down business application programming.

Controlling Visibility

Widgets on the screen can be bound to fields or variables within your Node.js code. For example, the "visibility" property of the widget that shows the Invalid Customer Number message was bound to a boolean field named invalid. Now, we can easily trigger the message from our Node.js code just by setting invalid to true or false.

API

Be the first to comment:      

Comments

Write Preview Markdown: bold italic code link
Post

More Spaces By klaw (@klaw)

Filters:

Popular Recent

An application with a sample database.

2142

0

0

An application to test the hardware failure in my mouse.

1945

0

0

Static HTML Hello World App

1926

0

0

A simple dashboard example that uses responsive design

2530

0

0

Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.

3319

0

0

A demo of how to build Rich Displays in the Visual Designer that integrate with external CSS and JavaScript file

2744

0

0

Stateless demo app, where the mobile client or the browser would control the flow of the application

2684

0

0

Displaying information in grids is fundamental to developing applications. This demo application displays a list of products in a grid.

3017

0

0

A simple app to be called from RPG. It leverages the node-isbn package to resolve ISBN numbers and get the book title

3532

0

0

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

3857

0

0

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

7228

0

3

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

8147

2

0