Home Products Support News Downloads Company
 
Frequently Asked Questions (FAQ) Index
Use the Jump Links below to quickly find what you're looking for.
Company Edits Menus Screens
Configuration Errors Printing System
Data Interchange General Processing Utilities
   
Company  
  What is filePro?
  Who Invented filePro?
  How long has filePro been around?
  What kind of products and services do you offer?
  What platform(s) can filePro run on?
  How can I get your products and/or services?
  Are you Y2K compliant?
Back to Top
Configuration  
  Why doesn't filePro Plus v4.5 respond to my PFTOKSIZE setting in the config file?
Back to Top
Data Interchange  
  How can I access data from a filePro data base with another program?
  How do I create an export file for doing mail merge in to Microsoft Word?
  I need to port some databases over from filePro v4.0 for SCO UNIX to filePro v 3.0 for MS-DOS. Is there any reasonable way to do this without the use of serial ports?
  Is filePro ODBC compliant?
Back to Top
Edits  
  My boss insists on using special characters in some customer names but I don't want to print them on my reports. Is there an easy way to do this?
Back to Top
Errors  
  In filePro 5.6, I'm getting 'licensed count exceeded' messages on SCO before my licensed number of sessions has been reached. What do I need to do?
  Why do I get an error 'too many open files' when my config.sys is set to FILES=70?
  How can I eliminate 'permission denied' errors for lockfiles on my Netware network?
  Why do I get "tokenization too small" even though I have -t 190000 for my input processing which is only 113000 tokensize?
  I keep getting the error ‘too many open filePro files’ on my UNIX system. What am I doing wrong?
Back to Top
General  
  We are an end-user of filePro and need changes made to our programs. How do we find a filePro programmer in our area?
  Is there a way to remove or retrieve the passwords that have been left on files and .prc tables?
  How can I get my dates to display properly with an old version of filePro?
Back to Top
Menus  
  I am always deleting the FP$$XXXX.bat files. Is there any way to keep them from being left in the menu?
Back to Top
Printing  
  How can I print locally from my UNIX terminals and via modem?
  filePro reports are not printing properly on my new Laser printer. How can I eliminate the print starting about 6 lines down from the top of the page?
Back to Top
Processing  
  I have several lookups to the same filename with different aliases. When closing one, why do they all close?
  I need to set an array of 126 fields to the value of "0" (zero). What is the best way to do this?
  When running a 'call' from a process table, is there a way to close the 'call' and load a new version of the 'call'?
  Some of my old data files have periods or dashes instead of slashes in date fields. How can I make them all slashes?
  I am confused about how dummy fields work across processing tables. Can you enlighten me?
  Why am I getting an error on the following MID statement after converting to filePro Plus 4.5?
  Someone told me that I could use a call from within a call. I get a nested call error. What's up?
  Is there a way that I can edit my filePro processing tables with my favorite text editor?
 

After upgrading to filePro Plus 4.5 I received the following error.

Fatal Error
Invalid opcode 55 in token table, Line 1, offset 10

How Can I correct it?

Back to Top
Screens  
  I do not want a browse window to popup and tell my users 'no matching records found'. How can I display my own message?
  I recently upgraded to SCO UNIX Open Server 5 and now my filePro menus display strange letters and numbers for the boarders of the menus. Why did this occur?
  My screen keeps flashing when I do a SYSTEM call to Word Prefect. Any suggestions?
  Is there a way to edit my screens with a text editor?
Back to Top
System  
  Is filePro compatible with Windows VISTA?
  Why does filePro Plus 4.5 reboot my computer when I try to run it?
  Why do I not hear a "beep" anymore when running filePro since upgrading my DOS machine to Windows?
  Why doesn't PFOUTS work after upgrading from DOS to Windows 95/98?
  We are experiencing frequent DOS4GW error 2001's with reference to memory addresses. Why am I getting these errors?
 

I created a new file and then went back to modify the structure. When I exit the define file screen I get the following error:

Checking Free Disk Space Before Restructuring.
Not enough disk space to restructure file.

