Date de publication : 01/09/2006
Par
Igor2004 (nikiforov.developpez.com/foxpro/italien)
Ladies and Gentlemen, I am pleased to offer, free of charge, the following UDFs FoxPro: 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. 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 Working with arrays ARRAYSUM() - Totals all or specified numeric elements in the selected column of an array. ARRAYAVG() - Computes the arithmetic average of all or specified numeric elements in the selected column of an array. ARRAYMIN() - Evaluates all or specified 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 specified elements in the selected column of an array and returns the element and optional number of row with the maximum value. ARRAYCNT() - Counts all or specified numeric elements in the selected column of the 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(). GETALLWORDS() - Inserts the words from a string or memo field into the global array. 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 11 000 people have already downloaded my functions for MS SQL Server. I hope you will find them useful as well. The ST_DENIS library is available for all versions Visual FoxPro through 9.0 and for FoxPro 2.6 for DOS. 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 <PATH TO LIBRARY> 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 <PATH TO LIBRARY> ST_DENIS |