User contributions
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)
- 09:03, 16 November 2012 (diff | hist) . . (0) . . JUSTFNAME() (current)
- 09:03, 16 November 2012 (diff | hist) . . (0) . . JUSTSTEM() (current)
- 09:02, 16 November 2012 (diff | hist) . . (0) . . JUSTPATH() (current)
- 09:02, 16 November 2012 (diff | hist) . . (0) . . BASENAME() (current)
- 09:01, 16 November 2012 (diff | hist) . . (0) . . m FORCEEXT() (moved FORECEXT() to FORCEEXT()) (current)
- 09:01, 16 November 2012 (diff | hist) . . (+24) . . N FORECEXT() (moved FORECEXT() to FORCEEXT()) (current)
- 09:01, 16 November 2012 (diff | hist) . . (0) . . FORCEEXT()
- 09:00, 16 November 2012 (diff | hist) . . (+627) . . N FORCEPATH() (Created page with '==Purpose== Function to return a file name with a new path ==Syntax== FORCEPATH(<expC1>,<expC2>) ==See Also== BASENAME(), DBF(), DEFAULT(), DEFAULTEXT(), [[FORC…') (current)
- 08:57, 16 November 2012 (diff | hist) . . (+665) . . N FORCEEXT() (Created page with '==Purpose== Function to return a file name with a new extension ==Syntax== FORECEXT(<expC1>,<expC2>) ==See Also== BASENAME(), DBF(), DEFAULT(), DEFAULTEXT(), [[…')
- 08:55, 16 November 2012 (diff | hist) . . (+739) . . N DEFAULTEXT() (Created page with '==Purpose== Function to return a file name with a new extension if one does not already exist ==Syntax== DEFAULTEXT(<expC1>,<expC2>) ==See Also== BASENAME(), DBF(), [[D…')
- 08:18, 16 November 2012 (diff | hist) . . (+605) . . N JUSTDRIVE() (Created page with '==Purpose== Function to return the drive from a given file specification ==Syntax== JUSTDRIVE(<expC>) ==See Also== BASENAME(), DBF(), DEFAULT(), DEFAULTEXT(), […')
- 08:16, 16 November 2012 (diff | hist) . . (+623) . . N JUSTEXT() (Created page with '==Purpose== Function to return the file extension from a given file specification ==Syntax== JUSTEXT(<expC>) ==See Also== BASENAME(), DBF(), DEFAULT(), [[DEFAULTEXT…')
- 08:14, 16 November 2012 (diff | hist) . . (+656) . . N JUSTFNAME() (Created page with '==Purpose== Function to return filename without the path from a given file specification ==Syntax== JUSTFNAME(<expC>) ==See Also== BASENAME(), DBF(), DEFAULT(), [[D…')
- 08:11, 16 November 2012 (diff | hist) . . (0) . . JUSTPATH()
- 08:11, 16 November 2012 (diff | hist) . . (+661) . . N JUSTSTEM() (Created page with '==Purpose== Function to return the stem (filename without extension) from a given file specification ==Syntax== JUSTSTEM(<expC>) ==See Also== BASENAME(), DBF(), [[DEFAU…')
- 08:07, 16 November 2012 (diff | hist) . . (+2) . . JUSTPATH()
- 08:07, 16 November 2012 (diff | hist) . . (+623) . . N JUSTPATH() (Created page with '==Purpose== Function to return the path from a given file specification ==Syntax== JUSTPATH(<expC>) ==See Also== BASENAME, DBF(), DEFAULT(), DEFAULTEXT(), [[FOR…')
- 07:08, 16 November 2012 (diff | hist) . . (+290) . . ALTER TABLE
- 07:00, 16 November 2012 (diff | hist) . . (+326) . . USE
- 13:46, 15 November 2012 (diff | hist) . . (+8) . . REPLACE
- 13:43, 15 November 2012 (diff | hist) . . (+217) . . REPLACE
- 13:02, 15 November 2012 (diff | hist) . . (+60) . . SET ORDER
- 13:01, 15 November 2012 (diff | hist) . . (+60) . . INDEX
- 13:00, 15 November 2012 (diff | hist) . . (+20) . . TAGEXPR()
- 12:59, 15 November 2012 (diff | hist) . . (+1,459) . . N TAGFOR() (Created page with '==Purpose== Function to return the 'for' expression of an index tag ==Syntax== TAGFOR(<tag name>[,<.dbx filename>[,<alias>]]) ==See Also== KEY(), MDX(), ORDER(), [[…')
- 12:48, 15 November 2012 (diff | hist) . . (+1,182) . . N TAGKEY() (Created page with '==Purpose== Function to return the key expression of an index tag ==Syntax== TAGKEY(<tagno> [, <alias>]) ==See Also== KEY(), MDX(), ORDER(), SET INDEX, [[SET OR…')
- 12:47, 15 November 2012 (diff | hist) . . (+1,185) . . N TAGEXPR() (Created page with '==Purpose== Function to return the key expression of an index tag ==Syntax== TAGEXPR(<tagno> [, <alias>]) ==See Also== KEY(), MDX(), ORDER(), SET INDEX, [[SET O…')
- 12:38, 15 November 2012 (diff | hist) . . (+15) . . TAGNO()
- 11:11, 15 November 2012 (diff | hist) . . (-43) . . SQL Constraints
- 13:23, 14 November 2012 (diff | hist) . . (+1) . . ALTER VIRTUALTABLE
- 13:22, 14 November 2012 (diff | hist) . . (+1,918) . . N ALTER VIRTUALTABLE (Created page with '==Purpose== Creates a virtual table ==Syntax== ALTER VIRTUALTABLE [<database>!]<virtualtable> [ALIAS <name>] CONNSTR <odbc_dsn_string> AS <select statement> ==See …')
- 13:14, 14 November 2012 (diff | hist) . . (+2) . . CREATE VIRTUALTABLE
- 13:14, 14 November 2012 (diff | hist) . . (+2,048) . . N CREATE VIRTUALTABLE (Created page with '==Purpose== Creates a virtual table ==Syntax== CREATE VIRTUALTABLE [<database>!]<virtualtable> [IF NOT EXISTS] [ALIAS <name>] CONNSTR <odbc_dsn_string> AS <select …')
- 12:48, 14 November 2012 (diff | hist) . . (-963) . . CREATE TABLE
- 12:41, 14 November 2012 (diff | hist) . . (-67) . . ISRLOCKED() (current)
- 12:40, 14 November 2012 (diff | hist) . . (+785) . . ISRLOCKED()
- 12:30, 14 November 2012 (diff | hist) . . (-66) . . ISLOCKED() (current)
- 12:29, 14 November 2012 (diff | hist) . . (-263) . . ISLOCKED()
- 11:54, 14 November 2012 (diff | hist) . . (+56) . . N ISRLOCKED() (Created page with '// ISRLOCKED([nRecordNumber, [nWorkArea | cTableAlias]])')
- 11:35, 14 November 2012 (diff | hist) . . (0) . . ISREADONLY()
- 11:34, 14 November 2012 (diff | hist) . . (+1,243) . . N ISREADONLY() (Created page with '==Purpose== Function to determine if a table is open readonly ==Syntax== ISREADONLY([<expN> | <expC>]) ==See Also== ALIAS(), AUSED(), DATABASEEXISTS(), DBF(), […')
- 10:52, 14 November 2012 (diff | hist) . . (+15) . . GETWORDNUM()
- 10:36, 14 November 2012 (diff | hist) . . (+8) . . GETWORDCOUNT()
- 10:36, 14 November 2012 (diff | hist) . . (+1,204) . . N GETWORDNUM() (Created page with '==Purpose== Function to return the number of words in a string ==Syntax== GETWORDNUM(<expC1> [, <expC2>]) ==See Also== AT(), ATNEXT(), GETWORDCOUNT(), INLIST(),…')
- 10:30, 14 November 2012 (diff | hist) . . (+1,206) . . N GETWORDCOUNT() (Created page with '==Purpose== Function to return the number of words in a string ==Syntax== GETWORDCOUNT(<expC1> [, <expC2>]) ==See Also== AT(), ATNEXT(), GETWORDNUM(), INLIST(),…')
- 09:49, 14 November 2012 (diff | hist) . . (-603) . . DROP TABLE
- 09:48, 14 November 2012 (diff | hist) . . (+87) . . DROP TABLE
- 09:44, 14 November 2012 (diff | hist) . . (+49) . . ALTER TABLE
- 09:43, 14 November 2012 (diff | hist) . . (+5) . . CREATE TABLE
- 09:33, 14 November 2012 (diff | hist) . . (+616) . . N USEREMAIL() (Created page with '==Purpose== Function to return the email address for the current or specified user as defined in the Lianja Users Workspace ==Syntax== USEREMAIL([<expC>]) ==See Also== [[GETGID…')
- 09:32, 14 November 2012 (diff | hist) . . (+17) . . USERROLES()
- 09:32, 14 November 2012 (diff | hist) . . (+17) . . USERDOMAIN()
- 09:31, 14 November 2012 (diff | hist) . . (+17) . . USERNAME()
- 09:28, 14 November 2012 (diff | hist) . . (-24) . . OBJECTTYPE()
- 09:28, 14 November 2012 (diff | hist) . . (-24) . . OBJECTREAD()
- 09:26, 14 November 2012 (diff | hist) . . (-23) . . OBJECTWRITE()
- 08:53, 14 November 2012 (diff | hist) . . (+15) . . GETURL()
- 08:50, 14 November 2012 (diff | hist) . . (+3) . . TAGNO()
- 07:55, 14 November 2012 (diff | hist) . . (+14) . . GETURL()
- 07:46, 14 November 2012 (diff | hist) . . (+194) . . SQL SELECT
- 07:42, 14 November 2012 (diff | hist) . . (+33) . . SET XMLFORMAT
- 07:41, 14 November 2012 (diff | hist) . . (+152) . . SET XMLFORMAT
- 07:39, 14 November 2012 (diff | hist) . . (+40) . . SET XMLFORMAT
- 08:21, 26 October 2012 (diff | hist) . . (-802) . . SYS()
- 08:18, 26 October 2012 (diff | hist) . . (+10) . . SYS()
- 11:13, 3 October 2012 (diff | hist) . . (+1,017) . . N EVL() (Created page with '==Purpose== Function to specify an alternative value for an empty expression ==Syntax== EVL(<expr1>,<expr2>) ==See Also== EMPTY(), ETOS(), IFNULL(), ISNULL(), […')
- 11:10, 3 October 2012 (diff | hist) . . (+24) . . NVL()
- 11:08, 3 October 2012 (diff | hist) . . (+24) . . IFNULL()
- 10:48, 3 October 2012 (diff | hist) . . (+964) . . N IFNULL() (Created page with '==Purpose== Function to specify an alternative value for a null expression ==Syntax== IFNULL(<expr1>,<expr2>) ==See Also== ETOS(), ISNULL(), NVL(), SET NULL, [[…')
- 10:47, 3 October 2012 (diff | hist) . . (-43) . . NVL()
- 10:05, 3 October 2012 (diff | hist) . . (+443) . . N DIRECTORY() (Created page with '==Purpose== Function to check whether directory exists ==Syntax== DIRECTORY(<expC>[,<expN>]) ==See Also== DATABASEEXISTS(), FILE(), SET FILECASE, SET PATH, [[TA…') (current)
- 09:43, 3 October 2012 (diff | hist) . . (+58) . . FILE() (current)
- 09:32, 3 October 2012 (diff | hist) . . (-16) . . WAIT
- 09:32, 3 October 2012 (diff | hist) . . (+1,154) . . N WAIT (Created page with '==Purpose== Suspend program execution pending a key press or mouse-click ==Syntax== WAIT [<expC>] [CLEAR] [NOWAIT] [TO <memvar>] [TIMEOUT <expN>] [WINDOW] ==See Also== [[D…')
- 08:59, 3 October 2012 (diff | hist) . . (+10) . . AUSED()
- 08:59, 3 October 2012 (diff | hist) . . (+13) . . USED()
- 08:58, 3 October 2012 (diff | hist) . . (+13) . . USE
- 08:58, 3 October 2012 (diff | hist) . . (+1,119) . . N AUSED() (Created page with '==Purpose== Function to load the alias name and cursor/workarea number of all open tables into an array ==Syntax== AUSED(<array-name>) ==See Also== ALIAS(), DATABASE(),…')
- 08:36, 3 October 2012 (diff | hist) . . (+613) . . STOD()
- 08:36, 3 October 2012 (diff | hist) . . (+601) . . STOT()
- 08:35, 3 October 2012 (diff | hist) . . (0) . . STOD()
- 08:34, 3 October 2012 (diff | hist) . . (+12) . . CTOT()
- 08:34, 3 October 2012 (diff | hist) . . (+12) . . STOT()
- 08:33, 3 October 2012 (diff | hist) . . (+688) . . N STOT() (Created page with '==Purpose== Function to perform string to datetime conversion ==Syntax== STOT(<expC>) ==See Also== CTOD(), DTOS(), SET CENTURY, STOD() ==Description== The STOT…')
- 08:20, 2 October 2012 (diff | hist) . . (+669) . . N TABLEEXISTS() (Created page with '==Purpose== Function to check whether table exists ==Syntax== TABLEEXISTS(<expC1>, <expC2>) ==See Also== CLOSE DATABASES, CREATE DATABASE, DATABASE(), [[DATABASEEXI…')
- 08:15, 2 October 2012 (diff | hist) . . (+563) . . N DATABASEEXISTS() (Created page with '==Purpose== Function to check whether database exists ==Syntax== DATABASEEXISTS(<expC>) ==See Also== CLOSE DATABASES, CREATE DATABASE, DATABASE(), DBC(), [[DBF(…')
- 08:12, 2 October 2012 (diff | hist) . . (+41) . . DATABASE()
- 08:11, 2 October 2012 (diff | hist) . . (+41) . . OPEN DATABASE
- 07:53, 2 October 2012 (diff | hist) . . (-1,059) . . OPEN DATABASE
- 07:51, 2 October 2012 (diff | hist) . . (+11) . . CLOSE DATABASES
- 07:51, 2 October 2012 (diff | hist) . . (-678) . . ADATABASES()
- 07:50, 2 October 2012 (diff | hist) . . (-115) . . DATABASE()
- 07:49, 2 October 2012 (diff | hist) . . (+685) . . N DBC() (Created page with '==Purpose== Function to return the name of the currently open database ==Syntax== DBC() ==See Also== ADATABASES(), ALIAS(), CLOSE DATABASES, DATABASE(), [[DBF()…')
- 07:45, 2 October 2012 (diff | hist) . . (+8) . . USERDOMAIN()
- 07:45, 2 October 2012 (diff | hist) . . (+24) . . USERDOMAIN()
- 07:44, 2 October 2012 (diff | hist) . . (+574) . . N USERROLES() (Created page with '==Purpose== Function to return the roles for the current or specified user as defined in the Lianja Users Workspace ==Syntax== USERROLES([<expC>]) ==See Also== GETGID(), [[…')
- 07:42, 2 October 2012 (diff | hist) . . (+1) . . ID()
- 07:42, 2 October 2012 (diff | hist) . . (+1) . . USER()
- 07:42, 2 October 2012 (diff | hist) . . (+1) . . USERNAME()
- 07:41, 2 October 2012 (diff | hist) . . (+572) . . N USERDOMAIN() (Created page with '==Purpose== Function to return the login name of the current user as defined in the Lianja Users Workspace ==Syntax== USERDOMAIN([<expC>]) ==See Also== GETGID(), [[GETPID()…')
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)