MiraDades: View and edit Databases Tables

MiraDades is the databases table viewer and editor for MiraMon. It is a Windows application that is easy to use and very small (about 600 Kbyte). MiraDades allows you to manage very large tables (for example 200000 records) even on small computers.

With MiraDades you can edit database contents, restructure fields or records, sort, join and perform the basic table operations needed in a geographical information system.

From MiraMon version 4, MiraDades opens any database, for example: ACCESS, ORACLE, SQL Server, DB2, EXCEL, DBF and more taking advantage of ODBC technology. Nevertheless, MiraDades keeps direct visualization and edition characteristic in DBF format tables, also present in earlier versions.

MiraDades is a native 32-bit application, specifically designed for Windows 95/98/ME and NT/2000/XP.

MiraDades also accounts for the ANSI/OEM character set of your tables.

Command Line

MiraDades supports certain parameters in the command line. These parameters are useful for starting up MiraDades from a DOS window or console or from other programs. You can use these parameters in any order although some combinations may not make sense. The parameters have to be separated by one or more blanks (spaces, tabs).

The most used parameter is the name of the DBF table or database file. For example, you can run:

MiraD C:\Mapas\Portugal\TrensA.dbf
MiraD \\SERVIDOR\BaseDades\Poblacio\1995.mdb

/EDIT This opens a DBF table in edition mode, as if you had pressed F2 (currently this parameter can only be applied to DBF tables).

/SQL=CREATE... This creates a table with as many fields as defined in the sentence. For example, given an existing database called C:\Hello.mdb, the following sentence creates a new table called TableActivities, with two fields. MiraD "/SQL=CREATE TABLE TableActivities (CodeActivity VARCHAR(50), Year INT)" "C:\Hello.mdb".

/SQL INSERT... This inserts records in a database table. For example, given an existing database called C:\Hello.mdb, with a table called TableActivities, the following sentence inserts the following records, with two fields. MiraD /SQL=INSERT INTO TableActivities (CodeActivity, Year) VALUES ('08-78//12', 2005)".

/XERRAIRE (Chatterbox) This allows the program to give certain messages (normally not necessary) which are destined to be debugged. Additionally, if a MM32 session has been opened with /XERRAIRE, the MiraD sessions opened in that session are also opened with /XERRAIRE.

In the command line parameters /SQL=CREATE, /SQL=INSERT, etc, MiraDades closes automatically once the operations indicated are completed.

In SQL sentences entered at the MiraDades command line, there may be a character '/' in the sentence, "//" should be written so that the interpretation of the operative system command line doesn't interpret that it has found a new parameter separated by '/'. In the case that the character that appears in the sentence is '"', you should write "¨" or character 127 so that the interpretation of the operative system command line doesn't interpret that the quotation marks are the end of the parameter given in the command line.

You can also consult the description of the parameter /DT= of the general syntax.