OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, OpenNext_DB_EnableFilter, OpenNext_DB_GetRecordCount, OpenNext_DB_OpenRecord, OpenNext_DB_OrderBy, OpenNext_DB_SelectTable, OpenNext_DB_SetNextRecord, OpenNext_FromDatabase

OpenNext_DB_DefineFilter

Description 

 OpenNext_DB_DefineFilter(
   char *On_FieldName1,
   int  On_FieldType1,
   char *On_FilterValues1,
   int  On_FilterType1
);

This function enables you to change filtering conditions for list of images which are scanned by open next functions.

Parameters

char *On_FieldName1

Name or unique name of the field for the first condition.

int On_FieldType1

Type of the field for the first condition.

1	Number
2	Decimal Number
3	Text
4	Multiline Text
5	Boolean
6	Enumeration
7	Date and Time
8	Not used.
9	Not used.
10	Not used.
11	External link

char *On_FilterValues1

Single or comma separated condition values for the first condition.

int On_FilterType1

Type of the filter for the first condition. For field types Text, Multiline Text and External Link the parameter can contain following values:

0	Match from start.
1	Match exact.
2	Match anywhere.
3	Match any word.
4	Match all words.
0	FilterValue is comma separated values of range borders.
1	FilterValue is single value and condition is equal.
0	FilterValue is comma separated values of range borders.
1	FilterValue is single date and condition is equal.
2	FilterValue is single date and number of days before the date, which define range.
3	FilterValue is single date and number of weeks before the date, which define range.
4	FilterValue is single date and number of months before the date, which define range.

See Also 
OpenNext_DB_DefineFilterEx, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter, OpenNext_DB_OrderBy

OpenNext_DB_DefineFilterEx

Description 

 OpenNext_DB_DefineFilterEx(
   char *On_FieldName1,
   int  On_FieldType1,
   char *On_FilterValues1,
   int  On_FilterType1,
   char *On_FieldName2,
   int  On_FieldType2,
   char *On_FilterValues2,
   int  On_FilterType2,
   int  Operation
);

This function enables you to change filtering conditions for list of images which are scanned by open next functions.

Parameters

char *On_FieldName1

Name or unique name of the field for the first condition.

int On_FieldType1

Type of the field for the first condition.

1	Number
2	Decimal Number
3	Text
4	Multiline Text
5	Boolean
6	Enumeration
7	Date and Time
8	Not used.
9	Not used.
10	Not used.
11	External link

char *On_FilterValues1

Single or comma separated condition values for the first condition.

int On_FilterType1

Type of the filter for the first condition. For field types Text, Multiline Text and External Link the parameter can contain following values:

0	Match from start.
1	Match exact.
2	Match anywhere.
3	Match any word.
4	Match all words.
0	FilterValue is comma separated values of range borders.
1	FilterValue is single value and condition is equal.
0	FilterValue is comma separated values of range borders.
1	FilterValue is single date and condition is equal.
2	FilterValue is single date and number of days before the date, which define range.
3	FilterValue is single date and number of weeks before the date, which define range.
4	FilterValue is single date and number of months before the date, which define range.

char *On_FieldName2

Name or unique name of the field for the second condition.

int On_FieldType2

Type of the field for the second condition. Same meaning as FieldType1.

char *On_FilterValues2

Single or comma separated condition values for the second condition.

int On_FilterType2

Type of the filter for the second condition. Same meaning as FilterType1.

int Operation

Boolean operation between these two simple conditions.

0	Logical OR.
1	Logical AND.

See Also 
OpenNext_DB_DefineFilter, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter, OpenNext_DB_OrderBy

OpenNext_DB_EnableFilter

Description 

 OpenNext_DB_EnableFilter(
   int  EnableFilter
);

This function enables or disables the filter previously defined for the OpenNext image list.

Parameters

int EnableFilter

Specifies whether to enable or disable the current filter of the active datasource.

0	Disable the filter.
1	Enable the filter.

See Also 
OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx

OpenNext_DB_GetRecordCount

Description 

int OpenNext_DB_GetRecordCount();

This function returns the number of items in the OpenNext image list.

Return Values

int

The number of items in the OpenNext image list.

See Also 
OpenNext_DB_OpenRecord, OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter

OpenNext_DB_OpenRecord

Description 

 OpenNext_DB_OpenRecord(
   int  OpenNext_Num
);

This function opens the specified record from the list of OpenNext images.

Parameters

int OpenNext_Num

Index of the record in the OpenNext images list to open. Indices start from 1.

See Also 
OpenNext_DB_GetRecordCount, OpenNext_DB_SetNextRecord, OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, OpenNext_DB_OrderBy, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter

OpenNext_DB_OrderBy

Description 

 OpenNext_DB_OrderBy(
   char *FieldName,
   bool  Ascending
);

This function specifies the sorting of OpenNext images/records.

Parameters

char *FieldName

Name or unique name of the field.

bool Ascending

Works only when ColumnIndex < 0 and any column is sorted

0	Descending
1	Ascending

See Also 
OpenNext_DB_GetRecordCount, OpenNext_DB_OpenRecord, OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter

OpenNext_DB_SelectTable

Description 

 OpenNext_DB_SelectTable(
   char *Database,
   char *Table,
   char *User
);

This function defines the table as the source for the OpenNext functions.

Parameters

char *Database

The name of already opened database.

char *Table

The name or unique name of the table with in the specified database.

char *User

The user (account) name for the database. It can be NULL (0) and then the user name will be retrieved from the list of opened sessions according to the database name.

Note

Cause more than one user can be connected to the same database at the time, the user name is also used to distinguish among the databases. Not only the database name.

See Also 
OpenNext_DB_SetNextRecord, OpenNext_DB_OpenRecord, OpenNext_DB_GetRecordCount, OpenNext_FromDatabase

OpenNext_DB_SetNextRecord

Description 

 OpenNext_DB_SetNextRecord(
   int  OpenNext_Num
);

This function sets the next record to be opened by the OpenNext functions.

Parameters

int OpenNext_Num

Index of the record in the OpenNext images list to be set as next record to open. Indices start from 1.

See Also 
OpenNext_DB_GetRecordCount, OpenNext_DB_OpenRecord, OpenNext_DB_SelectTable, OpenNext_FromDatabase, OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, OpenNext_DB_OrderBy, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter

OpenNext_FromDatabase

Description 

 OpenNext_FromDatabase(
   bool  ON_FromDatabase
);

This function checks or unchecks the specified database and table as source for the OpenNext functions.

Parameters

bool ON_FromDatabase

Flag which specifies if the database table should be used as the source for OpenNext.

0, FALSE	Use files as image source.
1, TRUE	Use database table as image source.

See Also 
OpenNext_DB_SelectTable, OpenNext_DB_GetRecordCount, OpenNext_DB_SetNextRecord, OpenNext_DB_DefineFilter, OpenNext_DB_DefineFilterEx, OpenNext_DB_OrderBy, _DB_ShowFilter, DB_EnableFilter, DB_DisableFilter