Skip to content

sql Delete

Sub-commandData (SQL)New in Reforged
sql delete {%var|!var} [...]
Sets
#SqlRes, #SqlChanges

Also searchable as: sql Delete

sql delete removes the listed variables from the euo_vars table. The variables themselves keep their values. #SqlChanges is the number removed.

sql save, sql load and sql delete keep variables in a table called euo_vars, created when first needed. It works like the * variables, but in a file of your choice instead of the registry.

  • Write the variables as you normally would (%runs, not its value). Only % and ! variables can be used.
  • Names do not depend on case. A ! variable is saved under its plain name: !x saved in one namespace loads into !x of whatever namespace is current.
  • euo_vars is an ordinary table: sql query SELECT name, value FROM euo_vars lists it.
sql open mychar.db
set %lastloot gold
sql save %lastloot
sql delete %lastloot
display ok Removed #SqlChanges saved variable
halt

See also