There is 2 GB of free space. How can I correct the problem?

  What are the minimum system requirements for running filePro 4.5 DOS/LAN?
  How do I find out what key mapping is on my terminal?
  Why can't I get filePro to recognize my mapped drive Z on my network?
  What the best memory size for my AIX/LINUX/UNIX file server?
  What do we need to build a LAN using filePro?
  Why do I sometimes get different results when executing menu options from a batch file and a command line?
  I am confused as to how @WUK is related to F3, F4, and F9. Why do all three keys seem to trigger the @WUK label?
  Which ‘termcap’ file does filePro Plus use in SCO UNIX?
  How do I close a 'USER=' shell?
Back to Top
Utilities  
  How do I use the "autoshuf" utility?
  I recently received a UNIX taz type compressed file. What is the command for uncompressing this?
Back to Top

 

Answers

Q: What is filePro?

A: fP Technologies, Inc. offers several product lines ranging from a very robust database management system, to HTML tools, and electronic health claim products. Our company has been a provider for over 20 years, servicing developers, OEMs, insurance companies, and large industries with data manipulation solutions.

Back to Top

Q: Who Invented filePro?

A: This product was developed by the company in 1978 and has been through major innovations and enhancements.

Back to Top

Q: How long has filePro been around?

A: Our company has been a provider for 25 years, servicing developers, OEMs, insurance companies, and large industries with data manipulation solutions.

Back to Top

Q: What kind of products and services do you offer?

A: The company has built its history around a powerful data base engine and rapid application development interface. Another most attractive benefit of the company's product offerings is the data and code transportability from platform to platform and operating system to operating system. Following a 1998 financial and ownership restructure, fP Technologies, Inc. is now positioned for a rapid growth curve with a full range of cross-platform GUI based applications, interfaces and tools.
fP Technologies, Inc. offers several product lines ranging from a very robust database management system, to HTML tools, and electronic health claim products.

Back to Top

Q: What platform(s) can filePro run on?

A: filePro has an installed base of over 200,000 end-users in a text based environment, with 60% of its customers using UNIX or Linux. This product has been proven as a high volume, text based, lightning quick database and application generator. It is available for Unix, Windows 95/98/2000/NT, Linux, and Sun Solaris, HP-UX, IBM AIX, and IBM eServer iSeries.

Back to Top

Q: How can I get your products and/or services?

A: Our programmers and support owners reside around the country and are linked by the latest technology in communications to assist each other in reacting to our customers' needs as quickly as possible.
Check out the Applications page for your geographical area and needs.

Back to Top

Q: Are you Y2K compliant?

A: Yes!! FastEMC Software Version 6.1 and all of our other products are Y2K compliant. Please note that the hardware/operating system that it runs on must be Y2K compliant in order for Y2K compliance to be met.

Back to Top

Q: Why doesn't filePro Plus v4.5 respond to my PFTOKSIZE setting in the config file?

A. Our testing shows that 4.5 properly recognizes the settings of the config file. The problem may be that you overriding these settings in your environment or by a menu flag. Check your environment settings by typing "set"

Back to Top

Q: How can I access data from a filePro data base with another program?

A. You can write a .prc table and use the 'export' function to output filePro data in various formats including Word, WordPerfect, DIF and Multiplan.

Example:

Line 1 --- Then: export word fil = \myfile

Line 2 --- Then: fil(1) = 2; fil(2) = 3; fil(3) = 6

Line 1 opens a file named myfile.wp in the root directory of the current Line 2 exports the content of field 2 as the 1st element in the output, then field 3 and 6 as the 2nd and 3rd elements. The data exported in the example will be standard CSV format so each field will be delimited with quotes and a comma.

"data_in_field_2","data_in_field_3","data_in_field_6"
Note: You also need to create a "process only" format with the same name as the processing table name you assigned. Use the "define output" option to create the "process only" format.

Back to Top

Q: How do I create an export file for doing mail merge in to Microsoft Word?

A. In your processing table, use the following.

::export word fil=yourfile.txt:
::fil(1)=1;fil(2)=2;fil(3)=3:

