SQL - Create Table

GSAK (Geocaching Swiss Army Knife)

SQL - Create Table

Warning: The SQL command was the first introduction of SQL to the macro language. It has many limitations and quirks and is now deprecated. It is provided for here for backwards compatibility only. It is very much recommended that you use the more complete and robust SQLite database engine. See the SQLite() function.

Creates a new disk table in the current macro (folder).

Syntax:

CREATE TABLE tablename (field1,[fieldN])

Example:

$Status = sql("CREATE TABLE userdata (code,comment1,comment2)","")
$Status = sql("Commit","")

Note: The CREATE command will generate the table "skeleton" (field headings) to disk, but no data are actually saved to this disk file until you issue the COMMIT command. .