Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dynamic Columns

9 posts in DataWindow Last posting was on 2009-01-08 22:33:23.0Z
RISI Posted on 2009-01-07 14:35:40.0Z
Sender: 5f50.4964bcdd.1804289383@sybase.com
From: RISI
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Dynamic Columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4964bdbc.5f83.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2009 06:35:40 -0800
X-Trace: forums-1-dub 1231338940 10.22.241.41 (7 Jan 2009 06:35:40 -0800)
X-Original-Trace: 7 Jan 2009 06:35:40 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88501
Article PK: 417754

My question is can we dynamically create columns in the
datawindows during runtime? There might be only one column
if there is one machine, but 10 columns if there are 10
machines.

Please help, Thanks in advance.


Brad Wery[TeamSybase] Posted on 2009-01-07 14:49:48.0Z
From: "Brad Wery[TeamSybase]" <bradweryatgmail.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns
References: <4964bdbc.5f83.1681692777@sybase.com>
In-Reply-To: <4964bdbc.5f83.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4964c10c$1@forums-1-dub>
Date: 7 Jan 2009 06:49:48 -0800
X-Trace: forums-1-dub 1231339788 10.22.241.152 (7 Jan 2009 06:49:48 -0800)
X-Original-Trace: 7 Jan 2009 06:49:48 -0800, vip152.sybase.com
Lines: 36
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88502
Article PK: 417756

Is this datawindow based on SQL? Is a column bound to a column in a table?

You can create columns using the Modify datawindow method. I'm not sure
if this will get you want you want. The column that gets created is just
a visual artifact that represents an underlying table column in the
datawindows SQL. Another option would be to create the entire datawindow
dynamically using the SyntaxFromSQL transaction object function.

Can you give us a little more information about what you want to do.

Thanks,

Brad

RISI wrote:
> My question is can we dynamically create columns in the
> datawindows during runtime? There might be only one column
> if there is one machine, but 10 columns if there are 10
> machines.
>
> Please help, Thanks in advance.

--

******************************************************************************************************
www.PowerToTheBuilder.com
- Take control of your GUI with a free PB user control library
- Get updates from my blog - blog.PowerToTheBuilder.com
- Get support from - forum.PowerToTheBuilder.com

******************************************************************************************************
www.iCrazySQL.com
- Free, full featured database development tool for ASE, SQL Server
and SQL Anywhere

******************************************************************************************************


RISI Posted on 2009-01-07 17:45:51.0Z
Sender: 5f50.4964bcdd.1804289383@sybase.com
From: RISI
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4964ea4f.665e.1681692777@sybase.com>
References: <4964c10c$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2009 09:45:51 -0800
X-Trace: forums-1-dub 1231350351 10.22.241.41 (7 Jan 2009 09:45:51 -0800)
X-Original-Trace: 7 Jan 2009 09:45:51 -0800, 10.22.241.41
Lines: 73
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88504
Article PK: 417757

Yes this is a column from the table. The column name is the
dryer
number, Mill id and the dryer number is the primary key
columns
in the Table. A mill might have one dryer or any numbers, it
varies for each mill.

For example
1. If Mill A has 2 dryers named A1 and B2,when I choose Mill
A I want the display as and the values below.
A1 B2

2. If Mill B has 4 dryers 9,10,11,12,when I choose Mill B I
want the display as and the values
9 10 11 12

My question is how do I increase or decrease the number of
dryer columns in run time to display their values.SInce the
number of dryers in a mill is not a constant i dont know
whether a dynamic sql will work

Please help.

Thankyou

