Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB10 and Datawindows - Passing arguments

Status
Not open for further replies.

noway55

Programmer
Jun 12, 2005
1
US
How do I pass an argument as part of the selection criteria for a datawinow when using the datawindow painter?

I.E. If I want to build a dw where the data select is based on a database table element compared to a like (both databse element and global definition are defined as string) defined global in the where statement, what would the dw painter statement look like?

table.elementname = gcompare

How is the non-database field (gcompare) represented? is it:
(1) gcompare
(2) :gcompare
(3) 'gcompare'
(4) ':gcompare'

or something entirely different?

Thanks for your assistance.

 
If you define the argument in the datawindow painter as a "string gcompare" the syntax is "table.elementname = :gcompare"

Matt

"Nature forges everything on the anvil of time
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top