Solved

Deleted records in FRX file

Posted on 2011-02-27
7
477 Views
Last Modified: 2012-06-22
Hi all folks

I am discussing here why and when deleted records remain in the FRX file and we simply don't have an answer.

I am trying to add and remove report controls in the designer but the report file is always packed, so deleted records do never appear.

The question is: Do you know how to create deleted record in the FRX file using standard development tools like Report designer, Project manager etc. but not DELETE command or similar force? Is it a feature of certain VFP version?

Thanks for your answers.
0
Comment
Question by:pcelba
[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
  • 4
  • 2
7 Comments
 
LVL 14

Accepted Solution

by:
tusharkanvinde earned 250 total points
ID: 34992767
You cannot keep deleted record in an FRX. You can disable controls with Print When instead of deleting them.
0
 
LVL 14

Expert Comment

by:tusharkanvinde
ID: 34992777
I need to check the name of the questioner before I answer. Don't think I wrote anything you did not already know :-)
0
 
LVL 42

Author Comment

by:pcelba
ID: 34992786
It is not my intention to keep deleted records in FRX. I am just asking how to avoid the automatic FRX file packing when you delete some control, so the deleted record is then visible in e.g. BROWSE.
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 
LVL 42

Author Comment

by:pcelba
ID: 34992789
:-)
0
 
LVL 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 250 total points
ID: 34996017
I'm afraid you can't avoid the packing, so tushar has perhaps given the best advice to use PrintWhen with .F. to never print but keep the report object.

The same goes for other components like classes, forms, etc. The only observation I made is that memo bloat can ramain despite that automatic packing in a case of a class with very many methods. It's an interface offering many simple up to more complex queries to data and the code is centralized there to be used by a whole suite of company applications. A single edit can grow the vcx and the resulting app (it's used as an app, not exe or dll), is causing enormous file growth despite no record is deleted.

Your demand is best fulfilled with printwhen, isn't it? Despite it's unfortunate, if you have many controls at the same postion on top of each other, this makes maintainance bad. I often do preprocessing of frx as data before report form, that way I modify one such control to have different expressions or styles.

Bye, Olaf.
0
 
LVL 42

Author Comment

by:pcelba
ID: 34996220
No, I don't need to use deleted record in my .nnX files at all. I am just sure there were such records sometimes but I am not able to reproduce their creation in FRX... and somebody else is even not able to "create" deleted records in VCXes...

I am just curious. :-)
0
 
LVL 42

Author Closing Comment

by:pcelba
ID: 38104044
Even the answer "This is not possible" is acceptable.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

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…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 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