[RKabis]

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

Pfeiltasten bekommen eine Linien-Funktion

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

Bei einer freien Funktionstaste (z.B. F5) \Cdrawd\! eintragen
Schirmmaske öffnen
Mit UMSCH+F5 Funktion aufrufen
Wenn jetzt die Pfeiltalsten bewegt werden gibt es automatisch Linien.

Wird ein Quadrat oder Rechteck gefahren enstehen ebenfalls automatisch die Ecken bzw. bei durchkreuzen der Linien die "Kreuze".

R e t u r n s

doppelte Linien

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

DRAWS

[RKabis]

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

Pfeiltasten bekommen eine Linien-Funktion

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

Bei einer freien Funktionstaste (z.B. F5) \Cdraws\! eintragen
Schirmmaske öffnen
Mit UMSCH+F5 Funktion aufrufen
Wenn jetzt die Pfeiltalsten bewegt werden gibt es automatisch Linien.

Wird ein Quadrat oder Rechteck gefahren enstehen ebenfalls automatisch die Ecken bzw. bei durchkreuzen der Linien die "Kreuze".

R e t u r n s

einfache Linien

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

DRAWD

[RKabis]

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

Wandelt einen String in Kleinbuchstaben um.
Converts a string to lowercase letters

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 a string where all uppercase letters have been
converted to lowercase.
This function compliments the Open Access UCASE Programmer function.

S y n t a x

answer = call ('LCASE' , string)

P a r a m e t e r

string - is any string or constant

R e t u r n s

Returns a string variable of the same length as the string passed to i

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

attach 'STRING'
put call ('LCASE' , 'Test String') ! prints test string
a = 'AA Aerospace'
b = call ('LCASE' , a) ! b contains 'aa aerospace'
detach 'STRING'

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

UCASE
PROPER

[RKabis]

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

Liefert die meist ausgelassenen n Charakter aus einem String
Returns the left-most n characters of a 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 a string composed of the left-most characters of
a string passed to it. The user tells the function how many characters
to return.

S y n t a x

answer = call ('LEFT' , string , value)

P a r a m e t e r

string - is any string or constant
value - is an integer, specifying the length of the string returned.
If the value is larger than the length of the string then the entire
string is returned. If the value is less than 0 then a zero length string
is returned.

R e t u r n s

Returns a string variable of the length passed to the function.

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

attach 'string'
put call ('LEFT' , 'Test String' , 4) ! prints Test
a = 'AA Aerospace'
b = call ('LEFT' , a , 1) ! b contains 'A'
detach 'string'

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

RIGHT
MID
FORENAME

[RKabis]

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

Liefert einen Unterstring von einem anderen String
Returns a sub-string of another 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 a string of a given length from another string,
starting at a given position. The user tells the function how many
characters to return and where to start.
This function works in the same manner as the Programmer statement
EXTRACT. It is provided for users of Database Screen and Print forms.

S y n t a x

answer = call ('MID' , string , starting_position , length)

P a r a m e t e r

string - is any string or constant
starting_pos - is an integer, specifying the starting point that the
sub-string starts.
length - is an integer, specifying the length of the string
returned.
If starting_pos is less than 0 then it is set to the start of the string.
If starting_pos is larger than the string, then it is set to the end of
the string.
If length is larger than the length of the string then the entire string
is returned from the starting point. If length is less than 0 then a
zero length string is returned.

R e t u r n s

Returns a string variable of the length passed to the function.

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

attach 'string'
put call ('MID' , 'Test String' , 6 , 3) ! prints Str
a = 'AA Aerospace'
b = call ('MID' , a , 4 , 4) ! b contains 'Aero'
detach 'string'

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

RIGHT
LEFT
INITIALS

[RKabis]

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

Setzt einen String in on Groß- in Groß-Kleinschreibung um

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 a string where letters starting a word have been
converted to uppercase, while the other letters in the word are
converted to lowercase.
This function replaces the two Open Access programs previously required
to convert the string.

S y n t a x

answer = call ('PROPER' , string)

P a r a m e t e r

string - is any string or constant

R e t u r n s

Returns a string variable of the same length as the string passed to i

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

attach 'string'
put call ('PROPER' , 'TEST STRING') ! prints Test String
a = '27 HIGH STREET, MIDTOWN'
b = call ('PROPER' , a) ! b contains '27 High Street, Midtown'
detach 'string'

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

LCASE
UCASE

[RKabis]

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

Gibt die am weitesten rechts stehenden n Buchstaben einer Zeichenkette wieder.
Returns the right-most n characters of a 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 a string composed of the right-most characters of
a string passed to it. The user tells the function how many characters
to return.

S y n t a x

answer = call ('RIGHT' , string , length)

P a r a m e t e r

string - is any string or constant
length - is an integer, specifying the length of the string returned.
If length is larger than the length of the string then the entire
string is returned. If length is less than 0 then a zero length
string is returned.

R e t u r n s

Returns a string variable of the length passed to the function.

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

attach 'string'
put call ('RIGHT' , 'Test String' , 6) ! prints String
a = 'AA Aerospace'
b = call ('RIGHT' , a , 4) ! b contains 'pace'
detach 'string'

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

LEFT
MID
SURNAME

[RKabis]

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

Liefert einen Unterstring von einem anderen String einer Position.
Returns a substring of another string from a position

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 a string composed of the rest of another string
from a position passed to it. The user tells the function at what
point to start the copy from.
SUBSTR simplifies one of the most common uses of EXTRACT. Just the
starting position is required, the user does not have to know how long
the string is.

S y n t a x

answer = call ('SUBSTR' , string , value)
P a r a m e t e r
string - is any string or constant
value - is an integer, specifying the position the copy starts from.
If value is less than 1, then the entire string is returned. If value is
greater than the length of the string, then the last character is
returned.

R e t u r n s

Returns a string variable.

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

attach 'string'
put call ('SUBSTR' , 'Test String' , 6) ! prints String
a = 'AA Aerospace'
b = call ('SUBSTR' , a , 9) ! b contains 'pace'
detach 'string'

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

MID

[RKabis]

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

Liefert das letzte Wort (Nachname) von einem String.
Returns the last word (surname) of a 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 a string composed of the last word (effectively
the surname) of a string passed to it.

S y n t a x

answer = call ('SURNAME' , string)

P a r a m e t e r

string - is any string or constant

R e t u r n s

Returns a string variable, the length set to that of the last word.

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

attach 'string'
put call ('SURNAME' , 'Test String' ) ! prints String
a = 'Theo P Wildebeest'
b = call ('SURNAME' , a) ! b contains 'Wildebeest'
detach 'string'

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

FORENAME
INITIALS
RIGHT

[RKabis]

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

Löscht führende und abschließende Leerstellen aus einem String.
Remove leading and trailing blanks from a 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 a string where all leading or trailing spaces
have been removed.
This function is identical to the Open Access TRIM Programmer function.
It has been provided for users of the Database Screen and Print forms.

S y n t a x

answer = call ('TRIM' , string)

P a r a m e t e r

string - is any string or constant

R e t u r n s

Returns a string variable.

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

attach 'string'
put call ('TRIM' , ' Test String') ! prints Test String
a = ' AA Aerospace '
b = call ('TRIM' , a) ! b contains 'AA Aerospace'
detach 'string'

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