This is a really long list, it may take a few seconds to load.

Source code for all functions included with library!

To jump to one of the main groupings of functions, select its name: Arrays Boxes Color Data Records Data Tables Data Types Dates Debugging Dialing Dialogs DOS Editing Environment Filenames Filters Financial Format FP Win Special Gambling Gets Help Hotkeys Indexes Input Libraries Math Measures Memo Fields Memvars Menus Nesting Network Print Print Drivers Programming Screen Search Security Sound Statistics Strings Telephone Text Style Time Windows ZIP Codes Arrays Build array to your specifications Stuff specified month to array Restore array from PDL system file Multi-select array Popup Check if array is one dimension Clone and existing array Compare two arrays Return T if data in column is specified type Quick comparison of data in two arrays Fill five columns in array with specified data Calculate longest character string in array Delete an array from the PDL system file Save an array to the PDL system file Return numeric data points in an array Restore array ADDITIVE from the system file Save an array to the system file Seek expression in named column of array Increase or decrease size of array Return specified data type count for array column Back to Top Boxes Return characters for making boxes Back to Top Color Complete color manipulation program Create default color sets Delete named PDL color set from PT_SYS file Display color sets available in PT_SYS Convert character color string to numbers Pick color pair by point and shoot Rename an existing Power Tools color set Restore a color set from PT_SYS Set read only flag in PT_SYS Save current color set to PT_SYS Stuff color pair at into a color scheme Return T if color set exists in FOXUSER Set color and return previous color string Back to Top Data Records Add new record to table Return next primary key number for a table Assign the starting number for primary key Return the number of blank deleted records Delete and blank a record Blank a field in a data table Return T if key for tables is in PT_SYS Calculate unique key string from last name Blank all fields in current record Back to Top Data Tables Number of decimal places Trimmed field length Compare two table structures Work area for table name Return update date of a data table without opening it Return record count of a data table without opening it Search file for search string dBASE IV compatibility function for FCOUNT() Return T if named file is a usable DBF file Return T if expression is valid field in table Check for expression in named file Manipulate a structure extended dbf Create an empty .FPT file for a data table Create an empty FoxPro resource file Create structure extended dbf Create Power Tools system file (PT_SYS) Return a number of work areas/return maximum buffer number for current FoxPro Check for available dbf buffer Check and open a buffer Back to Top Data Types Return T if variable is an array Return T if variable is empty Return T if variable is character type Return T if key pressed is a cursor key Return T if variable is date type Check for significant decimal places Return T if string starts with a number Return T if variable is a logical type Return T if variable is a memo type Return T if a variable is numeric/float Return T if variable is undefined Back to Top Dates Number of days in month Number of work days in month Week of year Return abbreviation for day of week Return day of the month with proper ending Return 3 character abbreviation of month Return 2 character abbreviation of year Pop dynamic calendar - return date Return character expansion of a date Return days remaining in year Return T is day of a date is between two days Return # of times day occurs between dates Return # of days since beginning of year Return the first day of specified month Return the first day of a specified quarter Force date to the specified day of the week The FoxPro calendar highly modified Return T if leap year Return the last day of specified month Return the last day of specified quarter Popup menu of months Return month +/- retaining day of month Return date +/- years Return date of next specified day of week Check if date falls on a weekend Return number of work days between dates Back to Top Debugging Save and clear the debug window Delete saved debug session Edit and save debug sessions Restore saved debug sessions Set debugging enhancements Release debugging enhancements Save from debug window Get PT_DEBUG value Compare 2 tables Capture total environment of error Displays pertinent data for current program Return error message for data type errors Create error message for parameter passing Debugging "Windows" into all PDL functions Measures speed of code alternatives Back to Top Dialing Convert telephone number to numbers Dial a telephone number Back to Top Dialogs Clear BIGLETT windows from the screen Put BIG letters on screen or in window Put a LARGE clock on the screen Pop alert window with a wrapped message Pop up error message Paint message dialogue, waits for key press Print message dialogue Paint warning dialogue, prompts to continue Display message in ticker tape format Release POPTALK window Back to Top DOS Running in MS Windows Load a directory tree structure to an array Create data tables containing directory data Menu of files meeting specified file skeleton Return DOS data of specified file Delete file from specified directories Move file pointer to ^Z in text files Return number of bytes in specified file Return DOS time stamp for specified file Return T if the drive/directory exist Return T if floppy drive is ready Create empty data table for DB_DIR Create table with DOS directory info Return/Change the number of DOS buffers Return and change the number of DOS files Check validity of directory Check validity of drive Back to Top Editing Change case highlighted text Lower case highlighted text Indent highlighted lines Outdent highlighted lines Propter () highlighted text Upper case highlighted text Set up PDL editor submenu Release editor submenu Back to Top Environment Return T if running Fox extended edition Return T if directory on FoxPro default + path Reset all SETs from set_ar Save all SETs to array Check SET BELL setting Set and return DBIV compatibility Set and return SET CONFIRM setting Set and return SET CURSOR setting Set and return the Default drive/directory Set and return SET DELETED setting Set and return SET ESCAPE setting Set and return SET MARGIN setting Set and return SET MEMOWIDTH setting Set and return SET NEAR setting Set and return SET ORDER setting Return current path -- optionally set new one Open PT_SYS, returns T if PT_SYS file is open Set and return SET RESOURCE setting Return name of current resource file Set the application environment Change or edit system variables Set your SETs to the Rubel standard Return path statement with subdirectories Return the version number as a number Back to Top Filenames Next name in file series Add backslash to the end of string if needed Force file extension on a file specification Return drive letter+colon from file spec. Return file extension from file spec. Trim drive, path and extension from file spec. Return unique file name (checked) Strip suffix from file name Strip the path from a full path name Back to Top Filters Select filter criteria by point and shoot Delete a filter in PT_SYS Edit a saved filter for a specified dbf Select a filter for a specified dbf Restore a filter saved to PT_SYS Save a filter to PT_SYS Master control program for Power Tools filters Back to Top Financial Calculate compound interest rate Calculate interest expense APR for loan Popup for compound interest rate Popup for interest expense Popup for APR loan calculator Discounted rate of return for even cash flows Discounted rate of return to uneven cash flows Future value of $1 annually Calculate future value Return factor for computing loan payment Present value of annuity Popup for loan amortization calculation Popup for DRR calculation -- even cash flows Popup for DRR calculation -- uneven cash flows Exit Popup for all financial functions Popup for future value of annuity Popup menu for all financial functions Popup for future value calculation Popup for loan payment calculation Popup for present value of annuity Popup for present value calculation Return present value of future amount Back to Top Format Return centered string Stuff number string with numeric commas Add CHR(10) + CHR(13) to a character string Return trimmed char string of numeric value Enable user to edit with an active format file Add pad spaces to the end of a string Return specified PICTURE template Pad a proportional string with spaces Return right justified number string with "$" Return negative number in parentheses properly Place a space between each char of string Back to Top FoxPro Windows Special Return column location to center string Return T if font is proportionally spaced Return # of proportionally-spaced lines in string Return proportionally-spaced line Like PADC() for proportionally-spaced fonts Like PADL() for proportionally-spaced fonts Return column position for right justified text Return screen column based on decimals Calculate screen columns based on font Return number of pixels in screen column Return screen row based on decimals Return number of pixels in screen row Return column size of window in parent font Return maximum column that keeps window on screen Return maximum row that keeps window on screen Back to Top Gambling Begin a blackjack program Sum blackjack card array (aces = 1 or 11) Create the back of a card Cuts a deck of cards in a random fashion Create a new deck of cards Create a playing card from card deck Shuffle cards Return the blackjack value of a card Create the front of a specified card Roll dice Back to Top Gets Allow cursor to change dates in a GET Check for incomplete data in GET Set up a date GET for cursor Validate marital status input Force entry to get field Read using format files Performs view and edit of multiple GET files VIEW contents of multiple GET screens Dummy automatically trips the VALID Reset OKLs after a date field get terminates Emulates READ without disturbing GETs Dynamic access to memvar during READ Emulates a calculator type numeric entry Does a single screen edit on a data table UDF for VALID clause to replace RANGE Back to Top Help Display help index Create help system Develop and display FoxHelp style help Power Tools Help program Set up system for Fox-Style help Set up table-driven context sensitive help Back to Top Hotkeys Handle mouse double-click detection Return set ON KEY LABELS in an array Restores OKL from an array Back to Top Indexes Load array with index infor Reindex table from array FOR clause of an index Reindex from data in PT_SYS Save index array to PT_SYS Index tag is UNIQUE Return true if specified index is DESCENDING Return tag number if expression is index Return T if tag name/number exists in table Return number of indexes open for table Return the number of tags for specified table Reset index order saved with SAVEORD Save current indexes to array Return the number of open index files Return order number of index Return total indexes open in all work areas Back to Top Input Change value of LASTKEY() Keyboard enter to buffer Name of the key pressed Input dialog for WHATKEY Wait for specific key press Duplicate inkey function without inkey() A dialogue get box Trap keys with inkey() Back to Top Libraries Return T is named library is loaded Load FOXTOOLS Release FOXTOOLS library Back to Top Math Return sum of all numeric data in an array Factorial calculation Return a char string percentage expression Back to Top Measures Convert acres to hectares Convert acres to square miles Convert acres to square feet Convert cubic cm to cubic inches Convert centimeters to inches Convert Centigrade to Fahrenheit Convert liquid cubic feet to gallons Convert cubic inches to cubic cm Convert cubic meters to gallons Convert Fahrenheit to Centigrade Convert feet to meters Convert gallons to cubic feet Convert gallons to cubic meters Convert gallons to liters Convert hectares to acres Convert inches to centimeters Convert kilograms to pounds Convert kilometers to miles Convert knots to miles per hour Convert kilometer per liter into mpg Convert kilograms per sq cm to psi Convert pounds to kilograms Convert liters to gallons Convert meters to feet Convert miles to kilometers Convert mpg to kilometers per liter Convert miles per hour to knots Convert psi to kilograms per sq cm Convert sq feet to acres Convert sq miles to acres Convert sq meters to sq feet Back to Top Memo Fields Return T if named memo file exists in PT_SYS Create a blank memo "file" in PT_SYS Delete specified memo "file" from PT_SYS Edit a specified memo "file" in PT_SYS Pick list for memo "files" stored in PT_SYS Read any file into PT_SYS memo "file" Write PT_SYS memo "file" to DOS file Display read-only version of memo field Back to Top Memvars Initialize memvars with same names as dbf fields Release all PUB vars created by INIT_VAR Replace fields from memvars created by INIT_VAR Back to Top Menus Bar number from prompt Menu exists Popup exists Pad number from prompt Pick list from an array A dialog menu with up to 5 choices Like dialog menu, but uses check boxes A dialogue box to terminate and edit Plain vanilla horizontal bounce bar menu Multi-column pick list A no/yes dialog box A vertical menu popup Generic popup menu Run menu loaded from OPTIONS table Popup menu loaded from OPTIONS table Plain vanilla version of vertical bar menu Yes/No dialog menu Back to Top Nesting Check if program is in the program stack Return number of entries in program stack Back to Top Network File opened exclusively Return T if file open on a LAN is successful Return T if lock is successful Back to Top Print Convert CHR(xx) to ASCII character Return a zero instead of a divide overflow Set up custom print specifications Control print page and screen breaks Set up for print to disk Escape key control while printing Set variables for specified print mode Initializes printer Return control and output to the screen Set up FoxPro for printing Select printer defaults Check if printer is on-line and ready Reset print job to the top of the current page Reset the printer, return output to the screen Set printer values Determine the destination of a print run Back to Top Print Drivers Return T if printer driver exists in PT_SYS Initialize public print driver array Delete specified print driver from PT_SYS Edit current PT_SYS printer driver Present menu of printer drivers available Rename a print driver Set active print driver from PT_SYS Save current print driver from PT_SYS Control all print driver development Back to Top Programming Count lines of code in file Back to Top Screen Strip color from memvar stores to DOS file Back to Top Search Dynamic seek with screen refresh Return T if chars in <C1> contained in <C2> Template for incremental browse Return blank-out color for incremental browse Return T if any char in C1 is contained in C2 Trim trailing zeros from soundex string Dynamic search with Soundex when necessary Dynamic seek filtered with a zip code Back to Top Security Create standard check digit Break SYS(2007) checksum Simple encryption routine Check for proper check digit Check dbf file for system date >=file date Check system date for specified days Check if system time is within parameters Change password of current system user Translate string to coded format Delete a crypto key from PDL system table Generate a crypto key from user's code Encode a character string using a crypto key Decode a character string using a crypto key Return crypto key from the PDL system table Save crypto key to the PDL system table Lock data table by changing header Unlock a data table locked with changed header Decode a string coded by CODE function Encrypt a string -- data cannot be decoded Return T if crypto key is stored in PT_SYS Log on user to SYS_USE table Enter event to SYS_USE table Log out user to SYS_USE table Check user access level Display password box and get entry Check passwords Add, edit, or delete passwords Back to Top Sound Play the songs from the Xbase hit parade Sound a tone Back to Top Statistics Calculate maximum numeric value in an array Return median for numeric column of array Return mean for numeric column of array Return minimum for numeric column of array Return mode for numeric column of array Return standard deviation of array column Return variance for a numeric array column Return mean of a numeric field Return median of a numeric field Return mode of a numeric field Generate a random number in boundaries Return standard deviation of numeric field Return statistical variance of numeric field Back to Top Strings Break string to work tokens Capitalize first letter of name properly Return location of character from right end Return char for logical expression Extracts specific line from character string Return # of wrapped lines in character string Converts integer to English character string Return English char string with $ from number Standard name capitalization Replace "a" with "b" in a string Convert 'YyNnTtFf' to logical value Return word count for text string Convert anything to a character string Back to Top Telephone State from a zip code Back to Top Text Style Universal printer function Set printer to 10 char per inch Set printer to 12 char per inch Set printer to 6 char per inch Set printer to 8 char per inch Set printer to BOLD Set printer to BOLD + UNDERLINE Set printer to COMPRESSED Set printer to DRAFT Set printer to EXPANDED Set printer to ITALICS Set printer to ITALICS + UNDERLINE Set printer to LETTER QUALITY Set printer to SUBSCRIPT Set printer to SUPERSCRIPT Set printer to UNDERLINE Back to Top Time YSECONDS to Date/Time; Seconds since 0/01/80 Convert military time to civilian time Return T if char string is valid time string Convert any time to military time Return numeric time string from 'HH:MM:SS' Return number of seconds between times Add seconds to time string Convert time string to decimal hours Convert time string to seconds since midnight Back to Top Windows Pick List -- maximum five choices A data table pick list Release WORKING window Explode window to specifications Implode window to specifications Clear defined windows matching skeleton dBASE IV compatibility function Create a defined window list as an array Display working window Back to Top ZIP Codes Return city name from master zip table Return formatted CITY STATE ZIPCODE Return city name from special zip table Return designated city name for zip code Return T if 2 char string is Canadian province Return T if 2 character string is a state Return state name from ZIP data table Return 2 char state name from ZIP data table Check if zip code is in master zip table Allow for multiple names with single zip code Back to Top Return to Main Power Developer's Library Page Mac Rubel's Power Developer's Library ... $149 Contact HALLoGRAM || Product Lists || Tech Support Programmer's Resources || Search HALLoGRAM Shopping Cart || Site Map || Request More Specific Information

©Copyright 1998 HALLoGRAM Publishing, Aurora CO. All Rights Reserved.