How Do I Browse a Database Table? (Magic xpa 4.x)
It is very convenient, when creating an application, to look at live data. This is very easy to do in Magic xpa, thanks to the Generate Program utility (Options->Generate Program, or Ctrl+G).
-
In the Data repository, position the cursor on the table you want to view.
-
Press Ctrl+G (Options->Generate Program).
-
Select:
-
-
Mode=Execute to view the data directly with a temporary, or Mode=Generate to create a new program in the Program repository.
-
Option=Browse
-
Zoom from the Columns field to select only certain columns, if you want, and to change their order, if you want.
-
Press Enter or click OK.
If you selected Mode=Execute, you will be presented with a view of the data in the database table. The default mode is query, so you will have to select Options->Modify Records if you want to change the data.
If you selected Mode=Generate, then there will be a new program in the Program repository. You can run this program by pressing F7. You can also change the program if you want, to make it easier to view the data that is important to you during testing.
Hint: Using the Program Generator is a good way to quickly begin a program. You can generate the program, then alter it to create your final product.