This will create a csv file that you can copy or move to your Word directory. Then you can set the file up as your data source within Word for mail merge.

Back to Top

Q: I need to port some databases over from filePro 4.0 for SCO UNIX to filePro v 3.0 for MS-DOS. Is there any reasonable way to do this without the use of serial ports?

A. fpTransfer is used for transferring data between machines. However, you can only transfer from the same or older (lower) version to the same or newer (higher) version of filePro. There is a new flag that will allow you to do something else to the communications part, like send the transfer to a file, a tar tape or FTP connection. The new flag is -lf then you specify a filename which can be a device or that filename will then be created.

You need to have version 4.1 or higher. To upgrade and/or buy the DOS or UNIX fpTransfer, please contact our sales department at 1-800-847-4740 or sales@fptech.com

Back to Top

Q: Is filePro ODBC compliant?

A. filePro has provided many features for 'importing' and 'exporting' of data, however, at this time it is not ODBC compliant.

Back to Top

Q: My boss insists on using special characters in some customer names but I don't want to print them on my reports. Is there an easy way to do this?

A. You can either trap them with instr and replace them at the position returned or you could write a local edit to accomplish most of what you want. A sample edit would be:

rmspc ^~{!"/"! | !":"! | !"@"! | !"%"! | *}

This edit called 'rmspc' will remove /:@% and accept all other characters. Certain characters that are control characters for the Edit program can not be removed this way, such as the !

Back to Top

Q: In filePro 5.6, I'm getting 'licensed count exceeded' messages on SCO before my licensed number of sessions has been reached. What do I need to do?

A: Please go into the main filePro Menu and view your license information.
If your license is using your MAC address for verification and have a minimum of 15 simultaneous users, this licensing issue was resolved in filePro 5.6.05s

Please download this from our website:
http://www.fptech.com/Download/drequest.shtml

You will need your license number and registered email address to access the download.

There is no cost for this update.

If your license is not using the the MAC address for verification, if you have less than 15 simultaneous users, or if you have already installed 5.6.05s and are still having problems, please contact Technical Support at 1.800.847.4740 or fpsupport@fptech.com

Back to Top

Q: Why do I get an error 'too many open files' when my config.sys is set to FILES=70?

A. On a network, each workstation must have its own config.sys to set the working environment. This would include a files line. Review the standard config.sys located in this section of the FAQ's. Also, make sure that PFFILES is set to a number high enough to handle your processes. 255 is the maximum allowed under DOS and Windows. The PFFILES number must be less than the config.sys files number.

Example: If the config.sys is set to files=100, set PFFILES=80.

Back to Top

Q: How can I eliminate 'permission denied' errors for lockfiles on my Netware network?

A. filePro requires that a lockfile be sharable. It is possible that the version of Netware is not respecting the request to open the file shareable or there is some other non-filePro program running that has the lockfile opened as non-shareable. This is sometimes reported as a 0x20 error by DOS

Back to Top

Q: Why do I get "tokenization too small" even though I have -t 190000 for my input processing which is only 113000 tokensize?

A. You probably have a 'call' processing table. Use the -tf flag to set the tokensize for 'call' processing.

Back to Top

Q: I keep getting the error ‘too many open filePro files’ on my UNIX system. What am I doing wrong?

A. Even though most UNIX systems will operate correctly using the defaults set at install, some configurations will give this error unless the kernel is tuned. Try using a value of 60 for the number of maximum files per process (NOFILES) and reboot the computer. On SCO Open Server 5 with filePro 4.5 set NOFILES equal to 120. Higher or lower on some systems may cause problems.

Back to Top

Q: We are an end-user of filePro and need changes made to our programs. How do we find a filePro programmer in our area?

A. Contact our Sales Department for a list of developers in your area at 1-800-847-4740 or sales@fptech.com

Back to Top

Q: Is there a way to remove or retrieve the passwords that have been left on files and .prc tables?

A. With proper authorization, which must include proof of purchase, fP Technologies Inc. can remove the site and table passwords. Contact sales at 800-847-4740 or sales@fptech.com

