OpenTokens™: %DB(OPEN)%

%DB(OPEN)% tokens will open a database file, using the specified parameters. They use following token format:

%DB(OPEN|dbalias|filename|indexes|type|username|password)%

Parameters

·

OPEN      required   literal   action code

·

dbalias      required   literal   MivaScript database alias name

·

filename   required   literal   filename of the database

·

indexes      optional   literal   filename(s) of the index files

·

type      optional   literal   database type (defaults to 'xbase3')

·

username   optional   literal   used for OpenDB databases (using the OpenDB by CopernicusLLC.com)

·

password   optional   literal   database type (defaults to 'xbase3')

Example: To open an xbase3 database called "NewData" using the filename of "newdata.dbf", use

%DB(OPEN|NewData|newdata.dbf|newdata.mvx)%

or

%DB(OPEN|NewData|newdata.dbf|newdata.mvx|xbase3)%

Example: To open a MytSQL database (using the OpenDB by CopernicusLLC.com) called "NewSqlData" using the filename of "newsqldata.dbf", use

%DB(OPEN|NewSqlData|newsqldata.dbf|newdata.mvx|opendb_mysql)%

For more information, see <MvOPEN> in the Miva Script Guide v4.x -- <MvOPEN>.

 

---

Send feedback on this documentation.
© 2004 - 2000 Darren Ehlers & OpenUI Developer Consortium