Tuesday June 17, 2025, 10:12 pm
Email
IT 
EN 

5 - Using the Internal Database

  • Step 1
  • Step 2
  • Step 3
  • Help
  • Open the container manager with the Database Container manager menu command, or with the tool. Select all rows and delete them. Close the dialog.
  • Open the package manager in maintenance mode with the DatabasePackage managersDB Maintenance menu command, or with the tool. Select all rows and delete them. Close the panel.
  • Open the file created in Tutorial 1 with the FileOpen menu command (shortcut key Ctrl+O) or the tool. Although not necessary, delete the solution using the SolutionDelete solution menu command.
  • In production use, set up the metric units as discussed in Tutorial 2 before performing database maintenance operations.

  • Select the Containers tab, and then the Current panel. Press the Save button and save the container.
  • Select the Packages tab, and then the dimension Dim.. grid. Select all rows (shortcut key Ctrl+A). Save the rows with the DatabaseSave items in database menu command or the tool. You can also use the context menu of the grid [Add rows to database menu command].
  • Open Database managers as seen in step 1 to verify the correctness of the procedures.
  • Create a new solution with the FileNew menu command (shortcut key Ctrl+N) or with the tool.
  • Open the container manager as shown in step 1. Select the saved container and load it with the Load tool. Close the dialog.
  • Open the package manager in retrieval mode with the DatabasePackage managersData retrieval menu command (shortcut key Ctrl+M), or the tool.
  • Select all rows and load them with the Load tool.

For curiosity, edit a code cell by entering a registered code. When the cell is closed, all data is automatically loaded. The auto-completion function can be used to simplify importing from Excel files.

The database can be populated with bulk import, using spreadsheet or ODBC table.

  • Create an Excel file to import as described in the Tutorial 4. Populate the database with the DatabaseImport / Update databaseData from Excel menu command.

The load list can be imported by using auto-completion.

  • Create an Excel file with two columns only. In the first enter the code of a record registered in database, in the second the quantity.
  • Create a new solution with the FileNew menu command (shortcut key Ctrl+N) or with the tool.
  • Import the file created with the FileImport (Excel)Import code/qty menu command (shortcut key Ctrl+Shift+Q).
Sitemap

© 2006-2025
Dr. Antimo Angelucci, PhD
Via Giulia n. 1
I-30026 Portogruaro (VE) - Italy
P.IVA IT03756330274

Privacy | Contact us
close  ❌ 

email

web form