Bring HTML5 to Livecode - $395,366 pledged of $395,000 target - 100% Funded - We Made It See Campaign >

revOpenDatabase

Showing 1775 items

$

$_COOKIE

$_FILES

$_GET

$_GET_BINARY

$_GET_RAW

$_POST

$_POST_BINARY

$_POST_RAW

$_SERVER

&

&&

()

*

+

,

-

--

/

/**/

;

<

<=

<>

=

>

>=

@

abbreviated

abs

accelerationChanged

acceleratorKey

acceleratorModifiers

acceleratorText

accentColor

accept

acceptDrop

acos

activatePalettes

add

addMax

addOver

addPin

address

adMin

after

aliasReference

allowableDragActions

allowFieldRedraw

allowInlineInput

allowInterrupts

allowKeyInField

alphaData

alternateLanguages

altID

altKey

alwaysBuffer

and

angle

annuity

answer

answer color

answer effect

answer file

answer file with type

answer folder

answer page setup

answer printer

answer record

antialiased

any

appleEvent

arcAngle

armBorder

armed

armedIcon

armFill

arrayDecode

arrayEncode

arrow

arrowKey

arrowSize

as

ascending

asin

ask

ask file

ask file with type

ask password

at

atan

atan2

audioClip

autoArm

autoHilite

autoTab

availablePrinters

average

back

backdrop

backgroundBehavior

backgroundColor

backgroundIDs

backgroundNames

backgroundPattern

backgroundPixel

backScripts

backSize

backslash

backspaceKey

base64Decode

base64Encode

baseConvert

beep

beepDuration

beepLoudness

beepPitch

beepSound

before

begins with

behavior

binaryDecode

binaryEncode

binfile

bitAnd

bitNot

bitOr

bitXor

black

blend

blendLevel

blindTyping

blinkRate

bold

borderColor

borderPattern

borderPixel

borderWidth

bottom

bottomColor

bottomLeft

bottomMargin

bottomPattern

bottomPixel

bottomRight

boundingBox

boundingRect

box

break

break

breakpoint

browse

browserBeforeNavigate

browserBeforeNavigateFrame

browserClick

browserClosing

browserDocumentComplete

browserDocumentCompleteFrame

browserDownloadRequest

browserFinishedLoading

browserLoadFailed

browserLoadRequest

browserNavigateComplete

browserNavigateCompleteFrame

browserNewInstance

browserNewUrlWindow

browserOut

browserOver

browserStartedLoading

brush

brush

brushColor

brushPattern

bucket

bufferHiddenImages

bufferMode

buildNumber

busy

button

button

by

byte

bytes

byteToNum

cachedURLs

call

callbacks

cancel

cancel printing

cantAbort

cantDelete

cantModify

cantSelect

capsLockKey

capStyle

card

card

cardIDs

cardNames

cascade

case

caseSensitive

catch

centered

centuryCutoff

character

characters

charSet

charToNum

checkmark

choose

cipherNames

clear

click

clickChar

clickCharChunk

clickChunk

clickField

clickH

clickLine

clickLoc

clickStack

clickText

clickV

clipboard

clipboardData

clone

close

close driver

close file

close printing

close process

close socket

closeBackground

closeBox

closeCard

closeControl

closeField

closeStack

closeStackRequest

colon

colorMap

colorNames

colorOverlay

colorPalette

colors

colorWorld

columnDelimiter

combine

comboBox

comma

commandChar

commandKey

commandKeyDown

commandNames

COMn:

compact

compound

compress

condensed

constant

constantMask

constantNames

constraints

contains

control

controlKey

controlKeyDown

convert

convertOctals

copy

copyKey

copyResource

cos

create

create alias

create card

create folder

create stack

CRLF

crop

cross

currentFrame

currentNode

currentPage

currentTime

currentTimeChanged

cursor

curve

customKeys

customProperties

customPropertySet

customPropertySets

cut

cutKey

dashes

date

dateFormat

dateItems

dateTime

debugDo

decompress

decorations

decrypt

decrypt using rsa

default

default

defaultButton

defaultCursor

defaultFolder

defaultMenubar

defaultNetworkInterface

defaultStack

define

delete

delete chunk

delete file

delete folder

delete stack

delete URL

delete variable

