ID: 31960 Created on: February 1, 2007 23:00 Updated on: December 28, 2009 17:35

<B>St_Denis library of User-defined functions LCK VFP</B> Download #31960

St_Denis library of User-defined functions LCK VFP
URL:	st_denis.zip
Downloads:	2713
Summary:	The ST_DENIS library is available for all versions Visual FoxPro through 9.0, FoxPro 2.6 for DOS and FoxPro 2.6 for Windows. In total the library has about 25 functions. In my humble opinion, it will be convenient to apply such functions for developing applications. Here is the list of functions from the library. STRTRANEX() - A function with enhanced search-and-replace capabilities as compared to the built-in function STRTRAN(). etc .. Working with arrays ARRAYSUM() - Returns the sum of all or a specified range of numeric (and/or currency) elements in the selected column of an array. ARRAYAVG() - Computes the arithmetic average of all or a specified range of numeric (and/or currency) elements in the selected column of an array. etc Plus, there are CHM files in English, German and French.
Rating:	Rate this entry
Created by:	Igor Nikiforov Belron Canada inc. Montréal, Quebec

Ladies and Gentlemen,

I am pleased to offer, free of charge, the following UDFs FoxPro:

Working with words
GETALLWORDS() - Inserts the words from a string into a global dimensioned array.
WORDTRAN() - Searches a character string for occurrences of a first word, and then replaces each occurrence with a second word.
GETNUMWORD() - Returns the index position of a word in a string.
GETOCCURSWORD() - Returns the number of times a word occurs within the character string.
GETATWORD() - Returns the beginning numeric position of the nth occurrence of a word within the character string, counting from the leftmost character.
GETRATWORD() - Returns the numeric position of the last (rightmost) occurrence of a word within the character string.
STRTRANEX() - A function with enhanced search-and-replace capabilities as compared to the built-in function STRTRAN().
WORDTRANEX() - A function with enhanced search-and-replace capabilities as compared to the function WORDTRAN().

Working with arrays
ARRAYSUM() - Returns the sum of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ARRAYAVG() - Computes the arithmetic average of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ARRAYMIN() - Evaluates all or a specified range of elements in the selected column of an array and returns the element and optional number of row with the minimum value.
ARRAYMAX() - Evaluates all or a specified range of elements in the selected column of an array and returns the element and optional number of row with the maximum value.
ARRAYCNT() - Counts the number of all or a specified range of numeric (and/or currency) elements in the selected column of an array.
ASCANQUICK() - Unlike the built-in function ASCAN(), performs a binary search in the selected column of a sorted array for an element containing the same data and data type as an expression.
VITESCAN() - Performs a binary search in the selected column of a sorted array for an element containing the same data and data type as an expression. This function is more simple than ASCANQUICK().

Other functions
FIELDNUM() - Returns the field number, referenced by name of a field, in a table.
DANSLISTE() - Determines whether a numeric expression is contained in the list of values of type «1,5,13-18»
INCREMENT() - Increments or decrements the value of a variable passed by reference by one and returns the result
STRFILTER() - Removes all characters from a string except those specified.
REVERSE() - Returns the reverse of a character expression.
IFOR() - Immediate FOR cycle.
IWHILE() - Immediate WHILE cycle.
ICASE() - Evaluates the results from a list of conditions.
IEXECCASE() - Evaluates the results and executes the commands from a list of conditions.
IEXECIF() - Executes one of two string expressions, depending on the value of a logical expression, and returns the result.
EXECUTE() - Execute commands from a string and returns the result. Unlike a macro substitution, can execute several commands from one string.

Converting to/from Roman numerals
ARABTOROMAN() - Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999).
ROMANTOARAB() - Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX).

More than 30 000 people have already downloaded my User-Defined functions. I hope you will find them useful as well.

The ST_DENIS library is available for all versions Visual FoxPro through 9.0, FoxPro 2.6 for DOS and FoxPro 2.6 for Windows.
The VFP library is ST_DENIS.FLL and the FoxPro for DOS library is ST_DENIS.PLB.
To register the library in your programs, use one of the SET LIBRARY commands:
SET LIBRARY TO ST_DENIS.FLL ADDITIVE && for VFP
or
SET LIBRARY TO ST_DENIS.PLB ADDITIVE && for FoxPro for DOS
It is best to place the library file in your search path (SET PATH command).
If it is not in your search path, you will need to specify the path to the library file in the SET LIBRARY command:
SET LIBRARY TO ST_DENIS.FLL ADDITIVE
To remove the library from memory, use:
RELEASE LIBRAY ST_DENIS
or, if the library is not in the search path,
RELEASE LIBRARY ST_DENIS

