|
Worldview Software |
The Worldview Web Database
|
|
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 |
|||
|
Next Topic |
|
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. |
Next Topic |
|
HTML Template Pages | FUNCTION |
1: WVlogin.htm | Initial Login page |
2: WVhome.htm | 1st home screen after logging in |
3: WVmenu.htm | SubMenu of procedure choices |
4: WVhelp.htm | This help page |
5: WVform.htm | Example User-designed page eg *Viewpage7=Wvform.htm |
6: WVonerec.htm | PRINT REC display of 1 record |
7: Database.htm | INPUT view of single DB record |
8: Linkpage.htm | Disply of the record clicked on the last list of records |
9: Fileopen.htm | Select the filename to open |
10: Filename.htm | Enter the name of new DB file to create |
11: Badname.htm | Message screen for a bad filename |
12: NewFile | Display field characteristics of DBfile to create |
13: RowCol.htm | Display DATABASE page layout of DB file to create |
14: Query.htm | Define a Query DB search |
15: Querylst.htm | Query Result page for LIST format |
16: Queryrec.htm | Query Result page for SINGLE RECORD format |
17: Nomatch.htm | Message page if Query returns no matches |
18: Headings.htm | View/Edit DB Heading Lines |
19: Import.htm | Data Import selection page |
20: Reading.htm | Message page while reading records |
21: Export.htm | Data Export selection page |
22: Download.htm | Result page from Record Export |
23: Listview.htm | View DB records as a list |
24: WVprn.htm | View/Print page |
25: Table.htm | Find records in a lookup table |
26: Tblshow.htm | Show detail of selected table record |
27: Sendmail.htm | Option page for sending email messages |
28: Poptions.htm | Select records for VIEW/PRINT page |
29: PickFld.htm | VIEW/PRINT Selected fields |
30: Pickprn.htm | Select fields for VIEW/PRINT page |
31: Sort.htm | Select options for sorting DB records |
32: Sorting.htm | Message page while sorting records |
33: Input.htm | VIEW/ENTER records using a .FMT INPUT template |
34: Inputget.htm | Get Template/Destination filename for INPUT templates |
35: Inputprn.htm | Printer-friendly page for INPUT templates |
36: FMTtable.htm | Select records from a lookup table when using a .FMT INPUT template |
37: FMTopen.htm | Open a new destination file when using a .FMT INPUT template |
38: FMTshow.htm | Show detail of table selected record when using .FMT INPUT template |
39: Output.htm | Select options for using a .MAP OUTPUT template |
40: Printmap.htm | Report 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*"> |
Next Topic |
|
CONTENT Tags | FUNCTION |
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 |
Next Topic |
|||
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 record | see *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 table | see *GO* | None |
6: "*DBOpen*" | Open selected DB table | see *GO* | "Filename" |
7: "*Delete*" | Delete Current record | see *GO* | None |
8: "*Email*" | Send email using this DB | #27(Email) | None |
9: "*EndQuery*" | Terminate QUERY session | see *GO* | None |
10:"*EraseData*" | Erase the data in current record | see *GO* | None |
11:"*Execute:B9*" | Run procedure B9 | Selected by procedure | WCU=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 template | See *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 table | see *GO* | None |
28:"*LastMatch*" | Find previous matching record | same 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 record | see *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 copied | see *GO* | None |
38:"*PickAll*" | Select ALL fields for export | #21 (Export) | None |
39:"*PrevRec*" | Read last DB record | see *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 Query | see *Saverec* | None |
44:"*ReadRec*" | Read specified record number | see *GO* | "Recnum" |
45:"*Recalc*" | Recalculate formulas and table lookups in DB records | see *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 table | see *GO* | None |
49:"*Savehead*" | Save table heading lines | see *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 field | see *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 record | see*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 INPUT | see *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 page | selected 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 |
Home |
|
PROFILE Fields | DESCRIPTION |
1: ID | User Logon ID |
2: Password | User Logon Password |
3: Data Directory | Data Directory on the Webserver |
4: User name | Full User name |
5: Email Address | Return email address |
6: Logo filename | Name of Logo file |
7: Body Tag-Menus | Menu screen settings |
8: Body Tag-Data views | Data view settings |
9: Body Tag-INPUT templates | .FMT INPUT settings |
10: Body Tag-OUTPUT templates | .MAP OUTPUT settings |
11: Main Title | HTM Template main title |
12: Subtitle | HTM Template subtitle |
13: URL Link | Web address link |
14: Home HTM filename | Name of initial HTM template file |
15: Userdefined Field #1 | User specified data, for example: |
16: Userdefined Field #2 | <!--*SPARE3*--> |
17: Userdefined Field #3 | (display User profile spare field 3 = Fld 17 ) |
18: Last Login | Date/time of last login |
19: Screen Font | Font spec for screen display |
20: Report Font | Font spec for printer-friendly display |