Spread 8.0 Documentation
DLL
Support Options

Glossary Item Box

DLL


To search for data

  1. To search for data in a particular column, call the SSSearchCol function and set the parameters as follows,
    1. Set the lCol parameter to specify the column to search.
    2. Set the lRowStart and lRowEnd parameter to specify the rows at which to start and end searching.
      To start at the beginning of the rows, set the lRowStart parameter to 0. To search all rows, set the lRowStart parameter to 0 and the lRowEnd parameter to –1.
    3. Set the lpszText parameter to a pointer specifying the text or value for which to search.
    4. Set the wSearchFlags parameter to specify the kind of search to perform (for example, match case or partial match).
  2. To search for data in a particular row, use the SSSearchRow method and set the parameters as follows,
    1. Set the lRow parameter to specify the row to search.
    2. Set the lColStart and lColEnd parameter to specify the columns at which to start and end searching.
      To start at the beginning of the columns, set the lColStart parameter to 0. To search all columns, set the lColStart parameter to 0 and the lColEnd parameter to –1.
    3. Set the lpszText parameter to specify the text or value for which to search.
    4. Set the wSearchFlags parameter to specify the kind of search to perform (for example, match case or partial match).
  3. Repeat step 1 or 2 as needed to return the locations of each occurrence of the text or value in the column or row you are searching. When the function returns –1, there are no more occurrences of the text or value in the specified column or row.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.