Database interface creation system and method

A non-transitory computer readable storage medium embodying a computer program to execute a method for creating an interface to a database, wherein the database comprises a named table that includes a plurality of named fields, the method comprising:

• receiving, using a Launch Form module,
• a database connection string to define an identifier for the database,
• a target data object corresponding to the named table in the database,
• a Level 0 target corresponding to one of the plurality of named fields in the database defined as a Level 0 target named field,
• a Lines Below Level 0 variable, and
• at least one results line, equal in count to a value of the Lines Below Level 0 variable, and corresponding to a respective one of the plurality of named fields in the database defined as Below The Line named fields;
• creating, using the Launch Form module, a call that comprises query option parameters including the database connection string, the Level 0 target, and the at least one results line;
• initiating, using an Orbit Form module, data communication with the database using the database connection string;
• creating, using the Orbit Form module, at least one SQL script that includes the query option parameters of the call;
• executing, using the Orbit Form module, the at least one SQL script to retrieve from the database a working data set comprising at least one record that includes a plurality of structurally-related values including a Level 0 value retrieved from the Level 0 target named field and at least one Below The Line value retrieved from the Below The Line named fields;
• and
• displaying, using the Orbit Form module, a paging box corresponding to the Level 0 target.

A computer program product embodied in a non-transitory computer readable storage medium embodying a computer program for creating an interface to a database, wherein the database comprises a named table that includes a plurality of named fields;

• the computer program product comprising:
• a Launch Form module, and
• an Orbit Form module;
• wherein the Launch Form module comprises a first interface configured to
• receive a database connection string to define an identifier for the database,
• receive a target data object corresponding to the named table in the database,
• receive a Level 0 target corresponding to one of the plurality of named fields in the database defined as a Level 0 target named field,
• receive an Approaches variable,
• receive at least one approach filter, equal in count to a first value of the Approaches variable, and corresponding to a respective one of the plurality of named fields in the database defined as Above The Line named fields, wherein each of the Above The Line named fields is distinct from the Level 0 target named field,
• receive a Lines Below Level 0 variable,
• receive at least one results line, equal in count to a second value of the Lines Below Level 0 variable, and corresponding to a respective one of the plurality of named fields in the database defined as Below The Line named fields, and
• create a call that comprises query option parameters including the database connection string, the Level 0 target, the at least one approach filter, and the at least one results line;
• wherein the Orbit Form module comprises a second interface configured
• initiate data communication with the database using the database connection string,
• create at least one SQL script that includes the query option parameters of the call;
• execute the at least one SQL script to retrieve from the database a working data set comprising at least one record that includes a plurality of structurally-related values including a Level 0 value retrieved from the Level 0 target named field, at least one Above The Line value retrieved from the Above The Line named fields, and at least one Below The Line value retrieved from the Below The Line named fields, and
• display a paging box corresponding to the Level 0 target, and at least one approach box, equal in count to the first value of the Approaches variable, and each corresponding to a respective one of the at least one approach filter.