Functions

Top  Previous  Next

ABS()

Implemented

 

ACOS()

Implemented.

 

ADDBS()

Implemented.

 

ADEL()

Implemented.

 

ADIR()

Implemented. Currently only the first two columns are filled.

 

AERROR()

Implemented.

 

ALEN()

Implemented.

 

ALIAS()

Implemented.

 

ALINES()

Implemented.

 

ALLTRIM()

Implemented.

 

APRINTERS()

Implemented.

 

ASC()

Implemented. ASC() operates on the current system codepage. Any codepage definition in the Config.FPW file is currently ignored.

 

ASCAN()

partially implemented. Not fully working.

 

ASIN()

Implemented.

 

AT()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

ATAN()

Implemented.

 

ATC()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

ATN2()

Implemented.

 

BETWEEN()

Implemented.

 

BITAND()

Implemented.

 

BITCLEAR()

Implemented.

 

BITLSHIFT()

Implemented.

 

BITNOT()

Implemented.

 

BITOR()

Implemented.

 

BITRSHIFT()

Implemented.

 

BITSET()

Implemented.

 

BITTEST()

Implemented.

 

BITXOR()

Implemented.

 

BOF()

Implemented.

 

CEILING()

Implemented.

 

CHR()

Implemented. CHR() uses the current codepage ignoring any custom code page specification in the Config.FPW file.

 

CHRTRAN()

Implemented.

 

CMONTH()

Implemented.

 

COS()

Implemented.

 

CREATEOBJECT()

Implemented for native classes. COM objects cannot be instantiated. Additional parameters are not supported.

 

Difference to VFP: You can load .NET objects that have been made available by SET CLASSLIB TO.

 

CTOD()

Implemented.

 

CTOT()

Implemented.

 

CURDIR()

Implemented.

 

DATE()

Implemented.

 

DATETIME()

Implemented.

 

DAY()

Implemented.

 

DEFAULTEXT()

Implemented.

 

DELETED()

Implemented.

 

DIRECTORY()

Implemented.

 

DISPLAYPATH()

Implemented.

 

DRIVETYPE()

Implemented.

 

DTOC()

Implemented.

 

DTOR()

Implemented.

 

DTOS()

Implemented.

 

EMPTY()

Implemented.

 

EOF()

 

Implemented.

EVALUATE()

Implemented for field, variable and property access. Calculations can not yet be performed.

 

EVL()

Implemented.

 

EXP()

Implemented.

 

FCOUNT()

Implemented.

 

FCHSIZE()

Implemented.

 

FCLOSE()

Implemented.

 

FCREATE()

Implemented.

 

Difference to VFP: Supports file names with an exclamation mark.

 

FDATE()

Implemented. nType Parameter not supported.

 

FEOF()

Implemented.

 

FERROR()

Implemented.

 

FIELD()

Implemented.

 

FFLUSH()

Implemented.

 

FGETS()

Implemented.

 

FILE()

Implemented.

 

Difference to VFP: On Unix based systems the file name is case-sensitive.

 

FILETOSTR()

Implemented.

 

Difference to VFP: Files with more than 16 MB are supported. On Unix based systems the file name is case-sensitive. Files with a byte-order mark or a UTF-8 flag are recognized as Unicode file when Unicode support is enabled. See SYS(8000).

 

FLOOR()

Implemented.

 

FONTMETRIC()

Implemented.

 

FOPEN()

Implemented.

 

Difference to VFP: Supports file names with an exclamation mark.

 

FORCEEXT()

Implemented.

 

FORCEPATH()

Implemented.

 

FOUND()

Implemented.

 

FPUTS()

Implemented.

 

FREAD()

Implemented.

 

FSEEK()

Implemented.

 

FTIME()

Implemented.

 

FULLPATH()

Implemented. The syntax with two parameters is not supported.

 

FV()

Implemented.

 

FWRITE()

Implemented.

 

GETENV()

Implemented.

 

GETPEM()

Implemented.

 

GETWORDCOUNT()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

GETWORDNUM()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

GOMONTH()

Implemented.

 

HOUR()

Implemented.

 

ICASE()

Implemented.

 

IIF()

Implemented.

 

INLIST()

Implemented.

 

INT()

Implemented.

 

