MBEESQL - Variable Map & SQL Equivalents
=========================================

VARIABLE MAP
------------
A0$        Command input from user
A1$        Name (working var)
A2$        Disk number (working var)
A5$        Search term for WHERE
A6$        Field choice for WHERE
R(1..Q)    ID buffer (numeric)
N0(1..Q)   Name buffer
N1(1..Q)   Disk number buffer
N2(1..Q)   Flag buffer (1=Active, 0=Deleted)
B          Total records in buffer
C          Match/display counter
D          Deleted/updated counter
E          Loop index
X          Next available auto-increment ID
Q          Array size limit (1200)


SQL EQUIVALENTS
---------------
I  (Insert)
   INSERT INTO catalogue (name, disk) VALUES (?, ?)

S  (Select all)
   SELECT * FROM catalogue WHERE flag=1

SW (Select where)
   SELECT * FROM catalogue WHERE field LIKE '%term%'

U  (Update)
   UPDATE catalogue SET ... WHERE id=?

D  (Delete)
   UPDATE catalogue SET flag=0 WHERE id=?  [soft delete]

V  (Vacuum)
   DELETE FROM catalogue WHERE flag=0  [rewrite file]

C  (Count)
   SELECT COUNT(*) FROM catalogue WHERE flag=1


FILE FORMAT
-----------
File:   DBMWB.DAT (sequential)
Record: id,name,disk,flag  (one per line)
Flag:   1=Active  0=Deleted