Solved

freeze coloume in a grid

Posted on 2002-06-17
9
672 Views
Last Modified: 2013-12-26
I use PB 6.51
How do I freeze say 1st 2 coloum in a grid type data window from scrolling during a horizontal scroll

Help urgently requested
0
Comment
Question by:kathotia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 4

Expert Comment

by:Bhatti
ID: 7083323
Sometime happened that we can't find some fuctions and properties to solve such prblems.
It may exist function or property to freez columns like EXCEL Sheet in PB, but I never meet such situation.

If realy not exist such functions or properties, then we need some tricks.

Make two datawindows
One with these first two columns and second with the rest columns.
Placed them side by side.
Put a scroll bar for second datawindow.

First two column will remain freez.

If you need some special records to make report make a third datawindow to use for such perpose.


Best regards

Bhatti
0
 
LVL 1

Author Comment

by:kathotia
ID: 7083388
bhatti:

good sugestion! but, if the number of rows is more than displayed at a time how do is syncronise the vertical scroll of the first datawindow
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 7083899
Do the following:

In the scrollverticle Event of the datawindow where you want to scroll:

// Instance variable
string is_lastrow

is_lastrow = dw_1.Object.Datawindow.LastRowOnPage // If it is dw_1
RETURN 0

// say dw_2 is the datawindow which is freezed8with two columns)

LONG   ll_row

ll_row = LONG(is_lastrow)
dw_2.ScrollToRow(ll_row)

Lastrowonpage property will tell you the last row number on the window where you have a scrollbar and when scrollvertical event occured then other datawindow will be scrolled to the row as have the datawindow ith scrolbar.

Try it may this help.


I am sure it will work.
Please let me know, Now I am busy and can't test it.
If you have any question please let me know.

Best regards


Bhatti
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Expert Comment

by:Bhatti
ID: 7092115
Please let me know is it working.

If not, let me knoe the abort position.


Thanks

Best regards

Bhatti
0
 
LVL 1

Author Comment

by:kathotia
ID: 7092168
Bhatti:

Your suggestion was tried out, dw_2 does scroll but there is no scyncronisation between the verticle scrolling of the two data windows.
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 7092662
What do u mean by "no scyncronisation between the verticle scrolling of the two data windows. "


Bhatti
0
 
LVL 1

Expert Comment

by:levr
ID: 7094017
http://www.dw-extreme.com/
here are some examples. worth to take a look.
Lev
0
 

Accepted Solution

by:
ptbarnum earned 100 total points
ID: 7094674
You can set SplitScoll On and manually or programtically set the position of the split scroll.  In 7.0 the split scroll is set in the preview pane, by dragging the black bar at the left of the horizontal scroll bar to the desired position. In 6.5.1 it may be a property that can be set in the gui but I'm sure it can be set via dot notatin dw_1.datawindow.splitscroll = 1.
0
 

Expert Comment

by:Niemand
ID: 7111844
What about in PowerBuilder 8.0?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IntelliJ IDE error, java: package javax.servlet does not exist 3 1,629
Eclipse and java version isssue 2 50
C#  WebForms or MVC 4 133
Java Help 2 90
Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question