ISALPHA()

Implemented.

 

ISDIGIT()

Implemented.

 

ISLOWER()

Implemented.

 

ISNULL()

Implemented.

 

ISUPPER()

Implemented.

 

JUSTDRIVE()

Implemented.

 

JUSTEXT()

Implemented.

 

JUSTFNAME()

Implemented.

 

JUSTPATH()

Implemented.

 

JUSTSTEM()

Implemented.

 

LEFT()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

LEN()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

LOG()

Implemented.

 

LOG10()

Implemented.

 

LOWER()

Implemented.

 

MAX()

Implemented.

 

MESSAGEBOX()

Implemented.

 

MIN()

Implemented.

 

MINUTE()

Implemented.

 

MONTH()

Implemented.

 

NEWOBJECT()

Implemented for native classes. COM objects cannot be instantiated. Additional parameters are not supported.

 

NVL()

Implemented

 

OCCURS()

Implemented.

 

OS()

Implemented for 1-6

 

PADC()

Implemented.

 

PADL()

Implemented.

 

PADR()

Implemented.

 

PARAMETERS()

Implemented.

 

Difference to VFP: PARAMETERS() behaves like PCOUNT() and is not reset for other calls.

 

PAYMENT()

Implemented.

 

PI()

Implemented.

 

PROGRAM()

Implemented.

 

PV()

Implemented.

 

QUARTER()

Implemented.

 

RAND()

Implemented.

 

Difference to VFP: Guineu uses a different algorithm to generate random numbers.

 

RAT()

Implemented.

 

RATC()

Implemented.

 

RECCOUNT()

Implemented.

 

RECNO()

Implemented.

 

REPLICATE()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

RGB()

Implemented.

 

RIGHT()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

ROUND()

Implemented.

 

RTOD()

Implemented.

 

SEC()

Implemented.

 

SECONDS()

Implemented.

 

Difference to VFP: On Mono platforms the resolution of SECONDS() is approximately 50 ms.

 

SEEK()

Implemented. Currently the last parameter with the index tag is ignored.

 

SELECT()

Implemented.

 

SIGN()

Implemented.

 

SIN()

Implemented.

 

SOUNDEX()

Implemented.

 

SPACE()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

SQLDISCONNECT()

Implemented.

 

SQLEXEC()

Implemented for queries that return a single result set. SQLSETPROP() is ignored. Queries are always executed synchronously. AERROR() isn't updated.

 

SQLSTRINGCONNECT()

Implemented. Not all errors are handled. AERROR() is not set. SQLSETPROP() settings are ignored.

 

SQRT()

Implemented.

 

STR()

Implemented.

 

STRCONV()

Implemented.

 

Differences to VFP: Additional conversion types available.

 

STREXTRACT()

Implemented.

 

Difference to VFP: Strings with more than 16 MB are supported.

 

STRTOFILE()

Implemented. The lAdditive/nFlag parameter is currently ignored.

 

Difference to VFP: On Unix based systems, the file name is case-sensitive. Supports Strings with more than 16 MB. In Unicode mode the file is written with UTF-8 encoding and no byte order mark. See SYS(8000) for details.

 

STRTRAN()

Implemented.

 

STUFF()

Implemented.

 

SUBSTR()

Implemented.

 

Difference to VFP: Supports strings with more than 16 MB.

 

SYS(0)

Implemented.

 

SYS(1)

Implemented.

 

SYS(2)

Implemented.

 

SYS(3)

Implemented.

 

SYS(16)

Implemented.

 

SYS(1079)

Implemented.

 

SYS(2000)

Implemented.

 

SYS(2015)

Implemented.

 

SYSMETRIC()

Implemented.

 

TAN()

Implemented.

 

TIME()

Implemented.

 

TRANSFORM()

Implemented. Only "@0" is currently supported as a format code. Numeric values ignore SET("DECIMALS").

 

TTOD()

Implemented.

 

UPPER()

Implemented.

 

Difference to VFP: Supports strings with more than 16 MB.

 

USED()

Implemented.

 

VAL()

Implemented.

 

VARTYPE()

Implemented.

 

VERSION()

Implemented.

 

Difference to VFP: Guineu uses version number 09.10 instead of 09.00.

 

YEAR()

Implemented.