> Is this datawindow based on SQL? Is a column bound to a
> column in a table?
>
> You can create columns using the Modify datawindow method.
> I'm not sure if this will get you want you want. The
> column that gets created is just a visual artifact that
> represents an underlying table column in the datawindows
> SQL. Another option would be to create the entire
> datawindow dynamically using the SyntaxFromSQL
> transaction object function.
>
> Can you give us a little more information about what you
> want to do.
>
> Thanks,
>
> Brad
>
> RISI wrote:
> > My question is can we dynamically create columns in
> > the datawindows during runtime? There might be only one
> > column if there is one machine, but 10 columns if there
> > are 10 machines.
> >
> > Please help, Thanks in advance.
>
> --
>
> **********************************************************
> ********************************************
> www.PowerToTheBuilder.com
> - Take control of your GUI with a free PB user control
> library
> - Get updates from my blog - blog.PowerToTheBuilder.com
> - Get support from - forum.PowerToTheBuilder.com
>
> **********************************************************
> ********************************************
> www.iCrazySQL.com
> - Free, full featured database development tool for ASE,
> SQL Server and SQL Anywhere
>
> **********************************************************
> ********************************************


M. Searer Posted on 2009-01-07 19:20:43.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4964c10c$1@forums-1-dub> <4964ea4f.665e.1681692777@sybase.com>
In-Reply-To: <4964ea4f.665e.1681692777@sybase.com>
Subject: Re: Dynamic Columns
Lines: 79
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4965008b@forums-1-dub>
Date: 7 Jan 2009 11:20:43 -0800
X-Trace: forums-1-dub 1231356043 10.22.241.152 (7 Jan 2009 11:20:43 -0800)
X-Original-Trace: 7 Jan 2009 11:20:43 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88506
Article PK: 417759

sounds like your data model isn't normalized -
mill and dryers have a 1 to many relationship and should be separate tables.

"RISI" wrote in message news:4964ea4f.665e.1681692777@sybase.com...
> Yes this is a column from the table. The column name is the
> dryer
> number, Mill id and the dryer number is the primary key
> columns
> in the Table. A mill might have one dryer or any numbers, it
> varies for each mill.
>
> For example
> 1. If Mill A has 2 dryers named A1 and B2,when I choose Mill
> A I want the display as and the values below.
> A1 B2
>
> 2. If Mill B has 4 dryers 9,10,11,12,when I choose Mill B I
> want the display as and the values
> 9 10 11 12
>
> My question is how do I increase or decrease the number of
> dryer columns in run time to display their values.SInce the
> number of dryers in a mill is not a constant i dont know
> whether a dynamic sql will work
>
> Please help.
>
> Thankyou
>
>
>
>
>
>> Is this datawindow based on SQL? Is a column bound to a
>> column in a table?
>>
>> You can create columns using the Modify datawindow method.
>> I'm not sure if this will get you want you want. The
>> column that gets created is just a visual artifact that
>> represents an underlying table column in the datawindows
>> SQL. Another option would be to create the entire
>> datawindow dynamically using the SyntaxFromSQL
>> transaction object function.
>>
>> Can you give us a little more information about what you
>> want to do.
>>
>> Thanks,
>>
>> Brad
>>
>> RISI wrote:
>> > My question is can we dynamically create columns in
>> > the datawindows during runtime? There might be only one
>> > column if there is one machine, but 10 columns if there
>> > are 10 machines.
>> >
>> > Please help, Thanks in advance.
>>
>> --
>>
>> **********************************************************
>> ********************************************
>> www.PowerToTheBuilder.com
>> - Take control of your GUI with a free PB user control
>> library
>> - Get updates from my blog - blog.PowerToTheBuilder.com
>> - Get support from - forum.PowerToTheBuilder.com
>>
>> **********************************************************
>> ********************************************
>> www.iCrazySQL.com
>> - Free, full featured database development tool for ASE,
>> SQL Server and SQL Anywhere
>>
>> **********************************************************
>> ********************************************


RISI Posted on 2009-01-07 22:44:10.0Z
Sender: 6841.4964ff3d.1804289383@sybase.com
From: RISI
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns , details
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4965303a.6cdc.1681692777@sybase.com>
References: <4965008b@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2009 14:44:10 -0800
X-Trace: forums-1-dub 1231368250 10.22.241.41 (7 Jan 2009 14:44:10 -0800)
X-Original-Trace: 7 Jan 2009 14:44:10 -0800, 10.22.241.41
Lines: 99
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88508
Article PK: 417762

