Use the QbSetAutoCatalog API or the SET QBIC AUTOCATALOG command
to change from automatic cataloging to manual cataloging or from manual to automatic. The QBIC catalog must be open for update before you change the catalog setting.
The change is not retroactive: When you change the autocatalog setting, it applies only to images that are added to the user table column after the change. Images that are already stored in the user table column are not affected. For example, if you change the setting from manual cataloging to automatic cataloging, only images added to the user table column after the change will be automatically cataloged. If you want to catalog images already in the table column, you need to manually catalog them. (See Manually cataloging an image for information on how to manually catalog an image.)
Using the API: When you use the QbSetAutoCatalog API, specify the handle of the QBIC catalog (the handle is returned when you open the catalog with the QbOpenCatalog API). Also specify an auto catalog value of 1 for automatic cataloging, or a value of 0 for manual cataloging.
In the following example, manual cataloging is specified for a QBIC catalog associated with the images in the picture column of the employee table. Notice that the QBIC catalog is first opened for operations that update it.
SQLINTEGER mode; SQLINTEGER autoCatalog=0; /* manual cataloging */ QbCatalogHandle *CatHdl; mode=qbiUpdate; /* open catalog for */ /* update */ /* Open a QBIC catalog */ rc=QbOpenCatalog( "employee", /* user table */ "picture", /* image column */ mode, /* open catalog mode */ &CatHdl); /* catalog handle */ /* Change the auto catalog setting */ rc=QbSetAutoCatalog( CatHdl, /* catalog handle */ autoCatalog); /* auto catalog flag */
Using the command line: When you issue the SET QBIC AUTOCATALOG command, you indicate automatic cataloging by specifying ON. You indicate manual cataloging by specifying OFF. The command acts on the currently open catalog.
For example, the following command sets automatic cataloging off for the currently open QBIC catalog:
SET QBIC AUTOCATALOG off