⌧createdatabase
⌧createdatabase
DATABASE

The ⌧createdatabase statement creates a new database.

Parameters

This statement has one parameter:

database – is is the name of the new database. There must not already be an open database with this name.

Description

This statement creates a new database. The new database has one field (named Untitled) and one empty record. The new database has no open windows, but it is the active database with a secret window.

This example creates a new database named Contacts, then opens the data sheet

    createdatabase "Contacts"
    opensheet

This example above doesn’t create any database fields. Here’s a more functional example that creates a mailing list database with 5 fields.

    createdatabase "Mailing List"
    setfieldproperties initializedictionary("NAME","Name")
    addfield "Address"
    addfield "City"
    addfield "State"
    addfield "Zip"
    opensheet

See Also

- Importing a Panorama 6 Database
- addfield
- addlines
- addrecord
- arraybuild
- arraybuild(
- arrayselectedbuild
- arrayselectedbuild(
- autoallfieldwidths
- autofieldwidth
- cell
- clearcell
- closefile
- copycell
- copyrecord
- cutcell
- cutrecord
- databaseexportcsv
- databaseexportjson
- databaseexporttsv
- datatype(
- datavalue(
- dbcheckopen(
- dbinfo(
- deletefield
- deleterecord
- downrecord
- editcell
- editcellstop
- emptydatabase(
- emptyline(
- excludefromrecentmenu
- export
- exportjson
- fieldname
- fieldtype
- firstrecord
- formulacalc
- formulavalue
- formulavalue(
- getautonumber(
- getfieldproperties(
- grabdata(
- importdatabase
- Importing Binary Data from Panorama 6
- importjson
- importjsonline
- importline
- importtext
- info("databasefilename")
- inserbelowcarriagereturn
- insertbelow
- insertbelowcarriagereturn
- insertfield
- insertrecord
- lastlookupdatabase(
- lastrecord
- left
- listchoices(
- lookup(
- lookupall(
- lookupalldouble(
- lookupalloctet(
- lookupallquadruple(
- lookupallquintuplet(
- lookupallseptuplet(
- lookupallsextet(
- lookupalltriple(
- lookuplast(
- lookuplastselected(
- lookupmoredata(
- lookupselected(
- movefieldbefore
- newdatabase
- newdatabasewithfields
- newdatabasewithjson
- opendatabase
- openfile
- openplain
- opensecret
- opentextfile
- pastecell
- pasterecord
- right
- runfieldcalculations
- runfieldsideeffects
- saveblueprint
- setdatabaseoptions
- setfieldproperties
- sizeof(
- superarraybuild
- superlookup(
- table(
- unlockrecord
- uprecord

History

Version | Status | Notes
1.0 | New | New in this version.