GoFish Search Results Cursor Schema

Below is the cursor schema of the Search Results that GoFish creates as it is searching. These field names are used in the Filtering mechanism of GoFish, and in the Replace History table. Knowing these field names, you can do some creative things behind the scenes while GoFish is active. Such as applying a custom filter to the records, etc.


Field Name Data Type Description
PROCESS L Used to mark a record for Replace operation
FILEPATH C(254) Full path, filename, extension
FILENAME C(50) The filename and extension only
TRIMMEDMATCHLINE C(254) The entire line of code where the match was found (with preceding and trailing whitespace removed)
BASECLASS C(254) Native FoxPro baseclass type
PARENTCLASS C(254) Parent Class
CLASS C(254) Class of object
OBJECTNAME C(254) Name of object
METHODNAME C(80) Method Name
OBJECTCLASS C(254) Class of object
OBJECTBASECLASS C(254) Baseclass of object
MATCHTYPE C(25) Indicates what kind/where the match is.
TIMESTAMP T  
FILETYPE C(4) The file extension
TYPE C(12)  
RECNO N(6) The record no from the VCX/SCX/FRX
PROCSTART I  
MATCHSTART I Character position of the beginning of the line where a match was found.
MATCHLEN I The length of the line on which the match was found.
LISTEXT L A flag to indicate if file is a text file.
COLUMN C(10) The column from the VCX/SCX/FRX where the match was found
CODE M The entire blob of code where the match came from
ID I Unique row number in the cursor
MATCHLINE M The entire line of code where the match was found (with all white space left intact)
REPLACED L A flag to indicate if the Replace operation was applied to the row.
TRIMMEDREPLACELINE C(254) The entire replace line of code with the match replaced (with preceding and trailing whitespace removed)
REPLACELINE C(254) The entire replace line of code with the match replaced (with all white space left intact)
REPLACERISK I A number 1 through 3 indicating the risk level of replacing this row.
REPLACE_DT T Date and Time the replace was applied. This is helpful in the replace logs.

Last edited Feb 2, 2012 at 4:17 PM by mattslay, version 5

Comments

No comments yet.