Back to Top

Q: How can I get my dates to display properly with an old version of filePro?

A. Even though older versions had many of the Y2K abilities with 10 digit date formats and recognition of the year 2000 as a leap year, only versions 4.5 and later are year 2000 compliant. With the Y2K compliant versions, all you have to do is set an environment variable to mark the century using (PFCMARK). You set the environment variable PFCMARK=nn, where nn is the century mark. For example if you set PFCMARK=70, then the two digit year will go from 1970 to 2069. Very easy, no additional programming may be necessary. Another example would be if you set PFCMARK=00, the two digit year will go from 1900 to 1999. You can call our sales department for pricing on your platform at 1-800-847-4740 or sales@fptech.com

Refer to the Y2K links at this web site for additional information.

Back to Top

Q: I am always deleting the FP$$XXXX.bat files. Is there any way to keep them from being left in the menu?

A. These files are created every time that a menu batch is executed. They will most always be deleted when the user exits back to the menu. One reason they do not get deleted is an abnormal exit of the program or within the batch file there is a 'CD' to another directory without returning to the original directory where the menu was executed so the program can't find it to delete it.

Back to Top

Q: How can I print locally from my UNIX terminals and via modem?

A. If you add the -PT flag to the command line or menu option or set PFPT=ON in the environment, you can print to a local printer. You must make sure that termcap entry for PS and PT have been entered for the terminal type. If you don't know the correct entry, try PS=^T and PT=^R

Back to Top

Q: filePro reports are not printing properly on my new Laser printer. How can I eliminate the print starting about 6 lines down from the top of the page?

A. Laser printers are usually set at the factory to default to 60 lines of printing. When this condition occurs, you should change the default on the printer to 66 lines by following the manufacturer's instructions. If you have lost your printer manual, contact the manufacturer for a replacement or check their web site.

Note: You can also reformat the reports and forms to be 60 lines but this is usually not the preferred method.

Back to Top

Q: I have several lookups to the same filename with different aliases. When closing one, why do they all close?

A. The normal function of multiple lookups to the same filePro file will only open the file once. Its resources (open file handles, indexes, field descriptions, etc.) are shared. Therefore, CLOSE on a specific lookup would be meaningless if it didn't close the file.

Note: The purpose of using a name in a lookup is two-fold. First, it lets you assign a shorter or more descriptive name. Second, it allows you to have multiple records from the same file in memory at the same time. That means that filepro allocates separate buffers for each name you use in a lookup. Unless you need multiple records from a file, it's better to use only one name for all lookups to a single file.) Thanks to author:

Back to Top

Q: I need to set an array of 126 fields to the value of "0" (zero). What is the best way to do this?

A. If the array is dimensioned, the easiest way is in 4.5.X with the set array,"0" command. Otherwise, you would need to do a processing loop to set the value. An example table follows.

loop:if:n lt "126":
:then:n(3,.0)=n+"1";array(n)="0";goto loop:

Back to Top

Q: When running a 'call' from a process table, is there a way to close the 'call' and load a new version of the 'call'?

A. filePro leaves the 'called' processing open to improve application performance. If you want to close it, add an 'empty' processing table and simply 'call empty' before calling the real one again. This will close the original and then reopen a new session when it is called again.

Back to Top

Q: Some of my old data files have periods or dashes instead of slashes in date fields. How can I make them all slashes?

A. Use processing to add zero to the date and the result will contain slashes.

Back to Top

Q: I am confused about how dummy fields work across processing tables. Can you enlighten me?

A. Dummy fields which are declared in automatic processing are accessible to all processing tables including sort/select and take on the attributes defined in automatic processing. The statement on which the field is declared need not be executed.

In QuickStart, if you are going to run a report with a "-y" flag to override automatic processing, the output processing needs to be compiled with rcabe using the same "-y" flag. Actually, it is only a requirement if you are using a dummy field in the output processing to do totaling and the field is declared in the default automatic table but not in the "-y" table or vice versa.

Back to Top