The data model is normalised, the table is OK. They are in
seperate tables, they have one to many relationships.

The issue is the presentation (datawindow) the dryers need
to be displayed in different columns.

For example if one Manager A has 5 employees and another
Manager B has 10 employees, I understand you can display the
Number of employees in 5 rows when you select the Manager A
but I want to know how can we display them in columns, 5 for
Manager A and 10 for Manager B.

Please help.

Thankyou,
RISI

> sounds like your data model isn't normalized -
> mill and dryers have a 1 to many relationship and should
> be separate tables.
>
>
>
> "RISI" wrote in message
> > news:4964ea4f.665e.1681692777@sybase.com... Yes this is
> > a column from the table. The column name is the dryer
> > number, Mill id and the dryer number is the primary key
> > columns
> > in the Table. A mill might have one dryer or any numbers
> > , it varies for each mill.
> >
> > For example
> > 1. If Mill A has 2 dryers named A1 and B2,when I choose
> > Mill A I want the display as and the values below.
> > A1 B2
> >
> > 2. If Mill B has 4 dryers 9,10,11,12,when I choose Mill
> > B I want the display as and the values
> > 9 10 11 12
> >
> > My question is how do I increase or decrease the number
> > of dryer columns in run time to display their
> > values.SInce the number of dryers in a mill is not a
> > constant i dont know whether a dynamic sql will work
> >
> > Please help.
> >
> > Thankyou
> >
> >
> >
> >
> >
> >> Is this datawindow based on SQL? Is a column bound to a
> >> column in a table?
> >>
> >> You can create columns using the Modify datawindow
> method. >> I'm not sure if this will get you want you
> want. The >> column that gets created is just a visual
> artifact that >> represents an underlying table column in
> the datawindows >> SQL. Another option would be to create
> the entire >> datawindow dynamically using the
> SyntaxFromSQL >> transaction object function.
> >>
> >> Can you give us a little more information about what
> you >> want to do.
> >>
> >> Thanks,
> >>
> >> Brad
> >>
> >> RISI wrote:
> >> > My question is can we dynamically create columns in
> >> > the datawindows during runtime? There might be only
> one >> > column if there is one machine, but 10 columns if
> there >> > are 10 machines.
> >> >
> >> > Please help, Thanks in advance.
> >>
> >> --
> >>
> >>
> **********************************************************
> >> ******************************************** >>
> www.PowerToTheBuilder.com >> - Take control of your GUI
> with a free PB user control >> library
> >> - Get updates from my blog -
> blog.PowerToTheBuilder.com >> - Get support from -
> forum.PowerToTheBuilder.com >>
> >>
> **********************************************************
> >> ******************************************** >>
> www.iCrazySQL.com >> - Free, full featured database
> development tool for ASE, >> SQL Server and SQL Anywhere
> >>
> >>
> **********************************************************
> >> ********************************************


Terry Voth [TeamSybase] Posted on 2009-01-08 17:32:02.0Z
From: "Terry Voth [TeamSybase]" <sequel@techno-kitten.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns , details
Message-ID: <4ldcm4hai4d4kk6tiv5ipjmi2ptponf5e4@4ax.com>
References: <4965008b@forums-1-dub> <4965303a.6cdc.1681692777@sybase.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 8 Jan 2009 09:32:02 -0800
X-Trace: forums-1-dub 1231435922 10.22.241.152 (8 Jan 2009 09:32:02 -0800)
X-Original-Trace: 8 Jan 2009 09:32:02 -0800, vip152.sybase.com
Lines: 149
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88515
Article PK: 417769

Basically, the answers you've received are probably your optimal
answers:

- SyntaxFromSQL to create a new DW

- programmatically edit the syntax of an existing DW to:
- change the SQL
- change the data set definition
- add UI elements

The only option I could think of is:

- create an uber-DataWindow with columns for the maximum number of
child elements in each row, then use a Modify ("DESTROY COLUMN ...")
for the columns you don't need.

