Table of contents
Example_Autotext_Searchmark_Spelling

• Tables
  • filter
  • table
• Queries
  • Query_Form_Like
  • Query_Form_Locate
  • Query_Locate_0
  • Query_Locate_1
  • Query_Locate_2
  • Query_Locate_5
• Forms
  • Autotext
  • Search_mark
  • Spelling_afterwards
  • Spelling_directly
• Modules
  • Module1
• Index

List of fields by query

Query name	Field name	Field type	Source table	Source field
Query_Form_Like	ID	INTEGER	table (Table)	ID
	memo	LONGVARCHAR	table (Table)	memo
Query_Form_Locate	ID	INTEGER	table (Table)	ID
	memo	LONGVARCHAR	table (Table)	memo
Query_Locate_0	ID	INTEGER	table (Table)	ID
	memo	LONGVARCHAR	table (Table)	memo
	position			LOCATE( LOWER ( :Searchtext ), LOWER ( "memo" ) )
Query_Locate_1	hit	LONGVARCHAR		hit
	ID	INTEGER	SYSTEM_SUBQUERY	ID
	memo	LONGVARCHAR	SYSTEM_SUBQUERY	memo
	position	INTEGER	SYSTEM_SUBQUERY	position
Query_Locate_2	hit01	LONGVARCHAR	SYSTEM_SUBQUERY	hit01
	hit02	LONGVARCHAR		hit02
	ID	INTEGER	SYSTEM_SUBQUERY	ID
	memo	LONGVARCHAR	SYSTEM_SUBQUERY	memo
	position01	INTEGER	SYSTEM_SUBQUERY	position01
	position02	INTEGER	SYSTEM_SUBQUERY	position02
	position03	INTEGER		position03
Query_Locate_5	hit01	LONGVARCHAR	SYSTEM_SUBQUERY	hit01
	hit02	LONGVARCHAR	SYSTEM_SUBQUERY	hit02
	hit03	LONGVARCHAR	SYSTEM_SUBQUERY	hit03
	hit04	LONGVARCHAR	SYSTEM_SUBQUERY	hit04
	hit05	LONGVARCHAR		hit05
	ID	INTEGER	SYSTEM_SUBQUERY	ID
	memo	LONGVARCHAR	SYSTEM_SUBQUERY	memo
	position01	INTEGER	SYSTEM_SUBQUERY	position01
	position02	INTEGER	SYSTEM_SUBQUERY	position02
	position03	INTEGER	SYSTEM_SUBQUERY	position03
	position04	INTEGER	SYSTEM_SUBQUERY	position04
	position05	INTEGER	SYSTEM_SUBQUERY	position05
	position06	INTEGER		position06