deleteBackground

deleteButton

deleteCard

deleteEPS

deleteField

deleteGraphic

deleteGroup

deleteImage

deleteKey

deletePlayer

deleteRegistry

deleteResource

deleteScrollbar

deleteStack

descending

desktopChanged

destroyStack

destroyWindow

dialogData

disable

disable menu

disabled

disabledIcon

diskSpace

dispatch

div

divide

DNSServers

do

doMenu

done

dontDither

dontRefresh

dontResize

dontSearch

dontUseNS

dontUseQT

dontUseQTEffects

dontWrap

doubleClickDelta

doubleClickInterval

down

drag

dragAction

dragData

dragDelta

dragDestination

dragDrop

dragEnd

dragEnter

draggable

dragImage

dragImageOffset

dragLeave

dragMove

dragSource

dragSpeed

dragStart

drawer

driverNames

dropChunk

dropper

dropShadow

duration

dynamicPaths

each

edit

editBackground

editMenus

editMode

editScript

editScripts

effective

effectRate

eight

eighth

element

else

emacsKeyBindings

empty

enable

enable menu

enabled

enabledTracks

encrypt

encrypt using rsa

end

end if

end repeat

end switch

end try

endArrow

endFrame

ends with

endTime

endValue

english

enterInField

enterKey

environment

EOF

EPS

eraser

eraser

errorDialog

errorMode

errorObject

escapeKey

executionContexts

exists

exit

exit repeat

exit to top

exitField

exp

exp1

exp10

exp2

expanded

explicitVariables

export

export snapshot

export with palette

extendKey

extents

externalCommands

externalFunctions

externalPackages

externals

false

family

field

field

fifth

file

filename

filename of stack

files

fileType

filled

fillGradient

fillRule

filter

finally

find

first

firstIndent

five

fixedLineHeight

flip

flushEvents

focus

focusColor

focusedObject

focusIn

focusOut

focusPattern

focusPixel

folders

fontLanguage

fontNames

fontSizes

fontStyles

for

foregroundColor

foregroundPattern

foregroundPixel

forever

format

formatForPrinting

formattedHeight

formattedLeft

formattedRect

formattedText

formattedTop

formattedWidth

formfeed

foundChunk

foundField

foundLine

foundLoc

foundText

four

fourth

frameCount

frameRate

freeSize

from

front

frontScripts

ftp

ftpProxy

fullscreen

function

functionKey

functionNames

get

getProp

getResource

getResources

global

globalLoc

globalNames

go

grab

graphic

graphic

gray

gRevAppIcon

gRevProfileReadOnly

gRevSmallAppIcon

grid

gridSize

group

group

groupIDs

groupNames

hand

hasMemory

HCAddressing

HCImportStat

HCStack

headingChanged

headingError

heapSpace

height

help

help

hGrid

hide

hide groups

hide menubar

hide taskbar

hideBackdrop

hideConsoleWindows

hidePalettes

hilite

hilite

hiliteBorder

hiliteColor

hilitedButton

hilitedButtonID

hilitedButtonName

hilitedIcon

hilitedLine

hiliteFill

hilitePattern

hilitePixel

home

hostAddress

hostAddressToName

hostName

hostNameToAddress

hotSpot

hotspotClicked

hotspots

hoverIcon

hScroll

hScrollbar

HTMLText

http

httpHeaders

HTTPProxy

https

iBeam

icon

iconic

iconifyStack

ID

IDChanged

idle

idleRate

idleTicks

if

image

image

imageData

imagePixmapID

imageSource

import

import snapshot

in

include

ink

innerGlow

innerShadow

inputBeginEditing

inputEndEditing

inputReturnKey

inputTextChanged

insert script

int1

int2

int4

integer

internet

interrupt

intersect

intersect

intersect

into

inverse

invisible

iosBrowser

iosMultiline

iosPlayer

iosScroller

iosTextInput

iphoneApplicationIdentifier

iphoneCanTrackHeading

iphoneCanTrackLocation

iphoneClearTouches

iphoneControlCreate

iphoneControlDelete

iphoneControlDo

iphoneControlGet

iphoneControls

iphoneControlSet

iphoneControlTarget

iphoneCurrentHeading

iphoneCurrentLocale

iphoneCurrentLocation