Side note: I never realized DESTROY COLUMN would remove it from the
data set *and* from the SELECT clause, and with a decent DBMS [it
works in MS SQL; I'd expect it wouldn't in some of those "free"
database engines] it will optimize out any unnecessary joins if the
change in the SELECT column list makes them useless.

Good luck,

Terry and Sequel the techno-kitten

On 7 Jan 2009 14:44:10 -0800, RISI wrote:

>The data model is normalised, the table is OK. They are in
>seperate tables, they have one to many relationships.
>
>The issue is the presentation (datawindow) the dryers need
>to be displayed in different columns.
>
>For example if one Manager A has 5 employees and another
>Manager B has 10 employees, I understand you can display the
>Number of employees in 5 rows when you select the Manager A
>but I want to know how can we display them in columns, 5 for
>Manager A and 10 for Manager B.
>
>Please help.
>
>Thankyou,
>RISI
>
>
>> sounds like your data model isn't normalized -
>> mill and dryers have a 1 to many relationship and should
>> be separate tables.
>>
>>
>>
>> "RISI" wrote in message
>> > news:4964ea4f.665e.1681692777@sybase.com... Yes this is
>> > a column from the table. The column name is the dryer
>> > number, Mill id and the dryer number is the primary key
>> > columns
>> > in the Table. A mill might have one dryer or any numbers
>> > , it varies for each mill.
>> >
>> > For example
>> > 1. If Mill A has 2 dryers named A1 and B2,when I choose
>> > Mill A I want the display as and the values below.
>> > A1 B2
>> >
>> > 2. If Mill B has 4 dryers 9,10,11,12,when I choose Mill
>> > B I want the display as and the values
>> > 9 10 11 12
>> >
>> > My question is how do I increase or decrease the number
>> > of dryer columns in run time to display their
>> > values.SInce the number of dryers in a mill is not a
>> > constant i dont know whether a dynamic sql will work
>> >
>> > Please help.
>> >
>> > Thankyou
>> >
>> >
>> >
>> >
>> >
>> >> Is this datawindow based on SQL? Is a column bound to a
>> >> column in a table?
>> >>
>> >> You can create columns using the Modify datawindow
>> method. >> I'm not sure if this will get you want you
>> want. The >> column that gets created is just a visual
>> artifact that >> represents an underlying table column in
>> the datawindows >> SQL. Another option would be to create
>> the entire >> datawindow dynamically using the
>> SyntaxFromSQL >> transaction object function.
>> >>
>> >> Can you give us a little more information about what
>> you >> want to do.
>> >>
>> >> Thanks,
>> >>
>> >> Brad
>> >>
>> >> RISI wrote:
>> >> > My question is can we dynamically create columns in
>> >> > the datawindows during runtime? There might be only
>> one >> > column if there is one machine, but 10 columns if
>> there >> > are 10 machines.
>> >> >
>> >> > Please help, Thanks in advance.
>> >>
>> >> --
>> >>
>> >>
>> **********************************************************
>> >> ******************************************** >>
>> www.PowerToTheBuilder.com >> - Take control of your GUI
>> with a free PB user control >> library
>> >> - Get updates from my blog -
>> blog.PowerToTheBuilder.com >> - Get support from -
>> forum.PowerToTheBuilder.com >>
>> >>
>> **********************************************************
>> >> ******************************************** >>
>> www.iCrazySQL.com >> - Free, full featured database
>> development tool for ASE, >> SQL Server and SQL Anywhere
>> >>
>> >>
>> **********************************************************
>> >> ********************************************

*********************************
Build your vocabulary while feeding the hungry
http://www.freerice.com
*********************************
Newsgroup User Manual
=====================
TeamSybase <> Sybase employee
Forums = Peer-to-peer
Forums <> Communication with Sybase
IsNull (AnswerTo (Posting)) can return TRUE
Forums.Moderated = TRUE, so behave or be deleted
*********************************

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a free PowerBuilder Developer's Toolkit.
Version 4.0.4 now available at the Sandbox
PB Futures updated June 25/2008
See the PB Troubleshooting & Migration Guides at the Sandbox
^ ^
o o
=*=


