Searching data

You can search country, branch or institution data for a match on a maximum of three strings. Typically, if you include more strings in the search, fewer matches will be found.

Searching is case insensitive, for example Paris matches both paris and Paris.

For example, to search the French data for details containing Paris and Vichy:

BWICreateHandle(h)

BWISetValue(h,BWI_V_COUNTRY_CHECK,BWI_C_FRANCE)

/* Set the search strings */

BWISetString(h,BWI_V_PAR1,"paris")

BWISetString(h,BWI_V_PAR2,"vichy")

BWISearch(h,1,num)

print(num + "matches found")

for(i = 1; i <= num; i = i + 1 ) {

/* Iterate to the first or next match */

BWINext(h,BWI_N_SEARCH)

/* Retrieve the required fields and specify the format used for display */

BWIGetString(h,BWI_FR_INSTITUTION_CODE,inst)

BWIGetString(h,BWI_FR_OFFICE_CODE,office)

BWIGetString(h,BWI_FR_ADDRESS_2,street)

print(inst + " " + office + " " + street)

}

BWIFree(h)

This example finds three matches and, for each match, displays the institution code, the office code and the 2nd part of the address:

10096 18051 25 R DE PARIS

10096 18551 25 R DE PARIS

30001 00875 7 R DE PARIS

The exact number of matches found and text displayed for this search depends upon which Database Table Files you are using.