iphoneDeleteSoundChannel

iphoneDeviceResolution

iphoneDeviceScale

iphoneExportImageToAlbum

iphoneHeadingCalibrationTimeout

iphoneIdleTimerLocked

iphoneLockIdleTimer

iphoneNextSoundOnChannel

iphonePausePlayingOnChannel

iphonePick

iphonePickDate

iphonePlaySoundOnChannel

iphonePreferredLanguages

iphoneResumePlayingOnChannel

iphoneSetHeadingCalibrationTimeout

iphoneSetKeyboardReturnKey

iphoneSetSoundChannelVolume

iphoneSetStatusBarStyle

iphoneSoundChannels

iphoneSoundChannelStatus

iphoneSoundChannelVolume

iphoneSoundOnChannel

iphoneStartTrackingHeading

iphoneStartTrackingLocation

iphoneStopPlayingOnChannel

iphoneStopTrackingHeading

iphoneStopTrackingLocation

iphoneSystemIdentifier

iphoneUnlockIdleTimer

iphoneUseDeviceResolution

is a

is among

is among the keys of

is in

is not a

is not among

is not among the keys of

is not in

is not within

is within

isNumber

ISOToMac

it

italic

item

itemDelimiter

itemOffset

items

joinStyle

JPEGQuality

keyboardActivated

keyboardDeactivated

keyDown

keys

keysDown

keyUp

kill

label

last

launch

launch document

launch url

layer

left

left

leftMargin

length

libraryStack

libURLDownloadToFile

libURLErrorData

libURLFollowHttpRedirects

libURLFormData

libURLftpCommand

libURLftpUpload

libURLftpUploadFile

libURLLastHTTPHeaders

libURLLastRHHeaders

libURLMultipartFormAddPart

libURLMultipartFormData

libURLSetAuthCallback

libURLSetCustomHTTPHeaders

libURLSetExpect100

libURLSetFTPListCommand

libURLSetFTPMode

libURLSetFTPStopTime

libURLSetLogField

libURLSetStatusCallback

libURLVersion

licensed

line

lineDelimiter

lineIncrement

lineOffset

lines

lineSize

link

linkClicked

linkColor

linkHiliteColor

linkText

linkVisitedColor

listBehavior

liveResizing

ln

ln1

load

local

localLoc

localNames

location

locationChanged

locationError

lock colorMap

lock cursor

lock error dialogs

lock menus

lock messages

lock moves

lock recent

lock screen

lockColorMap

lockCursor

lockErrorDialogs

lockLocation

lockMenus

lockMessages

lockMoves

lockRecent

lockScreen

lockText

log10

log2

long

longFilePath

longWindowTitles

lookAndFeel

looping

lowResolutionTimers

LPT1:

machine

macToISO

magnifier

magnify

mainStack

mainStackChanged

mainStacks

margins

mark

mark

markChar

marked

markerDrawn

markerFilled

markerLineSize

markerPoints

maskData

maskPixmapID

matchChunk

matchText

matrixMultiply

max

maxHeight

maximize

maxWidth

mcEncrypt

MCISendString

mcLicense

md5Digest

me

median

mediaTypes

menu

menubar

menuButton

menuHistory

menuItem

menuLines

menuMessage

menuMode

menuMouseButton

menuName

menuPick

menus

merge

message box

metal

middle

milliseconds

milliseconds

mimeText

min

minHeight

minimize

minimizeBox

minWidth

miterLimit

mnemonic

mobileAllowedOrientations

mobileBuildInfo

mobileCameraFeatures

mobileCanSendMail

mobileComposeHtmlMail

mobileComposeMail

mobileComposeUnicodeMail

mobileDeviceOrientation

mobileDisableAccelerometer

mobileEnableAccelerometer

mobileHideStatusBar

mobileLockOrientation

mobileOrientation

mobileOrientationLocked

mobilePickPhoto

mobileSetAllowedOrientations

mobileSetKeyboardType

mobileShowStatusBar

mobileUnlockOrientation

mod

modal

mode

modeless

modem:

modifiedMark

monthNames

motionEnd

motionRelease

motionStart

mouse

mouseChar

mouseCharChunk

mouseChunk

mouseClick

mouseColor

mouseControl

mouseDoubleDown

