| Total Manager Database Management System | written by George Trombley Jr. | Total Strategies, Inc. 2000

There are invalid characters in the name you specified for your database. Please reenter the database name.
Please fix the problem and change any other data if needed.

Database Utility Display Title This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory Directory where data will be saved. &[ input_dbalias ]-settings.txt file has been created successfully! STEP 1. CREATE DATABASE SETTINGS FILE (complete) STEP 2. CREATE DATABASE FIELDS >>> You are missing a required field. All fields are required. Database Setup Utility If you are receiving this message the database settings file does not exists or you have not specified the 'dbalias' variable which is required for this script to work. You must specify the variable 'dbalias' in the URL for this script to work. Example: http://www.yourwebsite.com/dir/TotalManager.mv?function+&dbalias=products Example Functions:   • ShowIndexed   • GenericForm Creating a New Database If this is the first time running the script you will need to complete the following steps to create your database and configure the Total Manager. STEP 1. CREATE DATABASE SETTINGS FILE >>> STEP 2. CREATE DATABASE FIELD Database Utility Display Title Please type the display name for this database. This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename What would you like to name your database? This is the name that will be used in naming files etc. Please choose a name of a database that doesn't currently exist on this system. The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory In which directory would you like to store this database? If it doesn't exist it will be created. The directory will be place in the MIVADATA directory or the equivalent on your system. If you want to store the database in the root MIVADATA directory type MAIN in this field. There are invalid characters in the name you specified for your database. Please reenter the database name. Please fix the problem and change any other data if needed. Database Utility Display Title This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory Directory where data will be saved. &[ input_dbalias ]-settings.txt file has been created successfully! STEP 1. CREATE DATABASE SETTINGS FILE (complete) STEP 2. CREATE DATABASE FIELDS >>> You are missing a required field. All fields are required. Database Setup Utility If you are receiving this message the database settings file does not exists or you have not specified the 'dbalias' variable which is required for this script to work. You must specify the variable 'dbalias' in the URL for this script to work. Example: http://www.yourwebsite.com/dir/TotalManager.mv?function+&dbalias=products Example Functions:   • ShowIndexed   • GenericForm Creating a New Database If this is the first time running the script you will need to complete the following steps to create your database and configure the Total Manager. STEP 1. CREATE DATABASE SETTINGS FILE >>> STEP 2. CREATE DATABASE FIELD &[ input_dbalias ]-settings.txt already exists! You might already have a database with the &[ input_alias ] name. Please go back and change the database file name. There are invalid characters in the name you specified for your database. Please reenter the database name. Please fix the problem and change any other data if needed. Database Utility Display Title This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory Directory where data will be saved. &[ input_dbalias ]-settings.txt file has been created successfully! STEP 1. CREATE DATABASE SETTINGS FILE (complete) STEP 2. CREATE DATABASE FIELDS >>> You are missing a required field. All fields are required. Database Utility Display Title Please type the display name for the new version of the database. This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename What would you like to name your database? This is the name that will be used in naming files etc. The name does not have to be the same, but we recommend that you keep it the same so as not to break any current applications accessing the database. Please choose a name of a database that doesn't currently exist on this system. The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory In which directory would you like to store this database? If it doesn't exist it will be created. The directory will be place in the MIVADATA directory or the equivalent on your system. If you want to store the database in the root MIVADATA directory type MAIN in this field. If you are using the same name as the current version of the database we recommend that you place the database in a different directory to prevent conflicts. DBfields = &[ dbfields ] DBpath = &[ dbpath ] DBfullpath = DBfile = &[ dbfile ] &[ dbtitle ] - First Time Run Back to Main Index "&[ dbpath ]" CREATED. &[ dbpath ].&[ fldname ].IDX was created. &[ fldname ] is assigned the value '' &[ fldname ] does not have value. This record apears to already be in the database. It has NOT been added. WARNING: Possible error in GetRecord. The 'indexby' variable has not been defined. SEARCHING FOR: &[ searchfor ] in &[ indexby ] index. GetRecord failed because 'searchfor' variable was not defined. < &[ foundvalue ] = &[ searchfor ] Record Found!!! Record Not Found!!! WARNING: Possible error in GetRecord. The 'indexby' variable has not been defined. GetRecordByNumber failed because 'searchforrec' variable was not defined. Record Found! Record NOT Found! &[ dbtitle ] - Retrieve Record Add Record | Index Settings | Refresh Indexes | Back to Main Index     Search '&[ fldtitle ]' Index &[ showval ]' }"> There are no indexes set to be searchable. Please choose indexes to SHOW on the retrieve record page. added to store ---------------------- Form Element Section ------------------------ SEARCHFOR = &[ searchfor ] &[ dbtitle ] - Add / Update / Delete Records Back to Main Index This record does not exist. There are &[ foundmatches ] that have '&[ searchfor ]' in them. &[ foundlist ] There are NO records that have '&[ searchfor ]' in them. Record was updated. &[ name ] &[ field_value ] &[ field_value ] &[ field_value ] &[ field_value ] YES   NO &[ seldisplay ] Choose &[ selvalue ] Record was deleted Item was added Add Another Record Creating Fields You can have as many fields as you want. Enter the first field below. A minimum of ONE field is required. Password and User Name Verification If you would like to password protect an area of your website based on user information in this database you can specify a USER NAME field and PASSWORD field. They can be any character field but you can only specify one USER NAME and one PASSWORD field per directory and database. These fields will be added to the '&[ dbalias ].official.users' file in the main MIVADATA dir. Once your database is complete you will have the option of creating a new directory to protect or protecting a current directory. You MUST enter a Display Value for this selection OR choose a predefined selection list. Please go back and fix this error. -- Selects for &[ Fthefield ] -- Value = &[ Factvalue ] | Display Value = &[ Fdispvalue ] Value = &[ Factvalue ] | Display Value = &[ Fdispvalue ] Added the following selections for &[ thefield ] &[ thefield ] | &[ pre_value ] | &[ pre_display ] STEP 1. CREATE DATABASE SETTINGS FILE (complete) STEP 2. CREATE DATABASE FIELD (complete) STEP 3. CREATE FIELD SELECT LISTS >>> Fields Requiring Select Lists &[ currentfield ] , &[ currentfield ] Select List for: &[ CSfldtitle ] - &[ selfield ] (&[ CSfldtype ]) &[ CSfldlen ] Actual Value Display Value Predefined Value Sets You can add common lists of data. Click on each to view the data that will be added. Countries U.S. States Weekdays Months Month Days Years Yes / No Sex NONE Congratulations! All of your select lists have been created. Create Database >>> Predefined Data '&[ forfilter ]' ACTUAL VALUE | DISPLAY VALUE &[ sel_value ] | &[ sel_disp ] Field Name: &[ fldname ] Length: &[ lenok ] Button: &[ button ] Db Path: &[ dbpath ] Field '&[ fldname ]' has been added. FIELD NAME is a required field. Also if FIELD TYPE is set as a 'Character' you MUST also specify the FIELD SIZE. Hit back on your browser and enter the FIELD NAME. Current Fields &[ Cfldtitle ] | &[ Cfldname ] | &[ Cfldtype ] | &[ Cfldlen ] | SELECT LIST | set as PASSWORD field for password protection | set as USER NAME field for password protection Field Title Field Name Field Type Character Number Memo Date Boolean   Length Password   User Name   Standard index this field ascending stringunique create a selection list OPENING = &[ indexopen ] There is a problem in the SetIndexTo function! Warning!!! All data in database will be recreated and all data lost in current database!! Are you sure you want to continue? &[ dbpath ].&[ Dfldname ].IDX DELETED &[ dbpath ].dbt DELETED &[ dbpath ].db DELETED Initiating Database rebuilding. Settings have been updated! Field Display Status &[Dfldtitle] - (&[ Dfldname ]) Don't Show SHOW Create a New Database | Setup an Existing Database Databases Currently Available &[ database_title ] View Record Add Record Update Record Delete Record Modify Fields | Add or Modify Select Lists | Add or Modify Indexes An index with this name already exists! Please go back and rename the index and resubmit. Index was added! You are missing a required field. Please go back and check your submission. &[ index_name ] AND &[ index_expression ] "']}> Database &[ dbase_name ] New Index Name (no spaces or punctuation) Index Expression Index Parameters ascending stringunique &[ input_dbalias ]-settings.txt already exists! You might already have a database with the &[ input_alias ] name. Please go back and change the database file name. 1. &[ Rdbalias ] was found! It's structure will now be extracted. This database was not found! Please go back and make sure that you are specifying the correct directory, database name and extension. There are invalid characters in the name you specified for your database. Please reenter the database name. Please fix the problem and change any other data if needed. Database Utility Display Title This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory Directory where data will be saved. &[ input_dbalias ]-settings.txt file has been created successfully! STEP 1. CREATE DATABASE SETTINGS FILE (complete) Field Editing You can modify the fields of the new database with 2 methods. The QUICK MODIFY will list all fields on one page and you will be able to add titles for each field, change field size, indicate whether the field should be indexed and if drop down lists will be created. You will NOT be able to change the name of the fields! By using the ADVANCED MODIFY you will be able to change the name of the new field and will have more options for each field including advanced indexing and porting features. STEP 2. QUICK MODIFY >>> | ADVANCED MODIFY >>> You are missing a required field. All fields are required. Prior Database Setup This utility should be used ONLY if you have an existing database that wasn't created with the Total Manager. This will port your database and all of it's information into a new database that will function with the Total Manager. Input the name of the current database file. Include any path information and the extention used. (ie: mydatabase/database.db) Database Utility Display Title Please type the display name for the new version of the database. This name will be displayed on all forms and output screens in the Total Manager for this database. Database Filename What would you like to name your database? This is the name that will be used in naming files etc. The name does not have to be the same, but we recommend that you keep it the same so as not to break any current applications accessing the database. Please choose a name of a database that doesn't currently exist on this system. The database name MUST only contain alpha numeric characters. No punctuation or spaces may be used. Database Directory In which directory would you like to store this database? If it doesn't exist it will be created. The directory will be place in the MIVADATA directory or the equivalent on your system. If you want to store the database in the root MIVADATA directory type MAIN in this field. If you are using the same name as the current version of the database we recommend that you place the database in a different directory to prevent conflicts. &[ Rdbalias ] was opened! REVEAL_CURRENT.db was created! The following fields information was extracted from &[ Rdblaias ]. C - Character data (CHAR) N - Numeric data (NUMBER) D - Date (DATE) L - Boolean data (BOOL) M - Memo data (MEMO) &[ field_name ] (&[ field_type2 ]) &[ field_len ] Field Title Current Name New Name Type Length &[ r_field ] Character Number Memo Date Boolean Settings index field dropdown list DELETE FIELD (data in this field will be lost) Current Fields &[ Cfldtitle ] | &[ Cfldname ] | &[ Cfldtype ] | &[ Cfldlen ] | SELECT LIST | set as PASSWORD field for password protection | set as USER NAME field for password protection Field Title Field Name Field Type Character Number Memo Date Boolean   Length Password   User Name   Standard index this field ascending stringunique create a selection list Congratulations! Your database fields file has been created! #&[ g.recno ] Record was added! &[ name ] (&[ fldtype ]) &[ fldlen ] &[ field_value ] (&[ fldtype ]) &[ fldlen ] YES   NO &[ seldisplay ]