Terry Voth [TeamSybase] Posted on 2009-01-07 16:34:54.0Z
From: "Terry Voth [TeamSybase]" <sequel@techno-kitten.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns
Message-ID: <93m9m4ddktkb339efj8gao7hbmfjhct1eu@4ax.com>
References: <4964bdbc.5f83.1681692777@sybase.com>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Jan 2009 08:34:54 -0800
X-Trace: forums-1-dub 1231346094 10.22.241.152 (7 Jan 2009 08:34:54 -0800)
X-Original-Trace: 7 Jan 2009 08:34:54 -0800, vip152.sybase.com
Lines: 49
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88503
Article PK: 417760

Like Brad said, there is potential for ambiguity in what you're
asking. In the DataWindow, there are data set columns and there are
user interface columns. Knowing which you're trying to add are
essential to give you a correct answer. Also, if you're trying to add
a data set column, knowing the data source is important (e.g. SELECT,
stored proc, external).

The brute force answer is that you can do anything you want with a
DataWindow at run time by creating or manipulating a DataWindow syntax
(hint: look at the export of a DW to get an idea of what the syntax
is) and doing a CREATE on it. This is the only way to do some things,
but depending on what you're after, there may be more elegant ways
(easier, faster) to do it.

Let us know,

Terry and Sequel the techno-kitten

On 7 Jan 2009 06:35:40 -0800, RISI wrote:

>
> My question is can we dynamically create columns in the
>datawindows during runtime? There might be only one column
>if there is one machine, but 10 columns if there are 10
>machines.
>
>Please help, Thanks in advance.

*********************************
Build your vocabulary while feeding the hungry
http://www.freerice.com
*********************************
Newsgroup User Manual
=====================
TeamSybase <> Sybase employee
Forums = Peer-to-peer
Forums <> Communication with Sybase
IsNull (AnswerTo (Posting)) can return TRUE
Forums.Moderated = TRUE, so behave or be deleted
*********************************

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a free PowerBuilder Developer's Toolkit.
Version 4.0.4 now available at the Sandbox
PB Futures updated June 25/2008
See the PB Troubleshooting & Migration Guides at the Sandbox
^ ^
o o
=*=


KL Posted on 2009-01-08 21:47:34.0Z
Sender: 1b19.49667348.1804289383@sybase.com
From: KL
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49667476.1b3b.1681692777@sybase.com>
References: <4964bdbc.5f83.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jan 2009 13:47:34 -0800
X-Trace: forums-1-dub 1231451254 10.22.241.41 (8 Jan 2009 13:47:34 -0800)
X-Original-Trace: 8 Jan 2009 13:47:34 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88518
Article PK: 417772

Maybe you could start with an n-up datawindow?
JAST
KL

> My question is can we dynamically create columns in the
> datawindows during runtime? There might be only one column
> if there is one machine, but 10 columns if there are 10
> machines.
>
> Please help, Thanks in advance.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-01-08 22:33:23.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4964bdbc.5f83.1681692777@sybase.com> <49667476.1b3b.1681692777@sybase.com>
Subject: Re: Dynamic Columns
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49667f33$1@forums-1-dub>
Date: 8 Jan 2009 14:33:23 -0800
X-Trace: forums-1-dub 1231454003 10.22.241.152 (8 Jan 2009 14:33:23 -0800)
X-Original-Trace: 8 Jan 2009 14:33:23 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88519
Article PK: 417773

Or maybe a crosstab.

<KL> wrote in message news:49667476.1b3b.1681692777@sybase.com...
> Maybe you could start with an n-up datawindow?
> JAST
> KL
>> My question is can we dynamically create columns in the
>> datawindows during runtime? There might be only one column
>> if there is one machine, but 10 columns if there are 10
>> machines.
>>
>> Please help, Thanks in advance.