datawindow receiving wrong parameter
- New
- How-to
-
Manuel Rivera
- PowerBuilder
- Monday, 6 October 2025 03:54 PM UTC
good day all,
when I login I am receiving this error message: as first
and as second:
the object d_pfcsecurity_controllist exists in my library : mey_ext_gefis.pbl, I have it created, and the methods for the security calls another library: the pfcapsrv.pbl . I have seeing thta the object: d_pfcsecurity_controllist contains this code:
release 10;
datawindow(units=0 timer_interval=0 color=1073741824 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 0 print.margin.right = 0 print.margin.top = 0 print.margin.bottom = 0 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
header(height=84 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=80 color="536870912" )
table(column=(type=char(64) updatewhereclause=yes name=window dbname="security_info.window" )
column=(type=char(128) updatewhereclause=yes name=control dbname="security_info.control" )
column=(type=char(1) updatewhereclause=yes name=status dbname="security_info.status" )
column=(type=long updatewhereclause=yes name=priority dbname="security_users.priority" )
retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"security_info~" ) TABLE(NAME=~"security_users~" ) COLUMN(NAME=~"security_info.window~") COLUMN(NAME=~"security_info.control~") COLUMN(NAME=~"security_info.status~") COLUMN(NAME=~"security_users.priority~") JOIN (LEFT=~"security_users.name~" OP =~"=~"RIGHT=~"security_info.user_name~" )WHERE( EXP1 =~"( ~~~"security_info~~~".~~~"window~~~"~" OP =~"=~" EXP2 =~":winname )~" LOGIC =~"and~" ) WHERE( EXP1 =~"( ~~~"security_info~~~".~~~"user_name~~~"~" OP =~"=~" EXP2 =~":username )~" LOGIC =~"and~" ) WHERE( EXP1 =~"( ~~~"security_info~~~".~~~"application~~~"~" OP =~"=~" EXP2 =~":appname )~" ) ) ORDER(NAME=~"security_info.control~" ASC=yes ) ORDER(NAME=~"security_users.priority~" ASC=yes ) ARG(NAME = ~"appname~" TYPE = string) ARG(NAME = ~"winname~" TYPE = string) ARG(NAME = ~"username~" TYPE = string) " arguments=(("appname", string),("winname", string),("username", string)) sort="control A priority A " )
text(band=header alignment="0" text="Window" border="0" color="0" x="23" y="16" height="60" width="818" html.valueishtml="0" name=window_t visible="1" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Control" border="0" color="0" x="864" y="16" height="60" width="709" html.valueishtml="0" name=control_t visible="1" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Status" border="0" color="0" x="1586" y="16" height="60" width="183" html.valueishtml="0" name=status_t visible="1" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="0" x="1787" y="8" height="68" width="901" format="[General]" html.valueishtml="0" name=priority visible="1" edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="23" y="8" height="68" width="827" format="[general]" html.valueishtml="0" name=window visible="1" edit.limit=30 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="0" x="864" y="8" height="68" width="709" format="[general]" html.valueishtml="0" name=control visible="1" edit.limit=30 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="0" x="1586" y="8" height="68" width="187" format="[general]" html.valueishtml="0" name=status visible="1" edit.limit=1 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
xhtmlgen() cssgen()
xmlgen()
xsltgen()
jsgen()
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
which I dont find any error with it, the query executes very good, give me the expected results, I did found that the parameter I see in the ssqlserver profiler is receiving the following query:
SELECT security_info.window,
security_info.control,
security_info.status,
security_users.priority
FROM security_info,
security_users
WHERE ( security_users.name = security_info.user_name ) and
( "security_info"."window" = :winname ) AND
( "security_info"."user_name" = :username ) AND
( "security_info"."application" = :appname )
ORDER BY security_info.control ASC,
security_users.priority ASC
that translated in sql is the foloowing:
SELECT security_info.[window] ,
security_info.control ,
security_info.status ,
security_users.priority
FROM security_info ,
security_users
WHERE ( security_users.name = security_info.user_name ) and
( "security_info".[window] = 'm_gefis_mdi_menu' ) and
( "security_info"."user_name" = 'acsitest' ) and
( "security_info"."application" = 'gefis' )
ORDER BY security_info.control ASC,
security_users.priority ASC
.... the problem is thta is sending 'acsitest' instead of 1.
this query is receiving 'username' as parameter value, instead of '1' I am expecting an 1 and not 'username' value, where can I check? How to solve my problem? Thanks in advance.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.