mouseDoubleUp

mouseDown

mouseDownInBackdrop

mouseEnter

mouseH

mouseLeave

mouseLine

mouseLoc

mouseMove

mouseRelease

mouseStack

mouseStillDown

mouseText

mouseUp

mouseUpInBackdrop

mouseV

mouseWithin

move

moveControl

moveSpeed

moveStack

moveStopped

movie

movieControllerID

movieTouched

movingControls

multiEffect

multiple

multipleLines

multiply

multiSpace

name

nameChanged

navigationArrows

networkInterfaces

newBackground

newButton

newCard

newEPS

newField

newGraphic

newGroup

newImage

newPlayer

newScrollbar

newStack

newTool

next

next repeat

nine

ninth

nodeChanged

nodes

noncontiguousHilites

noOp

normal

not

notSrcAnd

notSrcAndReverse

notSrcBic

notSrcCopy

notSrcOr

notSrcOrReverse

notSrcXOr

null

number

number

numberFormat

numeric

numToByte

numToChar

of

offset

on

one

onto

opaque

opaque

open driver

open file

open printing

open printing to pdf

open process

open socket

openBackground

openCard

openControl

openField

openFiles

openProcesses

openProcessIDs

openSockets

openStack

openStacks

option

option

optionKey

optionKeyDown

or

orientation

orientationChanged

outerGlow

outputLineEndings

outputTextEncoding

oval

owner

pageCount

pageHeights

pageIncrement

paint

paintCompression

palette

palindromeFrames

pan

param

paramCount

params

pass

passKey

password

paste

pasteKey

patterns

paused

peerAddress

penBack

pencil

penColor

pendingMessages

penPattern

pi

pixels

pixmapID

place

plain

plainText

platform

play

play file

play file

play video

playDestination

player

player

playerEnterFullscreen

playerError

playerFinished

playerLeaveFullscreen

playerMovieChanged

playerProgressChanged

playerPropertyAvailable

playerStopped

playLoudness

playPaused

playRate

playSelection

playStarted

playStopped

plus

point

pointer

pointerFocus

points

polygon

polySides

pop

popup

popup

post

postScript

powerKeys

preOpenBackground

preOpenCard

preOpenControl

preOpenStack

prepare

preserveVariables

previous

print

print anchor

print bookmark

print link

printCardBorders

printCollate

printColors

printCommand

printCopies

printDuplex

printer:

printerFeatures

printerName

printerOutput

printerSettings

printFontTable

printGutters

printMargins

printPageNumber

printPaperOrientation

printPaperRectangle

printPaperScale

printPaperSize

printRanges

printRectangle

printRotated

printRowsFirst

printScale

printTextAlign

printTextFont

printTextHeight

printTextSize

printTextStyle

printTitle

private

privateColors

processID

processor

prolog

properties

propertyNames

proportionalThumbs

pulldown

pulldown

push

put

put binary

put content

put cookie

put header

put markup

put text

qtDebugStr

qtEffects

qtIdleRate

qtVersion

queryRecordChanged

queryRegistry

quit

quote

radioBehavior

raiseMenus

raisePalettes

raiseWindows

random

randomBytes

randomSeed

rawKeyDown

rawKeyUp

read from driver

read from file

read from process

read from socket

real4

real8

recent

recentCards

recentNames

record sound

recordChannels

recordCompression

recordCompressionTypes

recordFormat

recordFormats

recording

recordInput

recordLoudness

recordRate

recordSampleSize

rectangle

rectangle

recursionLimit

redo

regular

relative

relativePoints

relaunch

relayerGroupedControls

releaseStack

reloadStack

remapColor

remove

remove script

rename

repeat

repeatCount

repeatDelay

repeatRate

replace

replaceText

reply

request

request appleEvent

require

reset

reset cursors

reset paint

reset printing

resetAll

resfile

resizable

resizeControl

resizeQuality

resizeStack

result

resume

resumeStack

retainImage

retainPostScript

return

return

returnInField

returnKey

revAddXMLNode

revAppendXML

revAppVersion

revBrowserBack

revBrowserCallScript

revBrowserClose

revBrowserExecuteScript

revBrowserForward

revBrowserGet

revBrowserInstances

revBrowserMakeTextBigger

revBrowserMakeTextSmaller

