Database CRUD (Create, Read, Update, Delete): Maintain Products

  • Saved Searches
  • Device:
  • Language:
  • About This App

    Database CRUD (Create, Read, Update, Delete)

    This Database CRUD application lets you maintain products in the database. You can view, edit, copy, delete, or add records with this application. Additionally, the database CRUD application comes with sorting, searching, and pagination capabilities already built in.

    Features

      Use any of these buttons to modify records in your database. The buttons are labeled, in order: View, Update, Copy, and Delete. This icon, found at the end of the navigation window, allows you to insert new records into the table. This database CRUD application includes row and page counters, which let you quickly and easily move through the data set. You can click a column heading to resort the data based on that column. The Database CRUD application comes with advanced search built in. Filter the rows by selecting a column relationship and entering a value into the column heading input. Type a few letters into any column heading input and the Database creates a real-time list of possible valid matching values. You have the option of changing the number of records displayed per page.
  • Learn More

    Learn More

    This application was built with m-Power, an easy-to-use web application development platform. To learn more about m-Power, click one of the buttons below.

    The m-Power Test Drive lets you use m-Power via the web, guiding you through the creation of two web applications. To demonstrate m-Power's capabilities, we'll build you a free proof-of-concept application using your own data. Do you have any questions or would you like more information? Fill out this short form.

    0 Items       Page 1 of 0       Page Size     Add
? Sort Ascending   Sort Descending  Product #
Sort Ascending   Sort Descending  Product Desc.
Sort Ascending   Sort Descending  Class
Sort Ascending   Sort Descending  Active?
Sort Ascending   Sort Descending  Weight
Sort Ascending   Sort Descending  Price
Sort Ascending   Sort Descending  Country


******M00020 Catched Infomation:

getprepareStatement
Catched Error: java.sql.SQLException: [SQL0204] DMPMP100 in CBB2E type *FILE not found.
beforeFirst-sql=SELECT COUNT(*) FROM "CBB2E"."DMPMP100" T01 LEFT OUTER JOIN "CBB2E"."COUNTRIES" T02 ON T01.COUNTRYOR=T02.COUNTRY_CO
Catched Error: getprepareStatement failed
getprepareStatement
Catched Error: java.sql.SQLException: [SQL0204] DMPMP100 in CBB2E type *FILE not found.
beforeFirst-sql=SELECT T01."PRDNO" AS SORT_COL_0,T01."ACTIVEPROD",T01."CLASS",T01."UTMES",T01."MWGHT",T01."LSTPC",T01."COUNTRYOR",T02."COUNTRY99",T01."LSTREVDATE",T01."DESCP",T01."LONGDESCRI",T01."SGVND" FROM "CBB2E"."DMPMP100" T01 LEFT OUTER JOIN "CBB2E"."COUNTRIES" T02 ON T01.COUNTRYOR=T02.COUNTRY_CO ORDER BY SORT_COL_0 ASC OPTIMIZE FOR 10 ROWS
Catched Error: getprepareStatement failed

******End Catched information