Worldview Software

The Worldview Web Database
Technical Reference Page

Welcome to WWDB: the Worldview Web Database system.

The Worldview Web Database is a brand new concept in website development that provides the web designer with an amazing range of capabilities, while leaving the user interface design completely under their control. Web designers can use whatever HTML editing program they prefer. By including simple comment tags and form action keywords, they can easily tap into a vast range of database and ASP webform functions.

GENERAL INFORMATION
HTML templates
CONTENT Keywords
ACTION Keywords
User PROFILE

Return to Worldview Software


 


General Information

Next Topic
Home

When the user logs in to the WWDB site, his session is controlled by the parameters set up in his record in the master database file WVUSERS, which is located in the WWDB program directory. This record controls such things as his login ID and password, the data directory on the web server that his files will be located in, and the name of the .HTM file that will be used as his home page.

During a user's session on a WWDB site, a number of .HTM files will be used as HTML templates for the pages that he is able to navigate to. The default filenames for these HTML templates are listed below, but they can be redefined during his session by embedded action tags on selected pages.

In each of these HTML template files, which can be created or edited using any HTML editor, a number of content elements (equivalent to nouns in grammar) and actions keywords (equivalent to verbs in grammar) are embedded.

Each time WWDB encounters one of the embedded content elements, which has been inserted in the form of a comment tag in the HTML page, it replaces it with the appropriate HTML content. These content tags take the form of an exclaimation point, followed by 2 dashes, followed by a star, followed by one of the keywords recognized by WWDB, followed by another star, follwed by 2 more dashes. For example, when the content tag <!--*REC#*--> is encountered, WWDB replaces the tag with text representing the current DB record number. Some of these elements are more extensive. For example, <!--*CREATETABLE*--> inserts 20 rows of 9 columns each into NEWFILE.HTM which allow you to enter all of the field characteristics required to create a new DB table.

Any ANCHOR tag that contains an HREF= option or FORM tag that contains an ACTION= option in any of the HTML templates can direct WWDB to perform one of the actions defined by the list of action keywords recognized by WWDB. These action keywords take the form of a double quotation mark, followed by a star, followed by the keyword, followed by another star, followed by double quotation marks. For example, if you click a link that is preceded by the tag:  <a href="*NEXTREC*">  then WWDB will read the next record in the current DB and then redisplay the page using the information from the new record.

 


HTML Template files

Next Topic
Home

HTML Template PagesFUNCTION
1: WVlogin.htmInitial Login page
2: WVhome.htm1st home screen after logging in
3: WVmenu.htmSubMenu of procedure choices
4: WVhelp.htmThis help page
5: WVform.htmExample User-designed page eg *Viewpage7=Wvform.htm
6: WVonerec.htmPRINT REC display of 1 record
7: Database.htmINPUT view of single DB record
8: Linkpage.htmDisply of the record clicked on the last list of records
9: Fileopen.htmSelect the filename to open
10: Filename.htmEnter the name of new DB file to create
11: Badname.htmMessage screen for a bad filename
12: NewFileDisplay field characteristics of DBfile to create
13: RowCol.htmDisplay DATABASE page layout of DB file to create
14: Query.htmDefine a Query DB search
15: Querylst.htmQuery Result page for LIST format
16: Queryrec.htmQuery Result page for SINGLE RECORD format
17: Nomatch.htmMessage page if Query returns no matches
18: Headings.htmView/Edit DB Heading Lines
19: Import.htmData Import selection page
20: Reading.htmMessage page while reading records
21: Export.htmData Export selection page
22: Download.htmResult page from Record Export
23: Listview.htmView DB records as a list
24: WVprn.htmView/Print page
25: Table.htmFind records in a lookup table
26: Tblshow.htmShow detail of selected table record
27: Sendmail.htmOption page for sending email messages
28: Poptions.htmSelect records for VIEW/PRINT page
29: PickFld.htmVIEW/PRINT Selected fields
30: Pickprn.htmSelect fields for VIEW/PRINT page
31: Sort.htmSelect options for sorting DB records
32: Sorting.htmMessage page while sorting records
33: Input.htmVIEW/ENTER records using a .FMT INPUT template
34: Inputget.htmGet Template/Destination filename for INPUT templates
35: Inputprn.htmPrinter-friendly page for INPUT templates
36: FMTtable.htmSelect records from a lookup table when using a .FMT INPUT template
37: FMTopen.htmOpen a new destination file when using a .FMT INPUT template
38: FMTshow.htmShow detail of table selected record when using .FMT INPUT template
39: Output.htmSelect options for using a .MAP OUTPUT template
40: Printmap.htmReport output when using a .MAP OUTPUT template
41 to 64: User-defined page names Specified by, for example, <!--*HTM64:Filename*-->
and accessed by <a href="*VIEWPAGE64*" method=post>
or specified and accessed by <a href="*Viewpage64:Filename.htm*">
 


