ISAM Database Development
◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
ISAM available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
ISAM Database Development
■ The following keywords are used in Visual Basic to develop ISAM databases:
◄BEGINTRANS► Marks beginning of ISAM transaction
◄BOF► Returns true of current position is beginning of file
◄CHECKPOINT► Writes open ISAM database buffers to disk
◄CLOSE► Close ISAM database files
◄COMMITTRANS► Commits database operations since last BEGINTRANS
◄CREATEINDEX► Creates ISAM table index
◄DELETE► Removes the current record from ISAM table
◄DELETEINDEX► Removes an index from ISAM database
◄DELETETABLE► Removes and ISAM table and indexes
◄GETINDEX$► Returns name of current index of ISAM table
◄INSERT► Adds new record to ISAM table
◄LOF► Returns number of records in ISAM table
◄MOVEFIRST► Makes first record the current record
◄MOVELAST► Makes last record the current record
◄MOVENEXT► Makes next record the current record
◄MOVEPREVIOUS► Makes previous record the current record
◄OPEN (File I/O)► Opens ISAM database file and table
◄RETRIEVE► Gets current record and places it into variable
◄ROLLBACK► Restores state of database
◄SAVEPOINT► Marks save points within a transaction log
◄SEEKEQ► Makes first equal to keyvalue the current record
◄SEEKGE► Makes first greater than or equal to keyvalue current
◄SEEKGT► Makes first greater than keyvalue the current record
◄SETINDEX► Makes specified table index the current index
◄TEXTCOMP► Compares order of two strings as sorted by ISAM index
◄TYPE► Defines ISAM table type (columns in ISAM record)
◄UPDATE► Updates current record in ISAM table
See: ◄ISAM Data Types Summary► ◄ISAM Naming Conventions►
◄ISAM Reserved Words► ◄ISAMCVT Command-Line Options►
◄ISAMIO Command-Line Options► ◄ISAMPACK Command-Line Options►
◄ISAMREPR Command-Line Options► ◄Keywords by Task►
◄PROISAM Command-Line Options► ◄PROISAMD Command-Line Options►