pfc_operators

pfcdwsrv.pbl   >   pfc_n_cst_dwsrv_querymode   >   pfc_operators

Name	Datatype
la_colvalue	any[]
li_rc	integer
lnv_selection	n_cst_selection
ls_colreturn	string[]
ls_value	string
lstr_svalue	s_svalue[]

event pfc_operators;//////////////////////////////////////////////////////////////////////////////
//
//	Event:  pfc_operators
//
//	Arguments:  none
//
//	Returns:  integer
//	 1 = success
//	 0 = user cancelled from selection window
//	-1 = error
//
//	Description:
//	Allows user to select from a list of querymode operators
//
//////////////////////////////////////////////////////////////////////////////
//	
//	Revision History
//
//	Version
//	5.0   Initial version
//
//////////////////////////////////////////////////////////////////////////////
//
//	Copyright © 1996-1999 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.
//
//////////////////////////////////////////////////////////////////////////////

any		la_colvalue[]
integer	li_rc
string		ls_value
string		ls_colreturn[]
n_cst_selection	lnv_selection
s_svalue		lstr_svalue[]

SetPointer (hourglass!)

// Validate requestor
if IsNull(idw_requestor) Or not IsValid (idw_requestor) then
	return -1
end if

// Populate operators
lstr_svalue[1].s_value = "and "
lstr_svalue[2].s_value = "or "
lstr_svalue[3].s_value = "< "
lstr_svalue[4].s_value = "> "
lstr_svalue[5].s_value = "<= "
lstr_svalue[6].s_value = ">= "
lstr_svalue[7].s_value = "= "

// Open selection window to allow choice of column value
ls_colreturn[1] = "value"
li_rc = lnv_selection.of_Open ("d_svalue", la_colvalue[], lstr_svalue[], ls_colreturn[], "Operators")
if li_rc > 0 then
	ls_value = la_colvalue[1]
	idw_requestor.ReplaceText (ls_value)
end if

return li_rc
end event

Name	Owner
pfc_u_dw.pfc_operators	pfc_u_dw

Name	Owner
datawindow.replacetext	datawindow
systemfunctions.isnull	systemfunctions
systemfunctions.isvalid	systemfunctions
systemfunctions.setpointer	systemfunctions
pfc_n_cst_selection.of_open	pfc_n_cst_selection

Full name
s_svalue