Q: Why am I getting an error on the following MID statement after converting to filePro Plus 4.5?

hi=mid(pi,1,2); mi=mid(pi,3,3)

A. A very early version of filePro (Profile) allowed this syntax. Under all versions since 2.0, the position indicators must be in quotes when specifying literals. Change the line to read

hi=mid(pi,"1","2")

Back to Top

Q: Someone told me that I could use a call from within a call. I get a nested call error. What's up?

A. You can NOT make a call from within a call.

Back to Top

Q: Is there a way that I can edit my filePro processing tables with my favorite text editor?

A. If the environmental variable ABE=ASCII is set, when you edit the .prc table with the filePro editor and save it, it will be saved in ASCII format. You can then edit this file with any text editor. Add something when you first create the .prc so the syntax is obvious.

Caution: Some delimiters in filePro are really control characters in editors. Make sure that you run your edited prc's through the syntax check using the filePro editor before executing to avoid 'filePro errors'.

Back to Top

Q: After upgrading to filePro Plus 4.5 I received the following error.

Fatal Error
Invalid opcode 55 in token table, Line 1, offset 10

How Can I correct it?

A. Retokenize (rcabe) the .prc table and the error should go away.

Back to Top

Q: I do not want a browse window to popup and tell my users 'no matching records found'. How can I display my own message?

A. Add the -s flag to the lookup with the -nx flag and filePro will not show the browse window unless matching records are found.

Back to Top

Q: I recently upgraded to SCO UNIX Open Server 5 and now my filePro menus display strange letters and numbers for the boarders of the menus. Why did this occur?

A. This occurred when a change was made to have the termcap more cross compatible. SCO made changes to their default console emulation. One way to fix is to try a restored older version of the /fp/termcap file. However, the recommended way is to fix the graphics on the console by commenting out the line:

/usr/bin/mapchan -a 2&>/dev/null

from the /etc/rc.d/6/kinit file. This will take effect after you reboot the computer.

Back to Top

Q: My screen keeps flashing when I do a SYSTEM call to Word Prefect. Any suggestions?

A. Try using the SYSTEM NOREDRAW command. It suppresses the redrawing of the current screen.

Back to Top

Q: Is there a way to edit my screens with a text editor?

A. No. These files are stored in binary with cursor control, field designators and color control. This is too complicated for a text editor and the reason we provide the screen editor program.

Back to Top

Q: Is filePro compatible with Windows VISTA?

A: filePro versions 5.0 and 5.6 will run on Window's Vista operating system.

When installing on Vista, do not install the programs (/fp directory) nor data (/filepro directory) in the root directory.
We suggest that you specify a parent directory for filePro's reserved directories e.g. c:\appl when doing the install and install the programs in c:\appl\fp with data in c:\appl\filepro.

If you have upgraded your system from an earlier version of Windows to Vista, and filePro is currently installed in the root of your system, you will need to move the /fp and /filepro directories to a parent directory as previously described and modify your shortcuts/batch files to specify the new path.

Back to Top

Q: Why does filePro Plus 4.5 reboot my computer when I try to run it?

A. filePro Plus 4.5 is technically a 32-bit program. You must have a 386 MHz computer or higher. If your computer will not execute 32-bit code, filePro Plus 4.5 will not run. The Operating System and Network must support one or more of the following protocols: DPMI, VCPI, and/or XMS. Upgrade of your hardware and/or operating system would be recommended.

Back to Top

Q: Why do I not hear a "beep" anymore when running filePro since upgrading my DOS machine to Windows?

A. On most machines (not all) the speaker is controlled by Windows. Check your Sounds in the Windows Control Panel and make sure you have a sound selected for the Default Sound. If you don't have a sound card, your PC Speaker should work as normal.

Back to Top

Q: Why doesn't PFOUTS work after upgrading from DOS to Windows 95/98?

A. Windows handles the serial ports differently than DOS. Windows only allows single program access to the com port at any given time. Once the first filePro program accesses the port, no other program will be allowed access until filePro exits. In reverse, if Windows initializes the port for some WIN application such as a FAX or Internet Access program running in background or foreground, filePro will not be able to access the com port.

