User-Defined functions (UDFs)

My Photo
Name:
Location: Montréal, Québec, Canada

My height is 181 centimeters, my weight is 76 kilograms. I am an author of User-defined string functions. Each day my functions are downloaded on average by 30 people from around the world, but mostly from North and Latin America, and Europe. More than 30 000 people have already downloaded my functions. Please try a Google Search for keywords such as "Transact-SQL PROPER" or "Transact-SQL GETWORDCOUNT". My functions include versions for MS SQL Server (7.0, 2000, and 2005), MS SQL Server 2005 CLR .Net, Sybase ASA, DB2 and Oracle. I would like to bring to your attention that I found errors in the MS SQL Server, Sybase and DB2, which attests to the quality of my work.

Saturday, August 19, 2006

Help in translation

Hello all,

1)
I need English native speakers’ help to correct the English text of my description of User-defined functions LCK Visual FoxPro and the several comments in the C++ and VFP source code. They will be disseminated as a free of charge download.The description of each function is similar to the description of functions in the help VFP. The shortest description consists of several lines, the longest is similar to a description of a ASCAN() function. In total the library has about 20 functions, but the descriptions of some of them are practically identical, as is the case, for example, for search functions of minimum / maximum values among elements of an array column. Therefore, a help of about 10 -15 people is needed, each one doing only a fraction of the total required work.
If you would like to help me, please send an email to udfunctions(a)gmail.com (Subject: Help in translation). I will send you a function description or a line of the comment in source code, together with the library and an example of usage.The names of people who will assist in correcting the text will be published on my page or in the CHM description files, unless requested otherwise.Thank you very much for offering your help.
2)
Five people have responded to my request to help with the correction of the English text.Although half of all the work has been already done, I still need 5-7 voluntaires to help to complete the work.I am very grateful to those who have responded.Yet, I am once again humbly repeating my request for help.If you can spend a maximum of 40 minutes of time in order to correct a broken English text of the type:
[The sample of the text]
If the remainder from the quantity of passed parameters divided into three is one, penultimate, and accordingly,if the mentioned remainder is two, the last parameter cOtherwiseExecutedExpressions is considered as a string of the executed commands separated by the “;” character, in case of if all logical conditions are false.If the remainder from the quantity of passed parameters divided into three is two, the last parameter is considered as returned result cOtherwiseResult, in case of if all logical conditions are false.
[End the sample of the text]

Here is the list of functions from the library.
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() - Returns one of two values and executes one of two string of the commands depending on the value of a logical expression.
EXECUTE() - Execute the commands from a string, unlike a macro substitution can execute the several commands from one string and returns the result.
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 resultWorking 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.

I am planning to produce a complete description of my functions in French, German, Spanish and Romanian.If you are proficient in one of those languages, please write to me at udfunctions(a)gmail.com (Subject: Help in French translation or Help in Spanish translation etc)

I am also planning to translate the list of functions into other European languages,as well as into Arabic, Hebrew, Chinese, Japanese and Korean. A help of one or two people would be very appreciated in that regard.
One people have responded to my request to help with the correction of the Portuguese text.
Each assistant will be very valuable.


View My Stats