Partial indexing of memos

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Access via ODBC or OLE DB

Big Data

HFSQL functions

Handling a CEDB database

Management of 3-tier

Management of HFSQL Client/Server

Management of HFSQL Cluster

Management of log process

Management of replication

Management of statistics

Management of transactions

Management of triggers

Management of xBase files

SQL functions

Partial indexing of memos

Overview

How to partially index the text memos?

See also

Accessing HFSQL files via SAMBA on Linux

Accessing the databases: summary

Analysis shared between earlier WINDEV applications and WINDEV 24 applications

Assisted management of HFSQL errors

Automatic modification of data files

Automatic modification of data files: new date format

Browsing the HFSQL data files

Communication by GPRS

Connecting to a database via RPC

Errors while managing data files

Filtering a data file, a view or a query

Functions for HFSQL management

HFSQL data files exceeding 2 gigabytes

HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003

HFSQL management functions (prefixed syntax)

HFSQL thumbnails

HFSQL: Change of name

Hyper File functions available for backward compatibility

Locking data files: correspondence between WINDEV 5.5 and the later versions

Management errors specific to Native Accesses

Managing NULL in HFSQL

Managing aliases on the data files

Managing connections

Managing space characters in the searches?

Managing the Unicode format in the HFSQL files

Managing the automatic identifiers when adding a record

Modifying the query content

Native Access access

Native XML Access

Optimizing the remote access

Partial indexing of memos

Remote access (RPC on HFSQL)

SQL functions: Special case

Search and full-text index

Synchronizing data (Windows CE)

The .REP file

The HFSQL views

The composite keys

The different types of browse available in SQL

Unalterable data files

WDModFic : Tool for automatic modification of data files

Overview
How to partially index the text memos?
Implementing the indexing of text memos in the data model editor
Implement the indexing of text memos by programming

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Partial indexing of memos

Not available with these kinds of connection

Overview

You have the ability to index the content of a text memo item. The size of the text memos being quite important, the mechanism of partial indexing is used for the memos.

The partial indexing of the text memos is used to define the number of characters that will be indexed in the text memo. This mechanism is used to optimize the size of the indexes and the search speed.

For example, if the content of an invoice (found in a text memo) is indexed, you will not necessarily have to index for each invoice the three pages of general sales conditions that follow the useful data.

Versions 15 and later

This feature is available for the Native Accesses.

New in version 15

This feature is available for the Native Accesses.

Versions 17 and later

This feature is now available for iPhone/iPad applications.

New in version 17

This feature is now available for iPhone/iPad applications.

How to partially index the text memos?

The indexing of text memos can be performed:

in the data model editor (for the data files described in the analysis)
in WLanguage for the data files created by programming.

Implementing the indexing of text memos in the data model editor

To implement the indexing of text memos:

In the data model editor, display the description of the items found in a data file containing a text memo.
Select the item associated with a text memo.
In the right section of screen, you have the ability to specify whether the memo must be a key or not:
Specify:
- the type of partial key: not key, unique key or key with duplicates.
- the browse direction: ascending or descending.
- the size of the indexed part of the memo. This size must be specified in number of characters.
- whether the search must be sensitive to the case, to the accented characters and to the space characters.
Validate.
Generate the analysis. If data files have been already used, an automatic modification of the data files is performed.

Implement the indexing of text memos by programming

To implement the indexing of text memos when describing a data file by programming, all you have to do is use the available WLanguage properties on the items to specify the characteristics of text memo key.

Property name	Effect

Name	Item name
AccentuationSensitive	Take the accented characters into account when performing searches on the item.
CaseSensitive	Take the case (uppercase/lowercase characters) into account when performing searches on the item.
PunctuationSensitive	Take the punctuation characters (comma, period, ...) into account when performing searches on the item.
Size	Size of a text item (character string, text memo, character).
KeySize	Size of the section to index in the text memo.
Type	Identifies and modifies the type of an item.
KeyType	Characteristics of a key item.
SortType	Characteristics of the sort on an item.

Example:

MyMemoIndex is Item Description
MyMemoIndex..Name = "Comments"
MyMemoIndex..Type = hItemTextMemo
MyMemoIndex..KeyType = hUniqueKey
MyMemoIndex..SortType = hIncreasing
MyMemoIndex..AccentuationSensitive = False
MyMemoIndex..CaseSensitive = False
MyMemoIndex..PunctuationSensitive = False
MyMemoIndex..KeySize = 50
HDescribeItem(Book, MyMemoIndex)