Dbfree
Encyclopedia
DBFree is a free software
package for Microsoft Windows
(x32/x64) that includes a web server
and an interpreter
(Maxscript
) intended for developing web application
s based on the xBase
language dialect and conventions.
Other commercial drivers are available, including Clipper, FoxPro
, visual dBase and ODBC
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
Another example: using a DBF table:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
Some notably disadvantages:
Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
DBFree is a free software
package for Microsoft Windows
(x32/x64) that includes a web server
and an interpreter
(Maxscript
) intended for developing web application
s based on the xBase
language dialect and conventions.
Other commercial drivers are available, including Clipper, FoxPro
, visual dBase and ODBC
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
Another example: using a DBF table:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
Some notably disadvantages:
Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
DBFree is a free software
package for Microsoft Windows
(x32/x64) that includes a web server
and an interpreter
(Maxscript
) intended for developing web application
s based on the xBase
language dialect and conventions.
Other commercial drivers are available, including Clipper, FoxPro
, visual dBase and ODBC
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
Another example: using a DBF table:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
Some notably disadvantages:
Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
Free software
Free software, software libre or libre software is software that can be used, studied, and modified without restriction, and which can be copied and redistributed in modified or unmodified form either without restriction, or with restrictions that only ensure that further recipients can also do...
package for Microsoft Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
(x32/x64) that includes a web server
Web server
Web server can refer to either the hardware or the software that helps to deliver content that can be accessed through the Internet....
and an interpreter
Interpreter (computing)
In computer science, an interpreter normally means a computer program that executes, i.e. performs, instructions written in a programming language...
(Maxscript
Maxscript
MaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
) intended for developing web application
Web application
A web application is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is coded in a browser-supported language and reliant on a common web browser to render the application executable.Web applications are...
s based on the xBase
XBase
xBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
language dialect and conventions.
- Web applications built with DBFree are built around dynamic web pageDynamic web pageA dynamic web page is a kind of web page that has been prepared with fresh information , for each individual viewing. It is not static because it changes with the time , the user , the user interaction , the context A dynamic web page is a kind of web page that has been prepared with fresh...
s (identified by the .msp extension, that is automatically recognized by the interpreter, and parsed line-by-line in search of xBaseXBasexBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
code embedded between <% and %> markers). - Anytime valid xBase code is found it is processed by the interpreter, and the results of its logic (in the form of plain textPlain textIn computing, plain text is the contents of an ordinary sequential file readable as textual material without much processing, usually opposed to formatted text....
) are embedded in the exact position where the code was found. - This realizes true server-side scriptingServer-side scriptingServer-side scripting is a web server technology in which a user's request is verified by running a script directly on the web server to generate dynamic web pages. It is usually used to provide interactive web sites that interface to databases or other data stores. This is different from...
because the original code is never passed back to browserWeb browserA web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
, and all the calculations are done on the web server host. - HTMLHTMLHyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....
, JavascriptJavaScriptJavaScript is a prototype-based scripting language that is dynamic, weakly typed and has first-class functions. It is a multi-paradigm language, supporting object-oriented, imperative, and functional programming styles....
and xBase code can be merged seamlessly. Because the interpretation is taken before to pass the page to browser, xBase code can be used to feed Javascript functions with live data, in response to different contexts or conditions. - Database support is built-in into the interpreter, thus no other software is needed to feed data to web pageWeb pageA web page or webpage is a document or information resource that is suitable for the World Wide Web and can be accessed through a web browser and displayed on a monitor or mobile device. This information is usually in HTML or XHTML format, and may provide navigation to other web pages via hypertext...
s; the default drivers provided with installation package give access to standard DBFDBASEdBase II was the first widely used database management system for microcomputers. It was originally published by Ashton-Tate for CP/M, and later on ported to the Apple II and IBM PC under DOS...
tables (level 3) used by dBase III.
Other commercial drivers are available, including Clipper, FoxPro
Visual FoxPro
Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro which was developed by Fox Software beginning in 1984. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the...
, visual dBase and ODBC
Open Database Connectivity
In computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
- Web pages can also be written using dBase syntax, although in both cases (Clipper 87 or dBase syntax) only commands that make sense in the specific environment of a web page are recognized.Commands include logic branching with IF..ENDIF, looping with DO..WHILE, FOR..NEXT and DO CASE..ENDCASE. MaxScript commands and functions give complete access to host's file system with SET ALTERNATE or memoread and memowrite functions. The webserver (being the preconfigured XitamiXitamiXitami is a Web and FTP server, originally developed by iMatix Corporation as a free, open-source product from 1996 to 2000. It ran as a single process with a small footprint. It was not as fast as the fastest servers but scaled well. It supported several web application protocols and was very...
or the optional Apache) can be accessed programmatically modifying their initialization file and launching batch files with appropriate links. - DBFree is derived from Maxsis commercial product DBMax and maintained by volunteers sponsored by the original producers.
Programming in MaxScript
- All MaxscriptMaxscriptMaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
instructions must be contained between <% and %> tags. Pages to be interpreted must have the .msp extension. - All pages are to be written in plain text using a text editor (or specialized web authoring tools).
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
These are the days of the week:
<%
declare aDays(7) //-- declaring an array of 7 elements
for iii = 1 to alen(aDays)
aDays[iii] := cdow(iii) //-- assigning name of the day (string) to array element
? aDays[iii] + "
" //-- printing list to web page
next
%>
Another example: using a DBF table:
Listing content of table CUSTOMERS.DBF:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
MaxScript's DBFree implementation
DBFree offers a triple choice to programming with MaxScript:- Standard style
- Ajax mode
- MaxObjects.
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
Standard Style
The standard CGI programming style is typical of plain MaxScript code, offering maximum backward compatibility with Clipper and Xbase existing code.This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
- Does not depend from external libraries, so pages load faster
- Web forms are presented into static HTML pages relieving the CPU workload
- Code is clearer to read while all links are hardcoded into the pages
- Development is simple and can be done just using a browser with editing tools (like Firefox) because the code for each task is clearly isolated
Some notably disadvantages:
- The web applications tends to have lot of pages (thus becomes more complex to maintain)
- Development can be very tedious because of the higher number of pages to code and the exponential complexity of the resulting web site
- Without libraries most of MaxScript advanced functions won't be available
- Modularity (reusability of code) is greatly reduced while most of the code refer to fixed locations on host
- Every action requires the page to be reloaded (and this can be annoying for the user), even if in most cases using Javascript along with MaxScript can mitigate this inconvenience
Ajax mode
Javascript can be of great help into moving part of workload from server to user's CPU. It can also add lot of interactivity to web pages, especially if the user's browser supports Ajax asynchronous operations.Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
DBFree is a free software
Free software
Free software, software libre or libre software is software that can be used, studied, and modified without restriction, and which can be copied and redistributed in modified or unmodified form either without restriction, or with restrictions that only ensure that further recipients can also do...
package for Microsoft Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
(x32/x64) that includes a web server
Web server
Web server can refer to either the hardware or the software that helps to deliver content that can be accessed through the Internet....
and an interpreter
Interpreter (computing)
In computer science, an interpreter normally means a computer program that executes, i.e. performs, instructions written in a programming language...
(Maxscript
Maxscript
MaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
) intended for developing web application
Web application
A web application is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is coded in a browser-supported language and reliant on a common web browser to render the application executable.Web applications are...
s based on the xBase
XBase
xBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
language dialect and conventions.
- Web applications built with DBFree are built around dynamic web pageDynamic web pageA dynamic web page is a kind of web page that has been prepared with fresh information , for each individual viewing. It is not static because it changes with the time , the user , the user interaction , the context A dynamic web page is a kind of web page that has been prepared with fresh...
s (identified by the .msp extension, that is automatically recognized by the interpreter, and parsed line-by-line in search of xBaseXBasexBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
code embedded between <% and %> markers). - Anytime valid xBase code is found it is processed by the interpreter, and the results of its logic (in the form of plain textPlain textIn computing, plain text is the contents of an ordinary sequential file readable as textual material without much processing, usually opposed to formatted text....
) are embedded in the exact position where the code was found. - This realizes true server-side scriptingServer-side scriptingServer-side scripting is a web server technology in which a user's request is verified by running a script directly on the web server to generate dynamic web pages. It is usually used to provide interactive web sites that interface to databases or other data stores. This is different from...
because the original code is never passed back to browserWeb browserA web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
, and all the calculations are done on the web server host. - HTMLHTMLHyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....
, JavascriptJavaScriptJavaScript is a prototype-based scripting language that is dynamic, weakly typed and has first-class functions. It is a multi-paradigm language, supporting object-oriented, imperative, and functional programming styles....
and xBase code can be merged seamlessly. Because the interpretation is taken before to pass the page to browser, xBase code can be used to feed Javascript functions with live data, in response to different contexts or conditions. - Database support is built-in into the interpreter, thus no other software is needed to feed data to web pageWeb pageA web page or webpage is a document or information resource that is suitable for the World Wide Web and can be accessed through a web browser and displayed on a monitor or mobile device. This information is usually in HTML or XHTML format, and may provide navigation to other web pages via hypertext...
s; the default drivers provided with installation package give access to standard DBFDBASEdBase II was the first widely used database management system for microcomputers. It was originally published by Ashton-Tate for CP/M, and later on ported to the Apple II and IBM PC under DOS...
tables (level 3) used by dBase III.
Other commercial drivers are available, including Clipper, FoxPro
Visual FoxPro
Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro which was developed by Fox Software beginning in 1984. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the...
, visual dBase and ODBC
Open Database Connectivity
In computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
- Web pages can also be written using dBase syntax, although in both cases (Clipper 87 or dBase syntax) only commands that make sense in the specific environment of a web page are recognized.Commands include logic branching with IF..ENDIF, looping with DO..WHILE, FOR..NEXT and DO CASE..ENDCASE. MaxScript commands and functions give complete access to host's file system with SET ALTERNATE or memoread and memowrite functions. The webserver (being the preconfigured XitamiXitamiXitami is a Web and FTP server, originally developed by iMatix Corporation as a free, open-source product from 1996 to 2000. It ran as a single process with a small footprint. It was not as fast as the fastest servers but scaled well. It supported several web application protocols and was very...
or the optional Apache) can be accessed programmatically modifying their initialization file and launching batch files with appropriate links. - DBFree is derived from Maxsis commercial product DBMax and maintained by volunteers sponsored by the original producers.
Programming in MaxScript
- All MaxscriptMaxscriptMaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
instructions must be contained between <% and %> tags. Pages to be interpreted must have the .msp extension. - All pages are to be written in plain text using a text editor (or specialized web authoring tools).
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
These are the days of the week:
<%
declare aDays(7) //-- declaring an array of 7 elements
for iii = 1 to alen(aDays)
aDays[iii] := cdow(iii) //-- assigning name of the day (string) to array element
? aDays[iii] + "
" //-- printing list to web page
next
%>
Another example: using a DBF table:
Listing content of table CUSTOMERS.DBF:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
MaxScript's DBFree implementation
DBFree offers a triple choice to programming with MaxScript:- Standard style
- Ajax mode
- MaxObjects.
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
Standard Style
The standard CGI programming style is typical of plain MaxScript code, offering maximum backward compatibility with Clipper and Xbase existing code.This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
- Does not depend from external libraries, so pages load faster
- Web forms are presented into static HTML pages relieving the CPU workload
- Code is clearer to read while all links are hardcoded into the pages
- Development is simple and can be done just using a browser with editing tools (like Firefox) because the code for each task is clearly isolated
Some notably disadvantages:
- The web applications tends to have lot of pages (thus becomes more complex to maintain)
- Development can be very tedious because of the higher number of pages to code and the exponential complexity of the resulting web site
- Without libraries most of MaxScript advanced functions won't be available
- Modularity (reusability of code) is greatly reduced while most of the code refer to fixed locations on host
- Every action requires the page to be reloaded (and this can be annoying for the user), even if in most cases using Javascript along with MaxScript can mitigate this inconvenience
Ajax mode
Javascript can be of great help into moving part of workload from server to user's CPU. It can also add lot of interactivity to web pages, especially if the user's browser supports Ajax asynchronous operations.Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
DBFree is a free software
Free software
Free software, software libre or libre software is software that can be used, studied, and modified without restriction, and which can be copied and redistributed in modified or unmodified form either without restriction, or with restrictions that only ensure that further recipients can also do...
package for Microsoft Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
(x32/x64) that includes a web server
Web server
Web server can refer to either the hardware or the software that helps to deliver content that can be accessed through the Internet....
and an interpreter
Interpreter (computing)
In computer science, an interpreter normally means a computer program that executes, i.e. performs, instructions written in a programming language...
(Maxscript
Maxscript
MaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
) intended for developing web application
Web application
A web application is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is coded in a browser-supported language and reliant on a common web browser to render the application executable.Web applications are...
s based on the xBase
XBase
xBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
language dialect and conventions.
- Web applications built with DBFree are built around dynamic web pageDynamic web pageA dynamic web page is a kind of web page that has been prepared with fresh information , for each individual viewing. It is not static because it changes with the time , the user , the user interaction , the context A dynamic web page is a kind of web page that has been prepared with fresh...
s (identified by the .msp extension, that is automatically recognized by the interpreter, and parsed line-by-line in search of xBaseXBasexBase is the generic term for all programming languages that derive from the original dBASE programming language and database formats. These are sometimes informally known as dBASE "clones"...
code embedded between <% and %> markers). - Anytime valid xBase code is found it is processed by the interpreter, and the results of its logic (in the form of plain textPlain textIn computing, plain text is the contents of an ordinary sequential file readable as textual material without much processing, usually opposed to formatted text....
) are embedded in the exact position where the code was found. - This realizes true server-side scriptingServer-side scriptingServer-side scripting is a web server technology in which a user's request is verified by running a script directly on the web server to generate dynamic web pages. It is usually used to provide interactive web sites that interface to databases or other data stores. This is different from...
because the original code is never passed back to browserWeb browserA web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
, and all the calculations are done on the web server host. - HTMLHTMLHyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....
, JavascriptJavaScriptJavaScript is a prototype-based scripting language that is dynamic, weakly typed and has first-class functions. It is a multi-paradigm language, supporting object-oriented, imperative, and functional programming styles....
and xBase code can be merged seamlessly. Because the interpretation is taken before to pass the page to browser, xBase code can be used to feed Javascript functions with live data, in response to different contexts or conditions. - Database support is built-in into the interpreter, thus no other software is needed to feed data to web pageWeb pageA web page or webpage is a document or information resource that is suitable for the World Wide Web and can be accessed through a web browser and displayed on a monitor or mobile device. This information is usually in HTML or XHTML format, and may provide navigation to other web pages via hypertext...
s; the default drivers provided with installation package give access to standard DBFDBASEdBase II was the first widely used database management system for microcomputers. It was originally published by Ashton-Tate for CP/M, and later on ported to the Apple II and IBM PC under DOS...
tables (level 3) used by dBase III.
Other commercial drivers are available, including Clipper, FoxPro
Visual FoxPro
Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro which was developed by Fox Software beginning in 1984. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the...
, visual dBase and ODBC
Open Database Connectivity
In computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...
, but not included. Tables in use by the web application can be accessed via internet from remote clients using web browser concurrently with users using other software capable to manage the DBF file format on the LAN side, like the latest versions of dBase Plus.
- Web pages can also be written using dBase syntax, although in both cases (Clipper 87 or dBase syntax) only commands that make sense in the specific environment of a web page are recognized.Commands include logic branching with IF..ENDIF, looping with DO..WHILE, FOR..NEXT and DO CASE..ENDCASE. MaxScript commands and functions give complete access to host's file system with SET ALTERNATE or memoread and memowrite functions. The webserver (being the preconfigured XitamiXitamiXitami is a Web and FTP server, originally developed by iMatix Corporation as a free, open-source product from 1996 to 2000. It ran as a single process with a small footprint. It was not as fast as the fastest servers but scaled well. It supported several web application protocols and was very...
or the optional Apache) can be accessed programmatically modifying their initialization file and launching batch files with appropriate links. - DBFree is derived from Maxsis commercial product DBMax and maintained by volunteers sponsored by the original producers.
Programming in MaxScript
- All MaxscriptMaxscriptMaxScript command processor is an interpreter that implements a subset of the xBase programming language especially conceived to be used inside web pages to provide server side scripting capabilities....
instructions must be contained between <% and %> tags. Pages to be interpreted must have the .msp extension. - All pages are to be written in plain text using a text editor (or specialized web authoring tools).
A simple hello world application:
Hello World! Time is <% ? time%>
Another example: a FOR..NEXT loop:
These are the days of the week:
<%
declare aDays(7) //-- declaring an array of 7 elements
for iii = 1 to alen(aDays)
aDays[iii] := cdow(iii) //-- assigning name of the day (string) to array element
? aDays[iii] + "
" //-- printing list to web page
next
%>
Another example: using a DBF table:
Listing content of table CUSTOMERS.DBF:
<%
use CUSTOMERS index CUSTOMERS_BY_NAME key CUST_NAME
go top
do while not eof
? recno | CUST_NAME | CUST_ADDR | CITY | STATE html
skip
enddo
close CUSTOMERS
%>
MaxScript's DBFree implementation
DBFree offers a triple choice to programming with MaxScript:- Standard style
- Ajax mode
- MaxObjects.
All these techniques can easily coexist in the same application: it must be noted that the standard CGI style can be considered a first step to Ajax mode, that is its natural evolution.
Standard Style
The standard CGI programming style is typical of plain MaxScript code, offering maximum backward compatibility with Clipper and Xbase existing code.This programming approach consists into dividing all application logic into single tasks, where almost each operation is demanded to a specific pair of pages, one containing the HTML code for collecting user inputs (with a web form) and the sibling containing the MaxScript code for processing the data submitted by the form.
Main advantages of CGI-style programming:
- Does not depend from external libraries, so pages load faster
- Web forms are presented into static HTML pages relieving the CPU workload
- Code is clearer to read while all links are hardcoded into the pages
- Development is simple and can be done just using a browser with editing tools (like Firefox) because the code for each task is clearly isolated
Some notably disadvantages:
- The web applications tends to have lot of pages (thus becomes more complex to maintain)
- Development can be very tedious because of the higher number of pages to code and the exponential complexity of the resulting web site
- Without libraries most of MaxScript advanced functions won't be available
- Modularity (reusability of code) is greatly reduced while most of the code refer to fixed locations on host
- Every action requires the page to be reloaded (and this can be annoying for the user), even if in most cases using Javascript along with MaxScript can mitigate this inconvenience
Ajax mode
Javascript can be of great help into moving part of workload from server to user's CPU. It can also add lot of interactivity to web pages, especially if the user's browser supports Ajax asynchronous operations.Using Ajax most of the reloads typical of Standard Style programming can be avoided: more over, performances are greatly enhanced, because of caching mechanisms of modern webservers, with only a minor impact on server's CPU workload.
Incorporating Ajax consists mainly into redesigning the user interface so to have a clear division inside the page from static elements and dynamics ones.
Static element (that can be either HTML forms or HTML links) remain untouched inside the page, while dynamics elements (like
elements) and not the page itself become the target of MaxScript calculations, and are going to be updated "in place" without reloading the page.
With this programming style there is a single static web page (hosting all the necessary user interface) that drives the action, calling several active pages, each one providing only the results of data extraction or manipulation done in the background.
Main advantages of Ajax mode programming:
Some notable disadvantages:
Adopting Ajax with MaxScript should be accompanied with adoption of Json notation.
MaxObjects can be considered the web counterpart of the "objects" of an Object Oriented Language.
MaxObjects are standard MaxScript pages with specific structure that permits recursive calls of the page itself.
Even if MaxObjects can be built with plain MaxScript classic code, DBFree offers specific libraries to facilitate this task.
In theory a complete web application can be implemented with a single, large MaxObject: this simple web application can consists in a web made of a single web page that is loaded at the beginning without parameters and that stands waiting for user inputs to call itself after submission to react at the inputs.
MaxObjects' main advantages:
Anyway must be noticed that while developing for mobile the Ajax-style is generally not supported.
With this programming style there is a single static web page (hosting all the necessary user interface) that drives the action, calling several active pages, each one providing only the results of data extraction or manipulation done in the background.
Main advantages of Ajax mode programming:
- Results of data extractions can be shown while user is typing
- HTML grids can be made interactive, with "in place editing"
Some notable disadvantages:
- A good understanding of Javascript is required
- Debugging can be very difficult because it is not always clear what a certain page does (and how).
- FrontPage and other visual development tools get "fouled" by this technique (you will have a lot in "code view" not "design view")
- Ajax is a feature of the browser, not of the server. Anyway today almost every computer browser around supports Ajax.
Adopting Ajax with MaxScript should be accompanied with adoption of Json notation.
MaxObjects
MaxObjects are active pages written in MaxScript just like all other active pages we've seen so far, with some notably exceptions:- MaxObjects expects parameters
- MaxObjects are recursive (they repeatedly call themselves)
- MaxObjects can respond to the caller performing specific actions (usually MaxScript calculations)
MaxObjects can be considered the web counterpart of the "objects" of an Object Oriented Language.
MaxObjects are standard MaxScript pages with specific structure that permits recursive calls of the page itself.
Even if MaxObjects can be built with plain MaxScript classic code, DBFree offers specific libraries to facilitate this task.
In theory a complete web application can be implemented with a single, large MaxObject: this simple web application can consists in a web made of a single web page that is loaded at the beginning without parameters and that stands waiting for user inputs to call itself after submission to react at the inputs.
MaxObjects' main advantages:
- MaxObjects can be implemented so to be shared between different applications through the use of parameterization
- There is no need to know the internal mechanisms of a MaxObject to make use of it: it is enough to provide the necessary documentation of necessary parameters
- MaxObjects can include thousands of lines of code without any impact on performances: only the branch of code relevant to parameters passed is executed
- MaxObjects may call other MaxObjects in a circular way taking advantage of webserver caching mechanisms
- Reusability of code: pieces of code can be easily moved from an object to another (providing they all use the same libraries and headers)
DBFree and mobiles
MaxScript is well suited for developing data-centric web application for mobiles. Writing such applications is considerably simplified by the extreme compactness of the pages for mobiles when unburdened from HTML beautifying code.Anyway must be noticed that while developing for mobile the Ajax-style is generally not supported.
External links
