Nützliche Tips (Ergänzungen zum Handbuch von Heinz Richartz) - Seite 20

leecher · 13.10.2012, 15:47

E r g e b n i s / R e s u l t

Returns the character for the given ASCII code.

B e s c h r e i b u n g / D e s c r i p t i o n
This function returns the character that belongs to the ASCII code given.

S y n t a x

Code:

c = call ('CHR' , code)

P a r a m e t e r
code - The ASCII code of the character to return

R e t u r n s
Returns the character matching the ASCII code given.

B e i s p i e l / E x a m p l e

Code:

attach 'tools'
put ' 65> ' , call ('chr' , 65) , do newline
detach 'tools'

leecher · 13.10.2012, 15:52

E r g e b n i s / R e s u l t
Returns the length of a given string.

B e s c h r e i b u n g / D e s c r i p t i o n
This function returns the length of the string supplied.

S y n t a x

Code:

c = call ('LENGTH' , str)

P a r a m e t e r
str -The string whose length to return.

R e t u r n s
The length of the string str.

B e i s p i e l / E x a m p l e

Code:

attach 'tools'
put call ('length' , 'BLABLA')  ! return 6
detach 'tools'

leecher · 13.10.2012, 15:55

E r g e b n i s / R e s u l t
Return the smallest of two values passed to it

B e s c h r e i b u n g / D e s c r i p t i o n

MINOF2 calculates the smallest of two values passed to it and returns
the smaller.
Integers, decimals and dates may be passed to the routine.

S y n t a x

Code:

larger = call('MINOF2' , value1 , value2)

P a r a m e t e r

value1
value2 - may be integer, decimal or date values. If dates are involved,
then both values must be dates.

R e t u r n s
The smaller of the two values passed to the function.
If dates are passed to the function, then a date is returned.
If two integers are used, then an integer is returned.
If either of the two values is a decimal, then a decimal is returned.

B e i s p i e l / E x a m p l e

Code:

 
attach 'TOOLS' 
put call('MINOF2' , sysdate , sysdate - 1) ! prints yesterday's date 
detach 'TOOLS'

Q u e r v e r w e i s / R e f e r e n c e
MAXOF2

leecher · 13.10.2012, 16:06

The DESKTOP-function from WINDOWS.OAC same as the DESK_UP function in DESK.OAC

leecher · 13.10.2012, 16:09

E r g e b n i s / R e s u l t
Shows the ASCII tabe window.

B e s c h r e i b u n g / D e s c r i p t i o n
This function shows a window with the ASCII table and returns the character the user has selected.

S y n t a x

Code:

str = call ('ASCII')

P a r a m e t e r

R e t u r n s
A string with the value the user has selected or an empty string, if the user aborted.

B e i s p i e l / E x a m p l e

Code:

attach 'windows'
put call ('ASCII') ! prints the value selected
detach 'windows'

leecher · 13.10.2012, 17:20

E r g e b n i s / R e s u l t

Shows the Alias-Table and returns the alias the user selected

B e s c h r e i b u n g / D e s c r i p t i o n

This function reads the alias-Table from config.oa3 and show the user the list of aliases defined there. The user can select an alias or abort the operation. The function returns the alias selected.
This function is for OpenAccess III, for OpenAcces IV, use GETAL4.

S y n t a x

Code:

ok = call("GETALIAS")

P a r a m e t e r

R e t u r n s

A string with the alias the user selected or an empty string if no lias was selected.

B e i s p i e l / E x a m p l e

Code:

attach "alias.oac"
put call("GETALIAS")
detach "alias.oac"

leecher · 13.10.2012, 17:21

Same as GETALIAS

leecher · 13.10.2012, 17:21

Same as GETALIAS, but for Openaccess 4.

leecher · 13.10.2012, 17:38

E r g e b n i s / R e s u l t

Repairs the selected database.

B e s c h r e i b u n g / D e s c r i p t i o n

Repairs the index file of the database given.
This OAC gets also used by OpenAccess and is linked in the menu (Repair table)

S y n t a x

Code:

ok = call("FIX", database)

P a r a m e t e r
database - The name of the database to fix

R e t u r n s
A boolean value.

B e i s p i e l / E x a m p l e