revBrowserNavigate

revBrowserOpen

revBrowserPrint

revBrowserRedraw

revBrowserRefresh

revBrowserSet

revBrowserSnapshot

revBrowserStop

revCacheGeometry

revChangeWindowSize

revCloseCursor

revCloseDatabase

revCloseVideoGrabber

revCommitDatabase

revCopyFile

revCopyFolder

revCopyXMLNode

revCreateXMLTree

revCreateXMLTreeFromFile

revCreateXMLTreeFromFileWithNamespaces

revCreateXMLTreeWithNamespaces

revCurrentRecord

revCurrentRecordIsFirst

revCurrentRecordIsLast

revDatabaseColumnCount

revDatabaseColumnIsNull

revDatabaseColumnLengths

revDatabaseColumnNamed

revDatabaseColumnNames

revDatabaseColumnNumbered

revDatabaseColumnTypes

revDatabaseConnectResult

revDatabaseCursors

revDatabaseID

revDatabaseTableNames

revDatabaseType

revDataFromQuery

revdb_closecursor

revdb_commit

revdb_disconnect

revdb_execute

revdb_movefirst

revdb_movelast

revdb_movenext

revdb_moveprev

revdb_rollback

revDeleteAllXMLTrees

revDeleteFolder

revDeleteXMLNode

revDeleteXMLTree

revEndXMLNode

reverse

revert

revExecuteSQL

revFontLoad

revFontUnload

revGetDatabaseDriverPath

revGetSpeechVolume

revGoToFramePaused

revGoURL

revInitializeVideoGrabber

revInsertXMLNode

revIsSpeaking

revLicenseType

revLoadedStacks

revLoadSpeech

revMacFromUnixPath

revMail

revMailUnicode

revMoveFolder

revMoveToFirstRecord

revMoveToLastRecord

revMoveToNextRecord

revMoveToPreviousRecord

revMoveToRecord

revMoveXMLNode

revNumberOfRecords

revOpenDatabase

revOpenDatabases

revPlayAnimation

revPreviewVideo

revPrintField

revPrintReport

revPrintText

revProfile

revPutIntoXMLNode

revQueryDatabase

revQueryIsAtEnd

revQueryIsAtStart

revQueryResult

revRecordVideo

revRollBackDatabase

revRotatePoly

revSetCardProfile

revSetDatabaseDriverPath

revSetSpeechPitch

revSetSpeechProvider

revSetSpeechSpeed

revSetSpeechVoice

revSetSpeechVolume

revSetStackFileProfile

revSetStackProfile

revSetVideoGrabberRect

revSetVideoGrabSettings

revSetXMLAttribute

revShowPrintDialog

revSpeak

revSpeechVoices

revStartXMLData

revStartXMLNode

revStopAnimation

revStopPreviewingVideo

revStopRecordingVideo

revStopSpeech

revUnixFromMacPath

revUnloadSpeech

revUpdateGeometry

revVideoFrameImage

revVideoGrabDialog

revVideoGrabIdle

revVideoGrabSettings

revXMLAddDTD

revXMLAttribute

revXMLAttributes

revXMLAttributeValues

revXMLChildContents

revXMLChildNames

revXMLEndTree

revXMLFirstChild

revXMLMatchingNode

revXMLNextSibling

revXMLNodeContents

revXMLNumberOfChildren

revXMLParent

revXMLPreviousSibling

revXMLRootNode

revXMLRPC_AddParam

revXMLRPC_CreateRequest

revXMLRPC_DeleteAllDocuments

revXMLRPC_DeleteDocument

revXMLRPC_DeleteParam

revXMLRPC_Documents

revXMLRPC_Error

revXMLRPC_Execute

revXMLRPC_GetHost

revXMLRPC_GetMethod

revXMLRPC_GetParam

revXMLRPC_GetParamCount

revXMLRPC_GetParamNode

revXMLRPC_GetParamType

revXMLRPC_GetPath

revXMLRPC_GetPort

revXMLRPC_GetProtocol

revXMLRPC_GetRequest

revXMLRPC_GetResponse

revXMLRPC_GetSocket

revXMLRPC_SetHost

revXMLRPC_SetMethod

revXMLRPC_SetPath

revXMLRPC_SetPort

