sql Save

sql save stores the current values of the listed variables in the database. It writes all of them or none of them. #SqlChanges is the number saved.

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.

Example

sql open mychar.db
sql load %runs !lastloot         ; what was saved last time
set %runs %runs + 1
display ok Run %runs - last loot: !lastloot
set !lastloot gold
sql save %runs !lastloot         ; save for next time
halt

See also

• sql Load
• sql Delete