Solved

vfp9 grid shows to many lines

Posted on 2013-06-28
3
549 Views
Last Modified: 2013-07-18
Hi Experts
i have a table that got 35 records, when I display them in a grid grid shows more lines even after the last record. How can just show same number of lines in a grid as records of a table.
After the last record I do not want to show more lines.
Thanks
0
Comment
Question by:b001
3 Comments
 
LVL 27

Expert Comment

by:CaptainCyril
ID: 39285606
Make the grid smaller or make the RowHeight bigger. You can also disable the scrollbars and make the grid ReadOnly.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 39286336
Grids always scroll up to the point the last record is at the top line in the grid, there is no way to stop that.

If you set all columns sparse=.f. and set the grid.backcolor to a light grey you can visualize this part is empty. But that may introduce other problems, when you want sparse usage of a control just in the active record.

You could start trying automatic back scrolling, but forget about it, you rather should live with that grid behaviour or use another (activex) grid, if you can't live with that. But you'd always lose the ability to simply bind a DBF/view/cursor and need code to populate alernative grids.

Bye, Olaf.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 39286493
@b001: If this is the last problem in your VFP application than you have my deep respect.

My favorite solution from Olaf's answer is "you rather should live with that grid behaviour".

To change this VFP grid feature is almost impossible. In addition to Olaf's answers you may try some more crazy solutions, e.g.

1) Ask Microsoft for a paid hotfix
2) Ask China programmers to make this change for you. They released several unofficial hotfixes already. See http://www.baiyujia.com/vfpcompiler/en/default.asp for more details.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database Upscaling 9 98
Rewriting a VFP 9 application into a web based application 7 1,833
Alternative to "Do While" 12 159
diarydate calendar in vfp retrun data to form 7 417
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

18 Experts available now in Live!

Get 1:1 Help Now