revXMLRPC_SetProtocol

revXMLRPC_SetSocket

revXMLStartTree

revXMLText

revXMLTree

revXMLTrees

revXMLValidateDTD

revZipAddItemWithData

revZipAddItemWithFile

revZipAddUncompressedItemWithData

revZipAddUncompressedItemWithFile

revZipCancel

revZipCloseArchive

revZipDeleteItem

revZipDescribeItem

revZipEnumerateItems

revZipExtractItemToFile

revZipExtractItemToVariable

revZipOpenArchive

revZipOpenArchives

revZipRenameItem

revZipReplaceItemWithData

revZipReplaceItemWithFile

revZipSetProgressCallback

right

right

rightMargin

rotate

round

roundEnds

roundRadius

roundRect

rowDelimiter

RTFText

save

saveStackRequest

savingStandalone

scale

scaleIndependently

screenColors

screenDepth

screenGamma

screenLoc

screenMouseLoc

screenName

screenNoPixmaps

screenRect

screenSharedMemory

screenType

screenVendor

script

scriptExecutionError

scriptLimits

scriptParsingError

scriptTextFont

scriptTextSize

scrollbar

scrollbar

scrollbarBeginning

scrollbarDrag

scrollbarEnd

scrollbarFactor

scrollbarLineDec

scrollbarLineInc

scrollbarPageDec

scrollbarPageInc

scrollbarWidth

scrollerBeginDecelerate

scrollerBeginDrag

scrollerDidScroll

scrollerEndDecelerate

scrollerEndDrag

scrollerScrollToTop

second

seconds

seconds

secureMode

seek

select

select

selected

selectedButton

selectedChunk

selectedColor

selectedField

selectedImage

selectedLine

selectedLoc

selectedObject

selectedObjectChanged

selectedText

selectGroupedControls

selection

selectionChanged

selectionHandleColor

selectionMode

send

send to program

serialControlString

set

set

setProp

setRegistry

setResource

seven

seventh

sha1Digest

shadow

shadow

shadowColor

shadowOffset

shadowPattern

shadowPixel

sharedBehavior

sharedGroupIds

sharedGroupNames

sharedHilite

sharedText

sheet

shell

shellCommand

shiftKey

short

shortFilePath

show

show cards

show groups

show menubar

show taskbar

showBadge

showBorder

showController

showFocusBorder

showHilite

showIcon

showInvisibles

showLines

showName

showPict

showSelection

showValue

shutdown

shutdownRequest

signal

sin

six

sixth

size

slash

slices

socketClosed

socketError

socketTimeout

socketTimeoutInterval

sort

sort container

sound

soundChannel

soundFinishedOnChannel

space

specialFolderPath

split

spray

spray can

sqrt

srcAnd

srcAndReverse

srcBic

srcCopy

srcOr

srcOrReverse

srcXOr

sslcertificates

stack

stackFiles

stackFileType

stackFileVersion

stacks

stacksInUse

stackSpace

standaloneSaved

standard

standardDeviation

start

start editing

start using

startAngle

startArrow

startFrame

startTime

startup

startUpIconic

startValue

statRound

stderr

stdin

stdout

stop

stop editing

stop moving

stop recording

stop using

strikeout

string

strokeGradient

style

subOver

subPin

substacks

subtract

sum

surround

suspend

suspendStack

switch

syncRate

sysError

system

systemColorSelector

systemFileSelector

systemPrintSelector

systemVersion

systemWindow

tab

tabbed

tabGroupBehavior

tabKey

tabStops

tan

target

target

templateAudioClip

templateButton

templateCard

templateEPS

templateField

templateGraphic

templateGroup

templateImage

templatePlayer

templateScrollbar

templateStack

templateVideoClip

tempName

ten

tenth

text

text

textAlign

textArrows

textFont

textHeight

textHeightSum

textShift

textSize

textStyle

the

then

there is a

there is no

third

this

three

threeD

threeDBox

threeDHilite

throw

thumbPosition

thumbSize

ticks

ticks

tilt

time

timeScale

title

titleWidth

to

toggleHilites

token

toLower

tool

tool

toolTip

toolTipDelay

top

top

topColor

topLeft

topLevel

topMargin

topPattern

topPixel

topRight

topStack

touchEnd

