FILEPRO ON WIKIPEDA!!!

Harry K. Whacker harry.whacker at gmail.com
Wed Feb 1 11:46:57 PST 2006


Hey gus i forgot about the email list but i found it agian on the "WIKIPEDIA"
i was reading the page and and it says that fliepro is made from the
1970and that is not very good anymore??? just wondering. i used "
copy" and "paste" here it is:

 Kindly,
HK Whacker













Your continued donations help Wikipedia grow!
 FilePro From Wikipedia, the free encyclopedia Jump to: navigation, search
 *The correct title of this article is filePro. The initial letter is
capitalized due to technical restrictions.*

filePro is a proprietary DBMS and RAD system developed by Howard Wolowitz as
The Electric File Clerk in 1978, licensed it to Tandy in 1979 who first
published it in 1980, the same year that The Small Computer Company became a
corporation.

Although there was a Profile for the I/III/IV, they were not made by Small
Computer. filePro today started out on the Model II and first released by
Tandy as "Profile II". It is currently the property of fptech, Inc.

Data is stored in B-tree files, and all records are of fixed length. This is
not a true relational database, because it does not satisfy Codd's 12 laws.
It does, however, allow for rapid prototyping of curses-like screens, and
add-on products are available for ODBC interoperability, Common Gateway
Interface-like functionality, and even a form of SQL peculiar to filePro.

Furthermore, there is a small, dedicated community of developers, and there
is a mailing list based at
http://mailman.celestial.com/mailman/listinfo/filepro-list and a voice
chatroom available at http://www.valar.com/fp_room/fp_room_enter.htm

The programming language is similar to BASIC and COBOL. Variable names are
one or two letters, and all variables are global within processing. Every
line of code is an IF-THEN statement with a maximum of 121 characters for
the IF condition and 121 for the THEN code. It does not offer code blocking,
although it does allow some commands to be semicolon-separated on the same
line. Labels and GOTO statements can be used to simulate if-then code
blocks. It does not offer any looping or control structures; these must be
simulated using labels and GOTO. It does offer a GOSUB for subroutines,
which must be defined in the same file. It does offer a CALL statement which
allows calling of code in different files, but is difficult to use and
maintain (requiring parameter variables to be identically declared in three
different files).

filePro was designed for rapid application development and deployment in the
late 70s and has seen very little development or expansion since in its
fundamentals. It is the archetype of the monolithic architecture paradigm,
and the lack of built in looping and control structures usually results in
reams of spaghetti logic code. Modern features bolted on later are almost
completely useless. ODBC is solely read-only and must be purchased at an
additional cost (something of a rip off, as using textfile ODBC to filePro
data stores works just as well). There are no APIs or other interfaces for
interoperability for filePro. It does offer extremely primitive web page
serving thru a CGI module (purchased separately), but this is almost useless
as it cannot be integrated with any other web technology. It has an SQL
module (purchased separately) that is completely unoptimized, so even a two
table join can take hours even on a lightning fast system. Like the ODBC
module, it too is read-only. filePro is completely unsuitable as a backend
for anything other than filePro applications using the filePro text-based
user interface (a fpGUI module is available, but almost identical to the
text-based interface).

filePro is only useful for completely isolated systems that require very
simple data entry and reporting.
 Retrieved from "http://en.wikipedia.org/wiki/FilePro"

Categories<http://en.wikipedia.org/w/index.php?title=Special:Categories&article=FilePro>:
Articles whose titles are initialed a lowercase
letter<http://en.wikipedia.org/wiki/Category:Articles_whose_titles_are_initialed_a_lowercase_letter>|
Database
management systems<http://en.wikipedia.org/wiki/Category:Database_management_systems>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060201/6e77eee3/attachment.html


More information about the Filepro-list mailing list