Zugg Software :: #SQLCLOSE

Register to post in forums, or Log in to your existing account

Home » Knowledge Base » CMUD » CMUD Manual Source

Contents

Command Reference
	#nnn
	#ABORT
	#ACTION
	#ADD
	#ADDITEM
	#ADDKEY
	#AFK
	#ALARM
	#ALIAS
	#ALL
	#BACKUP
	#BEEP
	#BREAK
	#BUTTON
	#C-
	#C+
	#CALL
	#CAPTURE
	#CASE
	#CHARACTER
	#CLASS
	#CLOSE
	#CLR
	#CMD
	#COLOR
	#COM
	#CONDITION
	#CONFIGURE
	#CONNECT
	#CONTINUE
	#CR
	#CW
	#DBCLOSE
	#DBDELETE
	#DBFIRST
	#DBGET
	#DBLOAD
	#DBNEXT
	#DBOFFLINE
	#DBONLINE
	#DBPREV
	#DBPUT
	#DBRESET
	#DBSAVE
	#DDE
	#DEBUG
	#DEBUGFILE
	#DEFAULT
	#DELCLASS
	#DELITEM
	#DELKEY
	#DELNITEM
	#DESCRIBE
	#DIRECTION
	#DISCONNECT
	#DOOR
	#ECHO
	#ECHOPROMPT
	#EDITOR
	#ERASE
	#EVALUATE
	#EVENT
	#EXECUTE
	#EXECWIN
	#EXIT
	#FILE
	#FIND
	#FIRE
	#FORALL
	#FREEZE
	#FTP
	#FUNCTION
	#GAG
	#GAGBLOCK
	#GAGLOG
	#GAGOFF
	#GAGON
	#GAGSPACE
	#GAUGE
	#H-
	#H+
	#HELP
	#HIGHLIGHT
	#HISTLOAD
	#HISTORY
	#HISTSAVE
	#HOST
	#IF
	#IGNORE
	#IMAGE
	#INPUT
	#KEY
	#KILLALL
	#LAUNCH
	#LMAP
	#LOAD
	#LOCAL
	#LOCATION
	#LOG
	#LOOK
	#LOOP
	#LOOPDB
	#LOOPVIEW
	#LUA
	#MAKEROOM
	#MAKEWINDOW
	#MAP
	#MAPQUERY
	#MARK
	#MATH
	#MEDIA
	#MENU
	#MERGE
	#MESSAGE
	#MODULE
	#MOVE
	#MSS
	#MXP
	#MXPTRIG
	#NAME
	#NEW
	#NEWVAR
	#NODEF
	#NODIR
	#NOINPUT
	#NOMAP
	#NOOP
	#NOSAVE
	#OK
	#ONINPUT
	#PATH
	#PATHHIGH
	#PAUSE
	#PCOL
	#PICK
	#PLAY
	#PLUGIN
	#PORTAL
	#PRINT
	#PROMPT
	#PSUB
	#PUEBLO
	#PW
	#QUERY
	#QUEUE
	#RAISEEVENT
	#READ
	#RECALL
	#RECORD
	#REGEX
	#RENAME
	#REPEAT
	#RESET
	#RESUME
	#RESULT
	#RETRACE
	#RETURN
	#SAVE
	#SAY
	#SAYADD
	#SAYPROMPT
	#SCRIPT
	#SCROLL
	#SECTION
	#SEND
	#SENDGMCP
	#SENDPROMPT
	#SENDRAW
	#SENDSB
	#SESSION
	#SET
	#SETPROMPT
	#SHOW
	#SHOWARR
	#SHOWDB
	#SHOWPROMPT
	#SHOWTABLE
	#SIGNAL
	#SLOW
	#SORT
	#SQLCLOSE
	#SQLDB
	#SS
	#STATE
	#STATUS
	#STEP
	#STOP
	#STWIN
	#STYLE
	#SUBSTITUTE
	#SUSPEND
	#SWITCH
	#T-
	#T?
	#T+
	#TAB
	#TAG
	#TELEPORT
	#TEMP
	#TEMPVAR
	#THREAD
	#TIMER
	#TRACK
	#TRIGGER
	#TSET
	#TYPE
	#TZERO
	#UNALIAS
	#UNBUTTON
	#UNCLASS
	#UNDIR
	#UNGAG
	#UNKEY
	#UNEVENT
	#UNLOAD
	#UNLOC
	#UNMENU
	#UNPATH
	#UNPORTAL
	#UNSTYLE
	#UNTAB
	#UNTIL
	#UNTRIGGER
	#UNVAR
	#UPDATE
	#URL
	#VARFUNC
	#VARIABLE
	#VERBATIM
	#VERSION
	#VIEW
	#WAIT
	#WAITFOR
	#WAITSIGNAL
	#WAITTHREAD
	#WALK
	#WHILE
	#WINDOW
	#WITHLOC
	#WIZLIST
	#WRAP
	#WRITE
	#WRITELOG
	#YESNO

#SQLCLOSE	[[cmud_#SQLCLOSE]]
Added in v3.11

SQLCLOSE

Syntax: #SQLCLOSE name
Related: #SQLDB

Closes a previously opened SQL database.

SQLCLOSE examples

#SQLDB sessions.db
row = %sql(sessions, "SELECT * FROM chardb")
#WHILE (!@row.Eof()) {#SHOW @row.Item("Title");#CALL @row.Next}
#SQLCLOSE sessions
Loops through the local "sessions.db" SQLite database and displays the Title of each session.

Viewer Comments [0 - Post your comments]