Back to Top

Q: We are experiencing frequent DOS4GW error 2001's with reference to memory addresses. Why am I getting these errors?

A. There are many of reasons to get a DOS4GW error 2001. Make sure you do not have any auto indexes on a system-maintained field like @cd, @rn or @td. Another reason is that there might be multiple copies of DOS4GW residing in ‘PATH’ed locations. Also, turn the internal version number (SET PFVER=ON) and then go into Inquire , Update and Add. When the screen comes up to the enter filename prompt there will be a number in the upper right corner. This number should be 4.05.07 or greater. Also, verify that you have DOS4GW version 2.01a by typing DOS4GW at the command prompt.

Another possibility is that you may have an index built on a field that no longer exists. Make sure that indexes are built on valid fields that are in your data base.

Back to Top

Q: I created a new file and then went back to modify the structure. When I exit the define file screen I get the following error:

Checking Free Disk Space Before Restructuring.
Not enough disk space to restructure file.

There is 2 GB of free space. How can I correct the problem?

A. You need to set an environment variable PFNODF=ON;export PFNODF. That will stop filePro from checking free disk space.

Back to Top

Q: What are the minimum system requirements for running filePro 4.5 DOS/LAN?

A. It will run fine on a 386 with at least 1 MB of free extended memory.

Back to Top

Q: How do I find out what key mapping is on my terminal?

A. Keyboard mapping is pretty standard for DOS and Windows. On UNIX based systems, mapping can change based on terminal emulation. The key mapping can be obtained at any time within filePro by pressing the ESC-? combination under Unix, or Alt-F10 under DOS.

Back to Top

Q: Why can't I get filePro to recognize my mapped drive Z on my network?

A. The last drive letter that can be used for filePro is Y. Change your drive mapping.

Back to Top

Q: What the best memory size for my AIX/LINUX/UNIX file server?

A. The rule of thumb is to have 1MB for the first user and 1/2MB for each additional user.

Back to Top

Q: What do we need to build a LAN using filePro?

A. We have network versions of filePro Plus. They work on almost all networks including Novell, LANtastic, Win 95 and NT. All your filePro data will move over with no problem. To upgrade please call our sales department at 1-800-847-4740 or sales@fptech.com

Back to Top

Q: Why do I sometimes get different results when executing menu options from a batch file and a command line?

A. There are two main reasons for this. One is the obvious. The typed command line may be different than the menu item batch. The differences may not be in the script but in the environment that is being set by fpconfig. The other reason is because of special characters used in filenames and flags. It is a good idea never to use ~!@#$%^&*() and so forth in filenames or the names of prc. and out. tables. These characters can be passed differently depending on the operating system.

Back to Top

Q: I am confused as to how @WUK is related to F3, F4, and F9. Why do all three keys seem to trigger the @WUK label?

A. All those F keys go to the @WUK label. Use the @sk value to distinguish the difference for the key pressed.

Back to Top

Q: Which ‘termcap’ file does filePro Plus use in SCO UNIX?

A. filePro will use both the /etc/termcap file and the /appl/fp/termcap file. If the entry exists in both, filePro will use the one in the /appl/fp/termcap.

Back to Top

Q: How do I close a 'USER=' shell?

A. If your line was something like 'USER sysget=/bin/sh' then you would add a line 'CLOSE sysget'.

Back to Top

Q: How do I use the "autoshuf" utility?

A. "autoshuf" was designed to allow the developer to make 'map' changes and copy a new map to another system as 'map.new'. If 'map.new' is present in the <filename> directory and autoshuf is executed, filePro will restructure the file as if it had been changed manually.

The syntax is simply "autoshuf <filename>"

Back to Top

Q: I recently received a UNIX taz type compressed file. What is the command for uncompressing this?

A. From the directory where you wish it to be uncompressed type

zcat <filename>.taz | tar xvf

Back to Top

 

 
         
Copyright © 2005-2012 fP Technologies of Ohio, Inc. All Rights Reserved Privacy Policy Contact Us