2011

■ Standard FDO expressions and filters
■ Parameter binding for all commands (at the API level)
Restrictions of SQLite Schemas
When you create or modify a SQLite schema, the following restrictions apply:
■ SQLite native data supports only the following base property types: int64,
double, string and Geometry.
■ If there is data in the class, you cannot modify the primary key or
constraints.
■ Persistent locking and long transactions are not supported.
■ You cannot change the schema name for a SQLite data store. The schema
name must be “Default.”
■ You cannot add comments in the Schema or Feature Class Description
fields.
To work with SQLite data
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522).
■ Create data stores (page 586).
■ Connect to SQLite data. (page 330)
■ Style SQLite features (page 639).
■ Join SQLite data to a different feature (page 509).
■ Examine or edit attribute data (page 711).
■ View a SQLite schema (page 608)
■ Edit a SQLite schema (page 610)
■ Export drawing data to SQLite (page 1447).
■ Save a Display Manager layer as an SQLite file. (page 1469)
■ Copy data to/from a different data format (page 615)
566 | Chapter 4 Managing Data