touchMove

touchRelease

touchStart

toUpper

traceDelay

traceReturn

traceStack

trackCount

tracks

transparent

transpose

traversalOn

true

trunc

try

twelveHourTime

two

type

typingRate

u3eject

uInt1

uInt2

uInt4

umask

unboundedHScroll

unboundedVScroll

undefine

underline

underlineLinks

undo

undoChanged

undoKey

ungroup

unhilite

unicodeFormattedText

unicodePlainText

unicodeText

unicodeTitle

unIconifyStack

uniDecode

uniEncode

union

unload

unlock colorMap

unlock cursor

unlock error dialogs

unlock menus

unlock messages

unlock moves

unlock recent

unlock screen

unmark

until

up

URL

URLDecode

URLEncode

urlProgress

urlResponse

URLStatus

userLevel

userModify

useSystemDate

useUnicode

using

value

variableNames

version

vGrid

videoClip

videoClipPlayer

visible

visited

visitedIcon

visual effect

volumes

vScroll

vScrollbar

wait

waitDepth

watch

weekdayNames

while

white

whole

wholeMatches

wideMargins

width

windowBoundingRect

windowID

windowManagerPlace

windowShape

with

within

without

word

wordOffset

words

wrap

write to driver

write to file

write to process

write to socket

XBrowser_Focus

XBrowser_Init

XBrowser_Unfocus

xExtent

xHot

xOffset

xScale

yExtent

yHot

yOffset

yScale

zero

zoom

zoomBox

[]

\

^

