Solved

freeze coloume in a grid

Posted on 2002-06-17
9
655 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
9 Comments
 
LVL 4

Expert Comment

by:Bhatti
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 4

Expert Comment

by:Bhatti
Comment Utility
Please let me know is it working.

If not, let me knoe the abort position.


Thanks

Best regards

Bhatti
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 1

Author Comment

by:kathotia
Comment Utility
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
Comment Utility
What do u mean by "no scyncronisation between the verticle scrolling of the two data windows. "


Bhatti
0
 
LVL 1

Expert Comment

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

Accepted Solution

by:
ptbarnum earned 100 total points
Comment Utility
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
Comment Utility
What about in PowerBuilder 8.0?
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
c++ class logger 6 102
How To Save SQL Server 2012 Import Data Package 16 129
error when checking java version 4 3,814
CKEditor - will not function 7 30
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…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

743 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now