4D v14
Importing
- Self-training
-
- Fundamentals
- Introduction
- First steps in 4D
- New query editor (new in 4D v14)
- Presentation of the final database
- Forms and buttons
- Display at startup
- Menu bars
- Page 0 and page 1
- Form and navigation pages
- Tables, fields
- Relations
- Entry, deletion
- Importing
- Output forms
- Queries and sorts
- Quick reports - exports
- Query by formula, applying a formula
- Form inheritance
- Printing forms
- Handling form objects
- Object properties
- Calculations and formulas
- Overview of variables
- Tracing and debugging
- Generic programming (without pointers)
- Pointers
- Events
- Arrays, pop-ups, list boxes
- Windows and navigation
- Triggers
- Current selection
- Sets and named selections
- Processes
- XLIFF and translation
- 4DWrite Plugin
- Switching to client/server mode
- SQL
- BLOBs
- Components
- Host database events (new in 4D v14)
- SVG
- Web Server
- Download
Importing
In addition to the manipulations explained in the video, you should also note that:
When importing Boolean values (True-False in 4D), you can request an automatic conversion:
- by going to the last tab of the Import dialog box
- and specifying values such as "yes;no", "internal;external,", "Male;Female", etc.
4D automatically converts the imported data (the first value to True and the second to False).
You can also provide users with access to the import or export dialog box using the following commands:
IMPORT DATA("")EXPORT DATA("")
When you perform an import using a form, the form contains the fields receiving the data. The entry order of the form must be the same as the order of the columns in the import file.
Product: 4D
Theme: Importing
Self-training ( 4D v13)
Self-training ( 4D v14)
