大网数据广告活动
磁盘与文件系统

JET_CONDITIONALCOLUMN Structure

· 52CE 我爱测

Learn more about: JET_CONDITIONALCOLUMN Structure

Applies to: Windows | Windows Server

JET_CONDITIONALCOLUMN Structure

The JET_CONDITIONALCOLUMN structure defines how conditional indexing is performed for a given index. A conditional index contains an index entry for only those rows that match the specified condition. However, the conditional column is not part of the index's key, it only controls the presence of the index entry.

    typedef struct tagJET_CONDITIONALCOLUMN {
      unsigned long cbStruct;
      tchar* szColumnName;
      JET_GRBIT grbit;
    } JET_CONDITIONALCOLUMN;

Members

cbStruct

This field must be initialized to sizeof( JET_CONDITIONALCOLUMN ), in bytes.

szColumnName

The name of the column that contains the data on which the database engine is conditionally indexing the row.

grbit A group of bits that gives the options for the conditional index. Passing in zero or logically-ORed values is not valid for JET_CONDITIONALCOLUMN. The bit field must be exactly one of the following:

Value Meaning
JET_bitIndexColumnMustBeNull The column specified by the szColumnName parameter must be NULL for an index entry for a given row to appear in this index.
JET_bitIndexColumnMustBeNonNull The column specified by the szColumnName parameter must be non-NULL for an index entry in order for a given row to appear in this index.

Remarks

A conditional index contains an index entry for only those rows that match the specified condition. For example, a column could be named "Marked", and when a row is marked, the column is set to a non-NULL value. A JET_bitIndexColumnMustBeNonNull conditional index on this column will show all rows that are marked, and a JET_bitIndexColumnMustBeNull conditional index will show rows that are not marked. This is also a convenient way to perform a flag deletion and garbage collecting index.

Requirements

Requirement Value
Client Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Server Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Header Declared in Esent.h.
Unicode Implemented as JET_CONDITIONALCOLUMN_W (Unicode) and JET_CONDITIONALCOLUMN_A (ANSI).

See Also

JET_GRBIT
JET_INDEXCREATE

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。