of_find

pfcdwsrv.pbl   >   pfc_n_cst_dwsrv_find   >   of_find

Name	Datatype
ll_rowfound	long
ls_findexp	string

public function long of_find (string as_column, string as_find, long al_startrow, long al_endrow);//////////////////////////////////////////////////////////////////////////////
//
//	Function:  		of_Find
//
//	Access:  		public
//
//	Arguments: 	
//	as_column		Column name to search.
//	as_find			Text to search for.
//	al_startrow		Row number to start search.
//	al_endrow		Row number to end search.
//
//	Returns:  		long
//						Row number where text was found, or
//						0 if not found
//						-1 if an error is encountered.
//
//	Description: 	Search on a specific column, for a specific value, with a
//						starting row, and an ending row. 
//
//////////////////////////////////////////////////////////////////////////////
//
//	Revision History
//
//	Version
//	5.0   Initial version
//
//////////////////////////////////////////////////////////////////////////////
//
//	Copyright © 1996-1997 Sybase, Inc. and its subsidiaries.  All rights reserved.
//	Any distribution of the PowerBuilder Foundation Classes (PFC)
//	source code by other than Sybase, Inc. and its subsidiaries is prohibited.
//
//////////////////////////////////////////////////////////////////////////////

string   ls_findexp
long		ll_rowfound

//Check arguments
If IsNull(as_column) or Len(Trim(as_column))=0 or &
	IsNull(as_find) or Len(Trim(as_find))=0 or &
	IsNull(al_startrow) or al_startrow < 0 or &
	IsNull(al_endrow)	or al_endrow < 0 Then
	Return -1
End If

//Check required.
If IsNull(idw_requestor) Or Not IsValid(idw_requestor) Then
	Return -1
end If

//Build the find expression to search the dw.
ls_findexp = of_BuildFindExpression(as_find, as_column)
If ls_findexp = "!" Then Return -1

//Get the starting row for which the search text was found.
ll_rowfound = idw_requestor.Find (ls_findexp, al_startrow, al_endrow)

//Return search results.
return ll_rowfound


end function

Name	Owner
pfc_n_cst_dwsrv_find.of_replace	pfc_n_cst_dwsrv_find

Name	Owner
datawindow.find	datawindow
systemfunctions.isnull	systemfunctions
systemfunctions.isvalid	systemfunctions
systemfunctions.len	systemfunctions
systemfunctions.trim	systemfunctions
pfc_n_cst_dwsrv_find.of_buildfindexpression	pfc_n_cst_dwsrv_find