List of Functions in VO
Posted: Tue Dec 20, 2022 10:38 pm
Could someone give me a hint where to find a list of VO functions?
Actually I am searching for any function in VO. To be able to transfer VO to X# there definitely needs to be a source for such a list but I was not able to find it inside this forum.
But in general I would be grateful for every function you can give me as VO documentation becomes rare. If it is ok for the Forum (users and hosters/admins). I would like to use this post to collect the known functions. Of course if someone can give a working link to an existing link this would make no sense anymore. If noone states contrary I would list your hints / functions in this prime post, so that it can maybe be used for others to search as well.
BR christian
Following functions are known for me. Please feel free to feed me with hints for other functions but as well if you consider a function not to be "original" VO
alltrim()
deletes spaces in the beginning and the end of a text
at()
searches for a text inside another text
chr()
transfer of an Ascii-(Dec)-Number into the corresponding single character
Syntax:
cASCII := chr(nASCII)
- nASCII - decimal number of the ASCII256 table
- cASCII - character that corresponds to nASCII in regards to the ASCII256 table
ctod()
transfer of a date in textform "dd.mm.yyyy" into a date
day()
gives the day out of a date
dtoc()
transfer of a date into the textform "dd.mm.yyyy"
empty()
returns .t. if an object is not filled
left()
gives a number of characters from the beginning of a text
len()
gives the length of a string
max()
gives the biggest number from a group of numbers
min()
gives the smallest number from a group of numbers
month()
gives the month out of a date
right()
gives a number of characters from the end of a text
seconds()
str()
transfers a number into a text
substring()
gives the part of a texts that has its position between a startingpoint and an ending point
time()
should give the actual time - (seems not to work in some makro environments - hints for exact syntax/formats are welcome)
today()
gives the date of the actual day (machine time)
trim()
deletes spaces at the end of a text
val()
transfers numbers in textform into a number
year()
gives the year out of a date
Actually I am searching for any function in VO. To be able to transfer VO to X# there definitely needs to be a source for such a list but I was not able to find it inside this forum.
But in general I would be grateful for every function you can give me as VO documentation becomes rare. If it is ok for the Forum (users and hosters/admins). I would like to use this post to collect the known functions. Of course if someone can give a working link to an existing link this would make no sense anymore. If noone states contrary I would list your hints / functions in this prime post, so that it can maybe be used for others to search as well.
BR christian
Following functions are known for me. Please feel free to feed me with hints for other functions but as well if you consider a function not to be "original" VO
alltrim()
deletes spaces in the beginning and the end of a text
at()
searches for a text inside another text
chr()
transfer of an Ascii-(Dec)-Number into the corresponding single character
Syntax:
cASCII := chr(nASCII)
- nASCII - decimal number of the ASCII256 table
- cASCII - character that corresponds to nASCII in regards to the ASCII256 table
ctod()
transfer of a date in textform "dd.mm.yyyy" into a date
day()
gives the day out of a date
dtoc()
transfer of a date into the textform "dd.mm.yyyy"
empty()
returns .t. if an object is not filled
left()
gives a number of characters from the beginning of a text
len()
gives the length of a string
max()
gives the biggest number from a group of numbers
min()
gives the smallest number from a group of numbers
month()
gives the month out of a date
right()
gives a number of characters from the end of a text
seconds()
str()
transfers a number into a text
substring()
gives the part of a texts that has its position between a startingpoint and an ending point
time()
should give the actual time - (seems not to work in some makro environments - hints for exact syntax/formats are welcome)
today()
gives the date of the actual day (machine time)
trim()
deletes spaces at the end of a text
val()
transfers numbers in textform into a number
year()
gives the year out of a date