CONTENT keywords

Next Topic
Home

CONTENT TagsFUNCTION
1: <--*BODYFILE*-->File Open page: Body tag from user's profile
2: <--*BODYINPUT*-->INPUT template page: Body tag from user's profile
3: <--*BODYMENU*-->Menu page: Body tag from user's profile
4: <--*BODYOUTPUT*-->OUTPUT template page: Body tag from user's profile
5: <--*COMPARISONS*-->Insert QUERY comparison table
6: <--*CREATETABLE*-->Insert DB file specification table (create new table)
7: <--*DATFILES*-->Insert SELECT list of .DAT data import files
8:<--*DBDATA9*-->Insert data from field 9 in the current DB record
9: <--*DBFILES*-->Insert SELECT list of DB table files
10:<--*DBRECORD*-->Insert table displaying record (1 field per line)
11:<--*DEST*-->Display the current data directory path
12:<--*DIRLIST*-->Create a SELECT list of all filenames in the current data directory
13:<--*EFLD*-->Insert SELECT list of DB fields to pick email address from
14:<--*EMAIL*-->Insert INPUT tag containing destination email address from current DB record
15:<--*EMAILFROM*-->Insert INPUT tag containing default email return address
16:<--*FIELD9*-->Insert the name of field 9 in the current DB table
17:<--*FIELDLIST*-->Insert SELECT list of DB table field names. Optional: FIELDLIST5 (indicates instance # 5 of several occurances on the page)
18:<--*FIELDTABLE5*-->Create table of DB field names to export (5=5 col wide)
19:<--*FILENAME*-->Insert current DB table filename
20:<--*FMTfiles*-->Insert SELECT list of .FMT template filenames
21:<--*FMTINPUT*-->Insert table rows specified in a .FMT INPUT template
22:  <--*Hclick:*--> or <--*Vclick:*-->
For example: <--*Hclick:O=1-88*-->
<--*Hclick:C=89-176,P=177-264*-->
<--*Hclick:S=265-352,T=353-440*-->
<--*Hclick:I=441-528,E=529-616*-->
Define horizontal or vertical click co-ordinates that will respond to a *DBCLICK* or *FMTCLICK* event (defined by 1st letter of each action name eg P=Print)
23:<--*HEADING8.3*-->Insert INPUT tag for DB table constants (Heading line 8, part 3)
24:<--*HTM8=Database2*-->Set filename for HTM template #8 to DATABASE2
25:<--*IMAGESHOW*-->Set flag to display image and play sound files
26:<--*IMAGEHIDE*-->Set flag to display filenames, not content, for image and sound files
27:<--*INDEXREC*-->Insert hidden INPUT tag containing current index record number
28:<--*INPUTFIELDS*-->Insert SELECT list of marker names from a .FMT INPUT template
29:<--*INPUTROW1*-->Insert Captions and INPUT tags from DB table row # 1
30:<--*LINK*-->Insert ANCHOR tag with href=(name of last .CSV download file created) Optional: LINK9 - create href from DB field 9
31:<--*LIST9*-->Insert data from field 9 in the last table lookukp record
32:<--*LISTPRINT*-->Display DB records in VIEW/PRINT list format
33:<--*LISTROW1*-->Display DB records in LISTVIEW format (row # 1)
34:<--*LISTTITLE,0,1,2,3,-6*-->DB field name title line (negative Fld# defines a column with a total,
0 inserts a link to display selected record on it's own page)
35:<--*LOGO*-->Insert IMG tag with logo from user profile
36:<--*LOOKUPDATA*-->Insert INPUT tag containing data from last table lookup
37:<--*MAPFILES*-->Insert SELECT list of .MAP OUTPUT template files
38:<--*MESSAGE*-->Insert current site message eg "Enter ID and Password"
39:<--*PICKFIELD*-->Insert list of field names with check boxes for user selection
40:<--*PICKPRINT*-->DB records in VIEW/PRINT list with links to view selected records
41:<--*PICKTITLE*-->Create Title row of selected field names
42:<--*PTRFILES*-->Insert SELECT list of .PTR Query pointer files (previously selected records)
43:<--*REC#*-->Create INPUT tag with current DB record #. Can also be used to preset the record number eg REC#:50
44:<--*ROOT*-->Display the root directory path on the web server
45:<--*SEARCHFIELD*-->Insert SELECT list of indexed field names
46:<--*SEARCHFOR*-->Insert INPUT tag containing data to search for
47:<--*SEARCHTYPE*-->Insert RADIO BUTTONS for First/Next/Previous/Last match choice
48:<--*SHOWBUTTONS*-->Display menu buttons defined in USERMENU.INI
49:<--*SHOWMENU*-->Display custom menu choices defined in USERMENU.INI
50:<--*SORTFILES*-->Insert SELECT list of Primary .ABC or Secondary .XYZ sort files
51:<--*SORTOPT*-->Insert SELECT list of field names to sort or subsort by
52:<--*SPARE3*-->User-defined content 1 2 or 3 from user profile
53:<--*SUBTITLE*-->Insert Subtitle from user profile
54:<--*Table:<A>STOCK1*-->Insert [?] tag for data selection for marker "A" from a table lookup
55:<--*TABLEDATA*-->Insert a SELECT list of lookup table records
56:<--*TABLEFIELDS*-->Create SELECT list of lookup Table field names
57:<--*TABLEFILE*-->Insert filename of current Lookup Table file
58:<--*TBLRECORD*-->Display all of the data in the currently selected lookup table record
59:<--*TITLE*-->Insert Title from user profile
60:<--*UFLD*-->Insert SELECT list of fields to pick HTML Email URL from
61:<--*URLDEFAULT*-->INPUT tag containing defaul HTML Email URL from user profile
62:<--*URLFIELD*-->INPUT tag containing HTML Email URL from current DB record
63:<--*USER*-->Display the user's login name
64:<--*WORLDVIEW*-->Display Version and link to WV website
 


ACTION keywords

Next Topic
Home

ACTION Tags FUNCTION HTM template Values Returned
1: "*Cancel*"Cancel current action see *GO* Optional: "Builtin" -
see *GO*
2: "*Copy*"Copy the data fields in current recordsee *GO*None
3: "*CopyFile*"Select name of file to copy#12(Copyfile)"Copyfile"
4: "*DBclick*"Execute click action defined by HCLICK or VCLICK content tags Respond to mouseclick
co-ordinates and execute corresponding action
Aquire(Export), Back(PrevRec), Close(DBclose), Delete, Erasedata, Formulas(Calc-see Saverec), Graphics(Image), Headings, Insert, List(Viewlist), Message(Email), NextRec, Openfile, Printlist, Query, Recalc, Sort, TableLookup(see SaveRec), Upload(Import), View(Printlist), Write(SaveRec), eXit(Cancel), Y(Copy),
Z(Paste)
5: "*DBclose*"Close current DB tablesee *GO* None
6: "*DBOpen*"Open selected DB tablesee *GO* "Filename"
7: "*Delete*"Delete Current record see *GO*None
8: "*Email*"Send email using this DB#27(Email)None
9: "*EndQuery*"Terminate QUERY sessionsee *GO*None
10:"*EraseData*"Erase the data in current recordsee *GO*None
11:"*Execute:B9*"Run procedure B9Selected by procedureWCU=Procedure name (B9)
12:"*Export*"Download data from this DB table#21(Export)None
13:"*FileSpec*"Get name of DB table to create#12(Newfile) or
#11(Badname)
"Filename"
"Category"
14:"*FindFirst*"Find 1st record matching Query #15(Querylst)
#16(Queryrec)
#17(Nomatch)
"Sortfile","Startrec"
"Showrec","PTRfile"
plus Query Parameters
"101" to "503"
15:"*FindNext*"Find next record matching QUERY Same as *FindFirst*None
16:"*FMTcancel*"Cancel current action in FMT templateSee *Inputshow*None
17:"*FMTclick*"Execute click action defined by HCLICK or VCLICK content tags Calc:33(input)
Exit:2(home)
Image:33(input)
Open:37(fmtopen)
Print:35(inputprn)
Save:33(input)
Table:36(fmttable)
Mouse click co-ordinates Optional: "FMTbuttons" for field table lookups, example:
(Instruction line in FMT file)
@[Table]=<2>Vendors
(Content tag in HTM file)
<!--*Table:<A>Stock1*-->
18:"*FMTtable*"Open lookup table in FMT template#38(Fmtshow)
#36(Fmttable)
#33(Input)
"Table", "Record" and "Pastefld"
1st letter of Table value:
D=Display lookup record
O=Open lookup table
Other=Read selected record
19:"*Go*"Refresh browser page#23(Listview)
#7(Database) or
#8(Linkpage)
Optional: "Builtin" values:
2=#34(INPUTget)
3=#39(OUTPUT)
4=#2(SETUP)
5=#4(HELP)
20:"*Headings*"Display/Edit Table header fields#18(Headings)None
21:"*Help*"HELP page#4(WVhelp)Calling Page # to return to
22:"*Home*"Return to Home menu page#2(WVHome)None
23:"*Image*"Image/Sound display on/off(display filename when off)see *GO*None
24:"*Import*"Display data IMPORT page#19(Import)None
25:"*INPUTopen*"Select FMT Input template & destination DB#33(Input)"Template", "Filename"
26:"*InputShow*"Return to FMT template#33(Input)None
27:"*Insert*"Insert new record in DB tablesee *GO*None
28:"*LastMatch*"Find previous matching recordsame as *Findfirst*None
29:"*Linkpage*"Display selected record on it's own page (This action is automatically inserted if Fld#0 is included in *LISTTITLE*)#8(Linkpage)WCU=Rec# to display
30:"*Login*", "*Logout*"Display home page or login page#2(WVHome)
#1(WVLogin)
"ID" and "PW"
31:"*MakeFile*"Save new DB characteristics and display fld screen positions#13(Rowcol)"Filename" and file specifications "11" to "209"
32:"*MenuList*"Display menu of procedure choices#3 (WVmenu)WCU=Menu number
33:"*NewFile*"Design a new DB table#10 (Filename)None
34:"*NextRec*"Read next DB recordsee *GO*None
35:"*Openfile*"Select DB table to open#9(Fileopen)None
36:"*Output*"Go to .MAP template option screen#39 (Output)None
37:"*Paste*"Paste last record which was copiedsee *GO*None
38:"*PickAll*"Select ALL fields for export#21 (Export)None
39:"*PrevRec*"Read last DB recordsee *GO*None
40:"*Printlist*"Go to Print/View options page#28 (Poptions)WCU=last clicked rec#
41:"*Printrec*"Printer-friendly view of 1 record#6 (WVonerec)WCU=last clicked rec#
42:"*Query*"Go to Query option page#14 (Query.htm)None
43:"*QuerySave*"Save record displayed by Querysee *Saverec*None
44:"*ReadRec*"Read specified record numbersee *GO*"Recnum"
45:"*Recalc*"Recalculate formulas and table lookups in DB recordssee *GO*None
46:"*Refresh*"Redisplay page with specified field position#13 (RowCol)"Field" number and
1 to 4 (Label/Data Row/Col)
47:"*Reset*"Clear paramaters
Start new Query
#14 (Query)None
48:"*SaveFile*"Save structure of new tablesee *GO*None
49:"*Savehead*"Save table heading linessee *GO*24 Table contants 1.1 to 8.3
50:"*SaveRec*"DB record:Save, calc or lookup#25(Table) #23(Listview) #7(Database) #8(Linkpage)Return fields "1" to "20" plus
"Save" C=Calc L=Lookup
or write record
51:"*Search*"Search for records matching indexed fieldsee *GO* "Searchfor","Searchfield"
"Search" type
1=first 2=next 3=prev 4=last
"Indexrec" (index record #)
52:"*Send*"Send email messages#7 (Database) "Efld","Ufld","Emailfrom"
"Record","Content","PTR"
"CC","BCC","Subject","Body"
"Email","URLfield","URLdefault"
53:"*ShowPick*"Show record list of selected fields#30 (Pickprn)"1" to "20" (Show field)
"101" to "120" (total column)
54:"*ShowPrn*"Get View/Print options and display record list#24(wvprn) or
#29(pickfld)
"Reclist","PTRfiles","Sortfiles","Format"
55:"*ShowQuery*"Get View/Print options and display 1st recordsee*Showprn*see *Showprn*
56:"*Sort*"Go to Sort option page#31 (Sort)None
57:"*StartExport*"Add export fld# to list or start exporting#21(export) or #22(download) "Export", "Filetype", "RecOrder"
"PTRfiles", "Sortfiles"
"101" to "320" sort options
58:"*StartImport*"Begin importing of .DAT file#7(database)or
#20 (Reading)
"Datfiles", "Append"
59:"*StartMAP*"Process .MAP report template#40 (Printmap) "Repeat","Format","Recorder","PTRfiles"
"Sortfiles", "First", "Last", "Template"
60:"*StartSort*"Start sorting DB records#32 (Sorting)
#7 (Database)
"Searchfield", "Sortopt", "Filetype"
"Order", "Alpha", "Replace"
61:"*Tabledata*"Select record from lookup table or display selected record#7(database)or
#26 (Tblshow)
"Record", "Pastefld"
"Table" (D=tblshow)
62:"*ViewInput*"Switch Viewmode to INPUTsee *GO*None
63:"*ViewList*"Switch Viewmode to LIST#23 (Listview)None
64:"*VIEWPAGE7:WVform.htm*"Specify a filename for a Page # (optional) and display that pageselected page#
If 0 then return to the page that linked the current page
Specified by the action's WCU
Page numbers 41 to 64 are
user-defined pagenames
 


USER Profile

Home

PROFILE FieldsDESCRIPTION
1: IDUser Logon ID
2: PasswordUser Logon Password
3: Data DirectoryData Directory on the Webserver
4: User nameFull User name
5: Email AddressReturn email address
6: Logo filenameName of Logo file
7: Body Tag-MenusMenu screen settings
8: Body Tag-Data viewsData view settings
9: Body Tag-INPUT templates.FMT INPUT settings
10: Body Tag-OUTPUT templates.MAP OUTPUT settings
11: Main TitleHTM Template main title
12: SubtitleHTM Template subtitle
13: URL LinkWeb address link
14: Home HTM filenameName of initial HTM template file
15: Userdefined Field #1User specified data, for example:
16: Userdefined Field #2<!--*SPARE3*-->
17: Userdefined Field #3(display User profile spare field 3 = Fld 17 )
18: Last LoginDate/time of last login
19: Screen FontFont spec for screen display
20: Report FontFont spec for printer-friendly display