About Us
About Us
Latest News
Latest News
Privacy
Privacy
Press
Press
About Zugg Software
About Zugg Software
Zugg Software Home
Zugg Software Home
Products
Products
zMUD
zMUD
CMUD
CMUD
Purchase
Purchase
Zugg Software Store
Zugg Software Store
Downloads
Downloads
zMUD
zMUD
CMUD
CMUD
Support
Support
Documentation
Documentation
zMUD Support
zMUD Support
CMUD Support
CMUD Support
Create help request
Create help request
Lost registration code
Lost registration code
Forums
Forums
zMUD »
zMUD »
General Discussion
General Discussion
Developers Forum
Developers Forum
Finished Scripts
Finished Scripts
CMUD »
CMUD »
General Discussion
General Discussion
BETA Forum
BETA Forum
Zugg's Blog
Zugg's Blog
Contact Us
Contact Us
Site
Site
Register
Register
Search
Search
Search Forums
Search Forums
Search Knowledge Base
Search Knowledge Base
Member list
Member list
Groups
Groups
Register
to post in forums
, or
Log in
to your existing account
Site
Web
Enter your search terms
Home
»
Knowledge Base
»
CMUD
»
CMUD Manual Source
[Printable version]
Related
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]
Jump to:
Select a forum
General Forums
----------------
Announcements
CMUD and TeSSH Support
----------------
CMUD General Discussion
CMUD Beta Forum
TeSSH Discussion
MXP Developers
zMUD Support
----------------
zMUD General Discussion
Finished MUD Scripts
Other Forums
----------------
Website or Forum problems
Knowledge Base
Weblogs
----------------
Zugg's Blog
Older, unsupported Products
----------------
General zApp Discussion
SlightlyMorbid
zApp Developers
zMapper Discussion
zExplorer Discussion
© 2009 Zugg Software. Hosted by
Wolfpaw.net