Solved

Deleted records in FRX file

Posted on 2011-02-27
7
484 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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

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…
The conference as a whole was very interesting, although if one has to make a choice between this one and some others, you may want to check out the others.  This conference is aimed mainly at government agencies.  So it addresses the various compli…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

724 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