// THIS IS THE LIBRARY OF ROUTINES/FUNCTIONS USED IN 'CASE'
// This is the CASE library of tags, images, etc.
Computer Assisted Solutions Environment
//
This site developed and served to you by the
Department of Behavioral and Social Sciences at Southern Arkansas University in
conjunction with the Arkansas Partnerships for Public Child
Welfare.
Computer Assisted Solutions Environment
//
This site developed and served to you by the
Department of Behavioral and Social Sciences at Southern Arkansas University in
conjunction with the Arkansas Partnerships for Public Child
Welfare.
// TO BE USED ANYTIME????
// Submit Button Definition
// This tag obtains the next sequential number from the database
SELECT max( fieldname>) +1 FROM tablename>;
// This one is adapted to use in the dba environment
//
SELECT max()+1 FROM rel>;
//
// 1
//
//
//
// THIS IS A TEST SEARCH FORM. NEEDS REVISION. TO BE USED IN THE
// CASE SEARCH PAGE???
// IS THIS NECCESSARY?
// FREQUENTLY USED
// This one displays the dbaform row in two columns with a 'plain English'
// header (phrase) -created by Danny Stewart
// USED IN BSW ALSO
// SAME AS ABOVE, BUT FOR A CENTERED PHRASE AND TEXT AREA
// USED IN BSW ALSO
// SIMILAR TO ABOVE, BUT FOR LARGE TEXT FIELDS:
// USED AT ALL?
// USED AT ALL?
// USED AT ALL?
// A three-cell row similar to the first dbatfix:
// ALL OF THESE POPUP/SELECT ROUTINES WORK, AND ARE IN USE
// USED IN CASE, RESLIB
// * * * * * * * *
// (These two MUST go hand-in-hand!)
//
//
// * * * * * * * * *
// Created by Christina Woodruff:
// The following tag works ONLY with the one below it:
// It is a POPUP MENU tag.
// (These two MUST go hand-in-hand!)
//
//
//
//
//
// ***This tag creates a 2-cell popup menu****
//
//
//
// THIS ONE WORKS AND IS IN USE
// This tag creates a 3-cell row that gives a link to the related data in
// another table, where the key fields have the same name and values.
// THIS ONE IS JUST LIKE THE ONE ABOVE, BUT FOR USE WHEN YOU DON'T WANT THE FIELD
// DATA TO SHOW ON YOUR WEB FORM.
// CANNOT FIND WHERE THIS IS USED...
// ALSO CANNOT FIND WHERE THIS ONE IS USED...
// JUST LIKE THE ONE ABOVE, BUT ADDS ADDITIONAL INFO TO URL. The desired fields
// have different names and the values are determined by the data served in the
// query results.
// CANNOT FIND WHERE THIS IS USED...
*
// THIS ONE IS USED
// Like above, but where the desired fields are key fields with different names
// though the same values. i.e. cp_code vs. cp1_code
//
// CANNOT FIND WHERE THIS IS USED
// THIS ONE IS SIMILAR TO THE ABOVE, BUT FOR USE IN THE 'DBATABLE' (?) TAG
// CANNOT FIND WHERE THIS IS USED
// CANNOT FIND WHERE THIS IS USED
// CANNOT FIND WHERE THIS IS USED
// THIS IS A REPEATED NAME, BUT THE FUNCTION IS DIFFERENT. CANNOT FIND
// WHERE IT IS USED.
Services
// CANNOT FIND WHERE THIS IS USED
// CANNOT FIND WHERE THIS IS USED.
// THIS IS ALSO A REPEAT NAME. SIMILAR FUNCTION.
// CANNOT FIND WHERE THIS IS USED
// CANNOT FIND WHERE THIS IS USED
// THIS IS DEFINITELY USED!!!!
// CANNOT FIND WHERE THIS IS USED IN CASE
select max()+1 from
;
// ADAPTED FROM DANNY'S PREVIOUS RESLIB POPUP/SELECT ROUTINE FOR USE IN
// THE DBA ENVIRONMENT.
// (These two MUST go hand-in-hand!)
// THIS IS LIKE DBAXSELECTSEL, BUT IT ALSO HAS A TEXT INPUT FIELD ALLOWING
// THE USER TO ADD TO THE OPTION LIST
// THIS DOES NOT APPEAR TO BE USED IN CASE, BUT IN BSW
// ***************** SUCCESS AT LAST!!! ******************************
// THIS WORKS BEAUTIFULLY!! IT AUTOINCREMENTS THE INTEGER KEYFIELD ON A
// NEW RECORD, DOES NOT ALLOW EDITTING OF THE KEYFIELD OTHER THAN 'DELETE',
// AND IS HIDDEN FROM THE USER DURING DATA DISPLAY.
SELECT max()+1 FROM ;