Developpez.com

Plus de 14 000 cours et tutoriels en informatique professionnelle à consulter, à télécharger ou à visionner en vidéo.

Developpez.com - SGBD & SQL
X

Choisissez d'abord la catégorieensuite la rubrique :


Espace Web FoxPro italien d'Igor Nikiforov

Date de publication : 01/09/2006

Par Igor2004 (nikiforov.developpez.com/foxpro/italien)
 

User-defined functions FoxPro.

               Version PDF   Version hors-ligne


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
For more information about ST_DENIS library for FoxPro please visit the
English
German
French
Spanish

User-defined string functions Transact-SQL, PL/SQL
English
German
French
Spanish


The team of Visual Extend sends a big Thank You for the allowance
to integrate the very nice functions into the new version 9.5 of the Framework VFX.



               Version PDF   Version hors-ligne

Valid XHTML 1.1!Valid CSS!

Contacter le responsable de la rubrique SGBD & SQL