Syntax
revOpenDatabase(databaseType,host[:port], databaseName, [userName],[password] [, databaseSpecificOption |valentinaCacheSize,valentinaMacSerial,valentinaWindowsSerial])
SummaryConnects to a MySQL, Oracle, ODBC, PostgreSQL, or Valentina database.
See AlsorevExecuteSQL command, revSetDatabaseDriverPath command, revLicenseType function, revDatabaseID function, revDatabaseConnectResult function, revDatabaseTableNames function, revQueryIsAtStart function
IntroducedAdded.
Supported Platformsdesktop,web,server,mobile
Operating Systemsmac,windows,linux,ios,android
Security RequirementsNo requirements
Examples
get revOpenDatabase("mysql", "www.example.com", "RatesDB", myUsr, myPass)
get revOpenDatabase("odbc", "BizFile", , "jenkins" ,the dbPassword of me, "emulated static")
get revOpenDatabase("valentina", "", "::Project:MyVal.vdb", , , , the serialNumber of this card, "")
get revOpenDatabase("valentina", "", "G:dataexpense.vdb", , , , , field "Valentina serial")
get revOpenDatabase("mysql", "www.example.com", "RatesDB", myUsr, myPass, 0)
get revOpenDatabase("sqlite", "C:/testdbsqlite.db", , , , )
Parameters
    SummaryConnects to a MySQL, Oracle, ODBC, PostgreSQL, or Valentina database.
    Description

    Use the revOpenDatabase function to start working with a database.

    Parameters:

    The databaseType is one of "mysql","oracle" (LiveCode Enterprise only), "odbc", "postgresql", "valentina" or "sqlite".

    The host is the IP address or domain name of the system hosting the database. For Valentina databases, which reside on the local system, the host should be empty. If no host is specified, the local system is used. For SQLite databases, the host should be the full path to the database file.

    The port is the port number you want to connect to, and is used only for MySQL and PostgreSQL databases. If no port is specified, MySQL database connections use port 3306 and PostgreSQL database connections use port 5432.

    The databaseName is the name of the database to connect to. For Valentina databases, this is the path to the file that contains the database. For SQLite databases, the database name should be left empty.

    Important! When connecting to a Valentina database on Mac OS, the databaseName must be a Mac-style file path. (To convert from a LiveCode file path to the Mac style, use the revMacFromUnixPath function.) When connecting to a Valentina database on a Windows system, the databaseName must be a Windows-style file path. On Unix and OS X systems, you use a standard LiveCode file path.

    The userName is your authorized user name for the database. (Some databases do not require a user name.)

    The password is the authentication password for userName. (Some databases do not require a password.)

    The databaseSpecificOption is currently used by MySQL and ODBC databases only, on other databases this parameter has no effect. When connecting to MySQL databases the databaseSpecificOption specifies whether to use SSL for the connection or not, the default is false. When connecting to ODBC databases, the databaseSpecificOption specifies which type of database cursor to use. The possible options are described below under the title "ODBC Cursor Types".

    determines whether a connection to a MySQL database uses SSL for the connection. If useSSL is not specified, the connection uses SSL. If the databaseType is not "MySQL", this parameter has no effect.

    The valentinaCacheSize is the size in bytes of the database cache used for Valentina databases. The minimum cache size is 524288 (512K). If the valentinaCacheSize is not specified, the database cache is 3 megabytes. If the databaseType is not "Valentina", the valentinaCacheSize has no effect.

    The valentinaMacSerial or valentinaWindowsSerial is the serial number that unlocks the Valentina VXCMD. (On Mac OS and OS X systems, specify a valentinaMacSerial and leave the valentinaWindowsSerial parameter empty. On Windows systems, specify a valentinaWindowsSerial and leave the valentinaMacSerial empty.) If no valentinaMacSerial or valentinaWindowsSerial is specified, the database closes automatically after ten minutes.

    Value:

    The revOpenDatabase function returns a database ID which can be used to refer to the database in other Database library commands and functions. The database ID is always an integer.

    Comments:

    To use a DSN to identify an ODBC database, use the DSN as the host, and leave the databaseName parameter empty.

    When using a Valentina database, specify the valentinaCacheSize for greatest efficiency based on the size of your database. The Valentina cache is an area of memory that the Valentina engine sets aside for database operations. The minimum valentinaCacheSize is 512K, or 524288 bytes. For best efficiency, start with the default cache size of 3 megabytes (3145728 bytes), and add about a megabyte for each 100,000-150,000 records in your database.

    When connecting to a Valentina database, the valentinaMacSerial and valentinaWindowsSerial parameters take effect for the entire session. If you specify a different serial number for subsequent connections, it is ignored until the next time you quit and restart the application.

    If the database is not successfully opened, the revOpenDatabase function returns an error message. The error message is never an integer, so you can check whether the connection was successful by checking whether the return value is an integer or not.

    ODBC Cursor Types

    When connecting to an ODBC database, it is possible to specify which type of cursor LiveCode should use. This is done by passing the desired cursor type to the revOpenDatabase function in the databaseSpecificOption paramete. The possible options are explained below.

    "static" - This is a scrollable static cursor. Using this cursor it is possible to navigate backwards as well as forwards through record sets, and to move straight to the first or last record. Static cursors operate on an "offline" copy of the data, meaning that any changes to the data will not be detected by the cursor. Not all ODBC drivers support static cursors, for example FileMaker 6 does not.

    "emulated static" - This cursor has the same behavior as a static cursor, except it allows ODBC to emulate the cursor's behavior if the driver does not support it. ODBC can typically emulate static cursor behavior on Windows systems only.

    "forward only" - This is a cursor that can be scrolled forwards only. All ODBC drivers must support this type of cursor. Forward only cursors are usually faster than scrollable static cursors, but using revMoveToPreviousRecord, revMoveToFirstRecord or revMoveToLastRecord will fail. Forward only is the default cursor type, and is what was used in LiveCode 2.8.1 and earlier.

    If the specified cursor type is not supported by the driver the an error string will be returned.

    Important! This function's capabilities depend on your edition of LiveCode:

    * LiveCode Enterprise: (and applications created with LiveCode Enterprise): Full access to all database types.

    * Other editions: Other editions cannot be used for direct access to Oracle databases.

    Important! The revOpenDatabasefunction is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions section of the General screen of the Standalone Application Settings window, make sure the "Database Support" checkbox is checked and the database drivers you are using are selected in the list of database drivers.

    Changes:

    The ability to specify different cursor types for ODBC connections was added in version 2.9

    The ability to connect to SQLite databases was added in version 2.8.1

    The ability to specify whether SSL is used for MySQL database connections was added in version 2.1. In version 2.0 and later, SSL was used automatically. In versions before 2.0, SSL was not used.

    The revOpenDatabase synonym was added in version 2.0.

    The ability to connect to PostgreSQL databases was added in version 2.0.

    The ability to connect to Valentina databases was added in version 1.1.1.