Code:

attach "FFILE"
put call("FIX", "CITY")
detach "FFILE"

leecher · 13.10.2012, 17:41

E r g e b n i s / R e s u l t

Verifies the integrity of the selected database.

B e s c h r e i b u n g / D e s c r i p t i o n

Verifies the integrity of the selected database.
This OAC gets also used by OpenAccess and is linked in the menu (Repair table)

S y n t a x

Code:

ok = call("VERIFY", database)

P a r a m e t e r
database - The name of the database to check

R e t u r n s
A boolean value.

B e i s p i e l / E x a m p l e

Code:

attach "FFILE"
put call("CHECK", "CITY")
detach "FFILE"

13.10.2012, 15:47	#191
leecher Moderator	CHR E r g e b n i s / R e s u l t Returns the character for the given ASCII code. B e s c h r e i b u n g / D e s c r i p t i o n This function returns the character that belongs to the ASCII code given. S y n t a x Code: c = call ('CHR' , code) P a r a m e t e r code - The ASCII code of the character to return R e t u r n s Returns the character matching the ASCII code given. B e i s p i e l / E x a m p l e Code: attach 'tools' put ' 65> ' , call ('chr' , 65) , do newline detach 'tools'

13.10.2012, 15:52	#192
leecher Moderator	LENGTH E r g e b n i s / R e s u l t Returns the length of a given string. B e s c h r e i b u n g / D e s c r i p t i o n This function returns the length of the string supplied. S y n t a x Code: c = call ('LENGTH' , str) P a r a m e t e r str -The string whose length to return. R e t u r n s The length of the string str. B e i s p i e l / E x a m p l e Code: attach 'tools' put call ('length' , 'BLABLA') ! return 6 detach 'tools'

13.10.2012, 15:55	#193
leecher Moderator	MINOF2 E r g e b n i s / R e s u l t Return the smallest of two values passed to it B e s c h r e i b u n g / D e s c r i p t i o n MINOF2 calculates the smallest of two values passed to it and returns the smaller. Integers, decimals and dates may be passed to the routine. S y n t a x Code: larger = call('MINOF2' , value1 , value2) P a r a m e t e r value1 value2 - may be integer, decimal or date values. If dates are involved, then both values must be dates. R e t u r n s The smaller of the two values passed to the function. If dates are passed to the function, then a date is returned. If two integers are used, then an integer is returned. If either of the two values is a decimal, then a decimal is returned. B e i s p i e l / E x a m p l e Code: attach 'TOOLS' put call('MINOF2' , sysdate , sysdate - 1) ! prints yesterday's date detach 'TOOLS' Q u e r v e r w e i s / R e f e r e n c e MAXOF2

13.10.2012, 16:09	#195
leecher Moderator	ASCII E r g e b n i s / R e s u l t Shows the ASCII tabe window. B e s c h r e i b u n g / D e s c r i p t i o n This function shows a window with the ASCII table and returns the character the user has selected. S y n t a x Code: str = call ('ASCII') P a r a m e t e r R e t u r n s A string with the value the user has selected or an empty string, if the user aborted. B e i s p i e l / E x a m p l e Code: attach 'windows' put call ('ASCII') ! prints the value selected detach 'windows'

13.10.2012, 17:21	#197
leecher Moderator	GETAL3 Same as GETALIAS

13.10.2012, 17:21	#198
leecher Moderator	GETAL4 Same as GETALIAS, but for Openaccess 4.

13.10.2012, 17:41	#200
leecher Moderator	VERIFY E r g e b n i s / R e s u l t Verifies the integrity of the selected database. B e s c h r e i b u n g / D e s c r i p t i o n Verifies the integrity of the selected database. This OAC gets also used by OpenAccess and is linked in the menu (Repair table) S y n t a x Code: ok = call("VERIFY", database) P a r a m e t e r database - The name of the database to check R e t u r n s A boolean value. B e i s p i e l / E x a m p l e Code: attach "FFILE" put call("CHECK", "CITY") detach "FFILE"

Themen-Optionen	Thema durchsuchen
Druckbare Version zeigen Jemanden per E-Mail auf dieses Thema hinweisen	Thema durchsuchen: Erweiterte Suche