Code Comments

Programming Forum and web based access to our favorite programming groups.
For Programmers: Free Programming Magazines | New: Database administration forum
Registration is free! Edit your profileCalendarFind other membersFrequently Asked QuestionsSearch -> 
Post New Thread











Thread
Author

modify expression of computed field in the detail band
How can I modify the expression of a computed field
in the detail band of a datawindow?

dw_plan.object.cli.expression = "'ABC'"
works but I would like to have a different
expressions for each row ...

Xaver




Report this thread to moderator Post Follow-up to this message
Old Post
Xaver Trapichler
03-21-08 01:15 PM


Re: modify expression of computed field in the detail band
You cant change expression of a computed object row wise (as in the
case of columns)

To go around with this problem
1 .to the existing select list add a non existing column
Select ................,  1000 AS 'comp_1'  from tab1
2.in the script
for i = 1 to dw_1.rowcount ()
dw_1.object.comp_1 [i] = dw_1.object.unitprice [i] * 2
next
( where unitprice of  the current row * 2  is the expression)

3. if u r very specific on row number
add if statements to create new expression based on row numbers
like
if i=123 then dw_1.object.comp_1 [i] = dw_1.object.unitprice [i] *
2.51


On Mar 21, 2:37 pm, "Xaver Trapichler" <xt...@aon.at> wrote:
> How can I modify the expression of a computed field
> in the detail band of a datawindow?
>
> dw_plan.object.cli.expression = "'ABC'"
> works but I would like to have a different
> expressions for each row ...
>
> Xaver


Report this thread to moderator Post Follow-up to this message
Old Post
RT
04-03-08 11:30 AM


Sponsored Links




Last Thread Next Thread Next
Search this forum -> 
Post New Thread

PowerBuilder archive

Show a Printable Version Send to friend Email This Page to Someone! subscribe to this thread Receive updates to this thread
Computer Consultants
Programming Jobs
Visual Basic Controls
SQL Server Programming
Webservices
Java Security
Visual Studio
C# Programming
Visual J++
Software engineering
Open source Software
Perl Programming
PHP Programming
ASP Programming
ASP .NET Programming
Visual Basic Programming
Windows Scripting Host
Java Programming
Java Help
Java Beans
VBScript
Cobol
MAC Applications
Unix Programming
Forum Jump:
All times are GMT. The time now is 12:55 PM.

 
Free MCSE Braindumps | Real Estate Topics

Programming forum archive

Copyrights CodeComments.com 2004 - 2006

Powered by vBulletin Copyright 2000-2006 Jelsoft Enterprises Limited.