You can use INSERT, UPDATE, and DELETE commands within a SQL statement to update data in an external table. In these instances, no data is copied into the POD file.
Example 1: Delete database records
Example 2: Insert new records into a table
Example 3: Update existing records in a table
-
We recommend that you avoid using an Excel spreadsheet as the database because it does not support all SQL statements.
-
Example 2 and Example 3 use the conventions listed below:
-
TABLE is the name of an existing database table.
-
Field1, Field2, and Field3 are the names of the columns in the database that you want to populate.
-
POD_property1, POD_property2 are the values in the POD file that you want to store in the external database.
-
-
In Example 3, the WHERE clause must identify a single row in the table to be updated.
-
Because DELETE, INSERT, and UPDATE commands do not return any data produce an error message in the GED log file. None of these commands return any data, which GED expects. Consequently, you can ignore this error.