Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

St_Denis library of User-defined functions LCK VFP
Igor Nikiforov, Belron Canada inc.
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.
Created on
17 years ago
Downloads
3826
File type
Freeware
General information
URL:
st_denis.zip
Rating:
Rate this item
Description
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
Created by
Igor Nikiforov, Belron Canada inc.

Comments
No FoxPro for Windows Ver.2.5/2.6 Zhu Yuguang, September 3, 2007

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. Igor Nikiforov, August 1, 2009

I used Foxpro Dos version of your library, thank you. Seem you used non-english letters for .PRG version. It works but I hesitate to use .PRG edition because of these letters... Metin Emre, October 14, 2014

More downloads created from this member
St_Denis library of User-defined string functions Visual Studio.Net
Igor Nikiforov, Belron Canada inc.
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.
Created on
14 years ago
Downloads
1127
File type
Freeware
AGETFILESUMMARY is the same thing as AGETFILEVERSION but for Summary resources.
Igor Nikiforov, Belron Canada inc.
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 Compo...
Created on
15 years ago
Downloads
913
File type
Freeware
User-Defined string functions Visual Basic
Igor Nikiforov, Belron Canada inc.
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 writin...
Created on
16 years ago
Downloads
1602
File type
Freeware
UDFs T-SQL CLR (VB. Net, C#.Net, C++. Net)
Igor Nikiforov, Belron Canada inc.
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 RC...
Created on
18 years ago
Downloads
6475
File type
Freeware
User-Defined string functions Oracle PL/SQL
Igor Nikiforov, Belron Canada inc.
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 Lang...
Created on
18 years ago
Downloads
3436
File type
Freeware
User-Defined string functions SQL PL DB2
Igor Nikiforov, Belron Canada inc.
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 st...
Created on
18 years ago
Downloads
2556
File type
Freeware
User-Defined string functions Transact-SQL Sybase
Igor Nikiforov, Belron Canada inc.
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 p...
Created on
18 years ago
Downloads
2798
File type
Freeware
User-Defined string functions Transact-SQL
Igor Nikiforov, Belron Canada inc.
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 ...
Created on
19 years ago
Downloads
17535
File type
Freeware
Rating
5.00/5.00