Dataset updating multiple tables
Target(Employee ID, Employee Name) VALUES(100, 'Mary'); INSERT dbo.Target(Employee ID, Employee Name) VALUES(101, 'Sara'); INSERT dbo.
For example, because different source systems store Date information in various contexts, a data warehouse may have multiple columns in different tables which all represent the concept of 'Date'.
SQLite databases often due not work well over NFS, or some other networked file system protocols due to the poor support for locking. By default, SQL statements are passed directly to the SQLite database engine.
It is safest to operate only on SQLite files on a physical disk of the local system. It's also possible to request the driver to handle SQL commands with OGR SQL engine, by passing "OGRSQL" string to the Execute SQL() method, as name of the SQL dialect.
The ID form of the attribute 'Date' may contain two expressions.
The DATE_ID column occurs in the LU_DATE table as well as in two other tables.The driver can handle "regular" SQLite databases, as well as Spatialite databases (spatial enabled SQLite databases).