Here is the list of files from the archive.
01) St_Denis.fll library for VFP 9.0
02) St_Denis.fll library for VFP 8.0 and below
03) St_Denis.fll library for FoxPro 2.6 for Windows
04) St_Denis.plb library for FoxPro 2.6 for DOS
05) St_Denis.c source code
06) St_Denis.prg Implementation of some functions of library on FoxPro.
07) test_perf.prg test of performance.
08) mkeywords.prg makes table of keywords from memo field.
09) a form examstrtranex.scx, the form demonstrates the STRTRANEX() and WORDTRANEX() functions.
10) St_Denis_English.chm English documentation
11) St_Denis_French.chm French documentation
12) St_Denis_German.chm German documentation

Comments
	No	Created by	Created on	Comment
	1.	Zhu Yuguang	03/09/2007 19:15	No FoxPro for Windows Ver.2.5/2.6
	2.	Igor Nikiforov	01/08/2009 13:51	The ST_DENIS library is available for all versions Visual FoxPro through 9.0, FoxPro 2.6 for DOS and FoxPro 2.6 for Windows.
Add a comment

More entries from this member

1. AGETFILESUMMARY is the same thing as AGETFILEVERSION but for Summary resources. November 14, 2008
   AGETFILESUMMARY is the same thing as AGETFILEVERSION but for Summary resources. the code from http://support.microsoft.com/kb/186898/en-us has been adapted for VFP fll library by Igor Nikiforov 2008-11-12 Creates an array containing information about files with summary resources or about Compound Document Properties

2. St_Denis library of User-defined string functions Visual Studio.Net November 20, 2009
   The St_Denis library is available for VB.Net, C#.Net and C++.Net . In total the library has about 30 functions. In my humble opinion, it will be convenient to apply such functions for developing applications.

3. UDFs T-SQL CLR (VB. Net, C#.Net, C++. Net) September 4, 2009
   User-Defined string functions Transact-SQL MS SQL Server 2005, 2008 Common Language Runtime CLR (VB. Net, C#.Net, C++. Net) with source code. AT RAT OCCURS PADC PADR PADL CHRTRAN STRFILTER STRTRAN WORDTRAN GETWORDCOUNT GETWORDNUM GETNUMWORD GETALLWORDS GETOCCURSWORD GETATWORD GETRATWORD PROPER RCHARINDEX ARABTOROMAN ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL. AT, PADL, PADR,...

4. User-Defined string functions Oracle PL/SQL May 15, 2008
   User-Defined string functions Oracle PL/SQL GETALLWORDS, GETWORDCOUNT, GETWORDNUM, OCCURS, PADC, STRTRAN, STRFILTER, ATC, RAT, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Oracle Procedural Language SQL. Plus, there are CHM files in English, French, Spanish, German and Russian.

5. User-Defined string functions SQL PL DB2 May 15, 2008
   User-Defined string functions SQL Procedural Language DB2 AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRTRAN, STRFILTER, GETWORDCOUNT, GETWORDNUM, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on SQL Procedural Language DB2. Plus, there are CHM files in English, French, Spanish, German and Russian.

6. User-Defined string functions Transact-SQL May 15, 2008
   User-Defined string functions Transact-SQL AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRFILTER, STRTRAN, WORDTRAN, GETWORDCOUNT, GETWORDNUM, GETNUMWORD, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL. AT, PADL, PADR, CHRTRAN, PROPER similar to the Oracle functions INSTR, LPAD, RPAD, TRANSLATE, INITCAP. Plus, there are CHM files in E...

7. User-Defined string functions Transact-SQL Sybase May 15, 2008
   User-Defined string functions Transact-SQL Sybase ASA AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRTRAN, STRFILTER, GETWORDCOUNT, GETWORDNUM, GETALLWORDS, PROPER, RCHARINDEX, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL Sybase ASA. Plus, there are CHM files in English, French, Spanish, German and Russian.

8. User-Defined string functions Visual Basic July 29, 2009
   User-Defined string functions Visual Basic STRTRANEX, WORDTRANEX, AT, RAT, OCCURS, PADC, PADR, PADL, CHRTRAN, STRFILTER, STRTRAN, WORDTRAN, GETWORDCOUNT, GETWORDNUM, GETNUMWORD, GETALLWORDS, ARABTOROMAN, ROMANTOARAB etc. In my humble opinion, it will be convenient to apply such functions for writing of programmes and procedures on Visual Basic. Plus, there are CHM files in English, French, Spanish, German and Russian.