This repository has been archived by the owner on Jan 31, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
readmeeng.txt
183 lines (131 loc) · 7.84 KB
/
readmeeng.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
====================================================================
File readmeeng.txt
rFunc UDF Library for InterBase.
Description.
Copyright 1998-2001 Polaris Software
http://polesoft.da.ru
mailto: rFunc@mail.ru
Version 2.0.1.2
====================================================================
Maximize window and turn mode your program to Word wrap for best
viewing this document.
CONTENTS
1. The brief description
2. Compilation
3. Installing the library
4. Distribution
5. List of files
6. Gratitude
----------------------------------------------
1. The Brief Description
------------------------
The rFunc functions library (further - library) is intended for the extension of possibilities a DBMS InterBase. Includes in itself more 90 string, numerical, bit functions, operation with dates, BLOBàìè, users etc. functions.
Also library contains parser (calculator of expressions), which allows to execute numerical expressions given as string, with transmission of parameters. It is possible to calculate and trigonometrical functions.
List of functions:
> Numeric: Abs Ceil Floor MaxNum MinNum Power Round SoftRound Z IIf DIf DZero Div Mod InitRandom GetRandom
> Parser: CalcExpr ExprIsValid
> String: Chr Ord StrReplace StrStuff LTrim RTrim StrLen StrPos StrRepeat SubStr Trim CIf StrCount WordCount WordNum RLower RUpper PadLeft PadRight RLatin RTranslit
> Date&Time: DateToStr DayPerMonth Dow EncodeDate EncodeDateTime ExtractDate Day Month Year Hour Minute Second WeekDay YearDay Quarter FirstDayMonth LastDayMonth IsLeapYear DaysBetween DtIf IncDate
> BLOB: B_Line B_Line_Count B_Max_Segment B_Number_Segments B_Put_Segment B_SubStr B_Total_Length
> Bit: BitAnd BitNot BitOr BitXor GetBit SetBit
> Users: Add_User Modify_User Delete_User (only for IB 5.x and later)
> Other: MsgBox (only Windows)
The returned strings in string functions have maximum length of 255 characters. For return of long strings use functions with the prefix Long (length up to 16K).
Full the description of functions is reduced in a directory doc.
The library is written on C ++, is delivered with the completely open source code (directory source). It allows to compile it on any platform supported Interbase.
In a directory sql the set of scripts for creating, droping and testing of functions in your database is delivered. Scripts for deleting and the testings are not divided for different versions IB. Errors of their execution are accepted.
Supported platforms:
for Windows: IB Borland 4.2, 5.x, 6.0, Firebird 0.9,
for Linux: IB Borland 5.x, 6.0, Firebird 0.9.
Remark: Further in the text IB6 will mean IB Borland 6.0 or Firebird 0.9.
2. Compilation
--------------
For convenience of compilation the make-files with names makefileN.win and makefileN.linux (N - version IB) for Windows and Linux accordingly are included in archive.
For Windows:
1. Install one of compilers Borland C++.
2. Extract files from archive with the library in any folder.
3. Open the source folder.
4. Edit make-file makefileN.win: path of IB (IBASE parameter), Ñ++ (BCDIR parameter), Windows system dir (SYSDIR parameter).
5. Run following command
<BC++ folder>\bin\make -f makefileN.win all
The compilation was tested with Free Borland C++ Compiler 5.5 on Windows 2000 Pro SP1.
For Linux:
1. Extract files from archive with the library by mc program or commands
gzip -d rfunc.tar.gz
tar xvf rfunc.tar
2. Open the source directory.
3. Edit make-file makefileN.linux: path by IB (IBASE parameter).
4. Run following command
make -f makefileN.linux rfunc
The compilation was tested on RH 6.2 kernel 2.2.14, Mandrake 8.0 kernel 2.4.4.
For FreeBSD:
The compilation by the developers was not tested, but, by recalls, special problems does not cause.
3. Installing the library
-------------------------
With the distribution kit the compilated rFunc library only for IB6 is delivered. For other versions IB it is necessary independently ñêîìïèëèðîâàòü it or, by becoming the registered user, to receive it from us.
For Windows:
1. The RFUNC.DLL file is necessary for copying in a folder
variant 1: <IB path>\Bin (for IB6 - <IB path>\UDF), where <IB path> is path to a folder, in which Interbase is installed (is recommended).
variant 2: Windows\System (for Windows 9x) or WinNT\System32 (Windows NT, 2k).
2. only for IB 5.x: copy ib_util.dll file from <IB path>\Lib to <IB path>\Bin.
If on one computer some versions of servers Interbase are installed, it is necessary to use the rFunc library, appropriate to the installed client IB (GDS32.DLL).
It is recommended before start of the Interbase server to substitute GDS32.DLL on appropriate to the version of the server.
For Linux:
IB 5.x
variant 1: Copy the rfunc file into directory /usr/lib.
variant 2: Copy the rfunc file into any directory, for example, /home/rFunc. Create the reference on the library by "ln -s /home/rFunc/rfunc /usr/lib/rfunc" command. User should have the right to creation of the references in a directory /usr/lib.
IB6
Copy the rfunc file into directory <IB directory>\UDF.
4. Distribution
---------------
All problems connected to use and distribution of the library, are regulated GNU Lesser General Public License.
The text of the license is in the license.txt file.
The library is a FREEWARE product and the technical support by us is not guaranteed.
There is a possibility UNESSENTIAL paid (10 $) registration. It for those who wants to receive technical support, to have the right to prime reviewing of your problems and inclusion in the library of required functions.
5. List of files
----------------
Folder/Files Description
------------------------------------------------------------
bin/ compiled library
rfunc.dll for IB6 (Windows)
rfunc for IB6 (Linux)
doc/ description
*.html functions description page (from our website)
*eng.html functions description page (from our english website)
*.gif, polesoft.css images and style sheet for html
rfunc.txt functions description (win1251)
rfunceng.txt functions description (english)
rfunc.linux functions description (koi8)
source/ sources
makefile*.* make-files for compilation for various versions IB and for Windows and Linux
rblob.* functions of operation with BLOB
rcalc.* parser
rdatetime.* functions of operation with dates
rfunc.h header-file for rfunc
rfunc*.rc resource file with VersionInfo for various versions IB (only for Windows)
rmath.* math functions
rmisc.* other functions
rsecurity.* functions of operation with the users
rstring.* string functions
win1251.h arrays of characters for functions rUpper, rLower, rLatin, rTranslit
sql/ scripts
rdrop.sql deleting of functions from the database
rfunc*.sql creating of functions in the database for various versions IB
rtest.sql testing of functions
changes.txt changes history (win1251)
changeseng.txt changes history (english)
changes.linux changes history (koi8)
license.txt license (english)
readme.txt description (win1251)
readmeeng.txt description (english)
readme.linux description (koi8)
6. Gratitude
------------
Khazatsky Alexander,
Software developer
Storm International CS B.V.
----------------------------------------------
24.07.2001
Best regards,
Polaris Software, Russia, Krasnodar
Thank for interest to our products.