PARADOX COMMON QUESTIONS AND ANSWERS

PPROG

   1.  The  Paradox  3.0  Personal  Programmer  has  generated  a
       problem that returns "QEDIT not found."

       This can happen  if  the user modifies the application and
       does  not  change  anything,  then the Personal Programmer
       does not rewrite the qedit and utl scripts.

       The workaround is  to  go into the Personal Programmer and
       modify the application  by  selecting the menu action.  Go
       through the prompts and select <R>evise, but do not change
       anything.  Then, exit out to Paradox and  play  the script
       "APNAMELIB.SC".


   2.  I  am  running  Paradox on a network and when I try to run
       the  Personal  Programmer,  I  get  the  message  "Out  of
       memory."

       The Personal Programmer was not designed to be a multiuser
       program.  It requires a total of 580K free to run  it, and
       with that much RAM you will  not  be able to build much of
       an application before you run out of RAM.  The bottom line
       is  that  you  need as much free memory as you can come up
       with.

       When the network drivers  are  loaded,  you will have much
       less than the 580K necessary.    Consequently,  you cannot
       run PProg on a network.

       Instead,  install  and  run  the  PProg  on  a stand-alone
       machine, then after  the application is complete, transfer
       it to the network server.   The following steps will allow
       you to install PProg on a local hard disk of a node on the
       network:

       a)  While linked to the network server, create a PARADOX2
           directory on the local hard disk.
       b)  Copy all the files from the PARADOX2 directory on the
           network server to the local PARADOX2 directory.
       c)  Install the PProg using the A:PINSTALL program.
       d)  Set the node to run in stand-alone mode.  (Eliminate
           all network drivers and TSR's)
       e)  Log on to the new PARADOX2\PPROG directory and type
           "PPROG" to make sure it has been installed correctly.
       f)  Once you have verified that PProg is OK, you can
           delete all the files from the PARADOX2 directory.
           They only need to be present when installing PProg.
       g)  Build your application using the local hard disk.
       h)  Transfer the completed application to the network
           server.












       i)  In interactive Paradox, run the -----LIB.SC script to
           rebuild the libraries in the new directory.  Refer to
           page 128 of the PProg manual for script name
           explanations.


   3.  I  just  modified  my  Personal Programmer application and
       added a menu action that will play a PAL script  I created
       in Paradox.  When I go to play my application,  it appears
       as if the application has not been updated.

       Whenever  you  make  a   modification   to   the  Personal
       Programmer application, you should go out  to  Paradox and
       play a script with  the  name  "APPNALIB" where "APPNA" is
       the name of your application and "LIB" stands for library.
       This script will rebuild your application library.


   4.  When I was running my  application that I created with the
       Personal Programmer, I received the error message "Unknown
       object type."  What does that mean?

       Unknown object type means  that  your  application library
       file is damaged.   To  rebuild the library file, go out to
       Paradox and  play  the  script  called  "APPNALIB"  (where
       "APPNA" is the  name  of your application and "LIB" stands
       for library).


   5.  I recently purchased Paradox 3.0 and was trying to use the
       Personal Programmer.  After typing "PPROG" I  received the
       error message "Out of memory."  I have 2  MB  of  extended
       memory on my PC.  How can I possibly be out of memory.

       Paradox 3.0  does not recognize extended memory.  It does,
       however,  recognize  expanded  memory.   There are several
       programs on the market that  will  enable  you  to convert
       your extended memory to expanded  memory.  In order to run
       the Personal  Programmer, you will need a minimum of 580K.
       To  verify  how  much memory you actually  have  prior  to
       running  the  Personal Programmer, perform  a  chkdsk  DOS
       command.  This will return  the  available  bytes  free in
       RAM.  It is recommended that you have a minimum of 595K on
       your PC if you want to run the Personal Programmer.


   6.  I am playing  an  application created with the Paradox 3.0
       Personal  Programmer  and  when  I  try to edit  with  all
       records I get "Answer table not found."

       There is a  problem  in the Personal Programmer of Paradox
       Version  3.0.    A  simple  EDIT  with  ALL  Records  will
       sometimes result in an  error  "Answer  table  not found,"
       when there should not be any answer table.



                              - 2 -








       Solution:

       A piece of code generated by PProg is not  correct.    The
       only way to repair it is to edit the script and remark out
       (;) several lines of code.

       To find  the appropriate lines of code, start Paradox3 and
       change to  the  directory  containing  your  own  Personal
       Programmer application.

       --Play  your  application  (if  its  name  is  Video, play
       Video).

       --At your application's  Menu, Press <Ctrl><Break> (it may
       beep).

       --NOW, select  the menu choice that has been troubling you
       with the message "Answer table not found."

       --You should see <C>ancel <D>ebug as choices.

       --Choose <D>ebug.  A line  of code will appear at screen's
       bottom.

       --Press <Ctrl><S> several times  in  succession  until the
       line of code at screen's  bottom  reads:  Create "Deleted"
       like "Answer".

       --Press <Ctrl><E> to enter  the  script  at  the displayed
       line.  Place  a  semicolon  in  front of this line and the
       next seven lines of code as follows:

       ;  Create "Deleted" like "Answer"
       ;  If (ApplicErrorRetval) THEN
       ;      RETURN FALSE
       ;  ENDIF
       ;  View "Deleted"
       ;  If (ApplicErrorRetval) THEN
       ;      RETURN FALSE
       ;  ENDIF

       --Press <F2> to save the changed script.

       --Do <S>cripts, <P>lay, <V>ideolib (if your application is
       Video).   (There will be a script  with  your  app's  name
       +LIB.)  This will rebuild the application's libraries.

       That  should solve the problem.   These  steps  should  be
       followed  for each of your Menu  choices  which  have  the
       "Answer table not found" irregularity.


   7.  I am using  the  video tutorial in the Personal Programmer
       and I am  trying  to create the multi-table application on



                              - 3 -








       page  45 of the Personal Programmer  Guide.    The  manual
       indicates that there is an order form #2 and I cannot find
       this form on my diskettes.  Am I doing something wrong?

       Order form #2 was not included on your diskettes.  We will
       be  happy  to  send you a new copy of the orders table and
       the forms associated with it.


   8.  I am using the Personal Programmer and I  cannot  edit the
       key fields of my table.

       When editing with queries or multi-table views, the tables
       must be keyed and  the  key  fields  should not be edited.
       The reason for  this  restriction  is  that  when selected
       records are  edited, Paradox uses the key fields to return
       the records to their original location.


   9.  I am trying to  use  the Personal Programmer.  I created a
       directory for my application and when I typed "PPROG" from
       that directory, I got  the  error  message "Bad command or
       file name."

       You should modify your AUTOEXEC.BAT file  located  in your
       root directory (ie.  C:\) and add a path command that will
       instruct   the   operating   system   to   look   in   the
       C:\PARADOX3\PPROG directory.  For example:

       PATH=C:\;C:\PARADOX3;C:\PARADOX3\PPROG


  10.  I am using the Personal Programmer and I have set  up some
       validity checks.  When  I  play  the application and press
       <F1>, I cannot access my table lookup.

       There is a  problem  with the Personal Programmer with the
       way it writes scripts.  In the section of the script where
       the application is in a  WAIT TABLE, you should remove the
       UNTIL "F1" from the script.


  11.  I am using the Personal Programmer and have created a view
       where I am using the tilde  variable.   I want the user to
       be able to use  a  pattern match like "S..".  The Personal
       Programmer does not accept this.

       If a variable is equal to a pattern match  (ie.    x=S..),
       the tilde variable will not work.  Instead,  create  a PAL
       script which will bring up a query form and MOVETO  to the
       field name and TYPEIN the variable.

       MOVETO [Fieldname]
       TYPEIN x



                              - 4 -








       Then,  you can add this script as a  menu  action  in  the
       Personal Programmer.























































                              - 5 -