Lianja Language Reference

A

• Array Processing Functions
• ASCII File Access Functions
• Attributes

C

• C Extensions API
• Commands
• Comments
• Cursor Functions

D

• Data Analysis Functions
• Data Export
• Data Import
• Data Integration
• Database Functions
• Database Timelines
• Databases
• Date and Time Data Functions
• Declaring Variables and Arrays
• Deployment
• Disk and File Commands

E

• Encryption
• Environment Functions
• Error Handling

F

• Formatting Functions

F cont.

• Framework Classes
• Functions

G

• Getting Started

H

• HTML Functions

I

• Installation

J

• JSON Functions

L

• Lianja SQL Server
• Lianja VFP Extensions
• Libraries
• License Management
• Looping Commands

M

• Mail Functions
• Memos Functions
• Messaging Functions

N

• NoSQL Commands
• Numeric Data Functions

O

• Object Storage Functions
• Objects
• OData Functions
• ODBC Functions

P

• Page Builder
• Performance and Optimization

R

• Reference

S

• Search Functions
• Set Commands
• Socket Functions
• SQL
• SQL Functions
• String Data Functions
• System Tables

U

• UI Functions
• User Defined Functions

V

• VFP Command differences
• VFP Command Extensions
• VFP Compatibility
• VFP Function Differences
• VFP Function Extensions
• VFP Not Implemented
• VFP Other Differences
• VFP Other Features
• Video Tutorials

X

• XML

&

• &
• &&

*

• *

/

• Comment Block

?

• ?
• ??

A

• AADD()
• AAVERAGE()
• ABS()
• ACCESS()
• ACLASS()
• ACOPY()
• ACOS()
• Actionbar
• ACTIVEPID()
• ActiveX
• ADATABASES()
• ADD TABLE
• ADDBS()
• ADDPROPERTY()
• ADEL()
• ADESC()
• ADIR()
• AELEMENT()
• AFIELDS()
• AFILES()
• AFILL()
• AINS()
• ALEN()
• ALENGTH()
• ALIAS
• ALIAS()
• ALINES()
• ALLTRIM()
• ALLVALUES()
• ALTER Commands
• ALTER DATABASE
• ALTER INDEX
• ALTER TABLE
• ALTER VIRTUALTABLE
• AMAX()
• AMEMBERS()
• AMIN()
• AMPM()
• APPDIR()
• APPEND AUTOMEM
• APPEND BLANK
• APPEND Commands
• APPEND FROM
• APPEND FROM ARRAY
• APPEND MEMO
• APRINTERS()
• ARRAY ALEN()
• ARRAY DEFINE()
• ARRAY LOOKUP()
• ARRAY UPDATE()
• ARRAY()
• ASC()
• ASCAN()
• ASCII Chart
• ASELOBJ()
• ASIN()
• ASIZE()
• ASORT()
• ASTACKTRACE()
• ASTORE()
• ASTRING()

A cont.

• ASUBSCRIPT()
• ASUM()
• AT C()
• AT()
• ATABLES()
• ATAGINFO()
• ATAN()
• ATC()
• ATLINE()
• ATN2()
• ATNEXT()
• ATOH()
• ATOM()
• AUSED()
• AUTO INCREMENT Column Constraint
• AUTOINC Column Constraint
• AUTOSUGGESTIONHEADERS Column Constraint
• AUTOSUGGESTIONS Column Constraint
• AVERAGE
• AVG()
• AVGVALUES()

B

• BACKUP DATABASE
• BASE64 DECODE()
• BASE64 ENCODE FILE()
• BASE64 ENCODE IMAGE()
• BASE64 ENCODE()
• BASENAME()
• BEGIN Commands
• BEGIN SEQUENCE
• BEGIN TRANSACTION
• BETWEEN Predicate
• BETWEEN()
• BIN2I()
• BIN2L()
• BIN2W()
• BINCLOSE()
• BINCREATE()
• BINFILETOSTR()
• BINOPEN()
• BINREAD()
• BINSEEK()
• BINSTRTOFILE()
• BINWRITE()
• BITAND()
• BITCLEAR()
• BITLSHIFT()
• BITNOT()
• BITOR()
• BITRSHIFT()
• BITSET()
• BITTEST()
• BITXOR()
• BLANK
• BLOB READ()
• BLOB RECLAIM()
• BLOB SIZE()
• BLOB UPDATE()
• BLOB WRITE()
• BOF()
• BROWSE

C

• CAGR()
• CALCULATE
• CALCULATED Column Constraint
• Camera
• CANCELPID()
• CANDIDATE()
• CAST()

C cont.

• CD
• CDOW()
• CDX()
• CEILING()
• CENTER()
• CERROR()
• CHAR ALLTRIM()
• CHAR LOWER()
• CHAR LPAD()
• CHAR LTRIM()
• CHAR RPAD()
• CHAR RTRIM()
• CHAR STR()
• CHAR UPPER()
• CHARINDEX()
• Chart
• CHDIR
• CHECK Column Constraint
• CHECK DATABASE
• CHECK TABLE
• CHECK Table Constraint
• Checkbox
• CHECKUNIQUE Column Constraint
• CHOICES Column Constraint
• CHOOSE()
• CHR()
• CHROVERLAP()
• CHRTRAN()
• CHRTRANC()
• CLASS EXISTS()
• CLEAR
• CLEAR ALL
• CLEAR AUTOMEM
• CLEAR Commands
• CLEAR EVENTS
• CLEAR FCACHE
• CLEAR IOSTATS
• CLEAR LOCKS
• CLEAR MEMORY
• CLEAR NAMESPACE
• CLEAR PROFILE
• CLEAR SMARTQUERY
• CLEAR TIMELINE
• CLEARRESULTSET()
• CLOSE
• CLOSE ALL
• CLOSE ALTERNATE
• CLOSE APP
• CLOSE APPLICATION
• CLOSE CLASSLIB
• CLOSE Commands
• CLOSE DATABASE
• CLOSE DATABASES
• CLOSE INDEX
• CLOSE PROCEDURE
• CLOSE PROJECT
• CLOSE TABLES
• CLOSEMAIL()
• CMONTH()
• CNTVALUES()
• COALESCE()
• Collection
• Column
• COLUMNEXISTS()
• COLUMNMETADATA()
• Combobox