I need to show deleted records along with non-deleted 1

[cinbh]

We use Visual FoxPro 7.0 for our database and there are occasions in using Crystal 8.5 where I will need to recall orders that have been deleted. The database does not get "packed" so essentially I need to do a "dirty read". Is there a way to set this up on a report basis only? I wouldn't want to have this as an option on every report.
Thank you
Cindy

 

[dgillz]

I don't know what a "dirty read" is.

Unless the records are not physically deleted, and instead are marked with some sort of flag as deleted, you are out of luck. Crystal cannot repport on data that is not there. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[cinbh]

Yes, they are flagged as deleted (supported by FoxPro) but since it has not been "packed" (which essentially erases them) they still reside in the database. So is there a way I can bring them into my report?
Thanks,
Cindy

 

[mbarron]

They will be brought back unless you've specifically asked Crystal not to retrieve them. Check your select expert. You should have a line that asks for the active record or excludes the inactive

From one of my report:

{IIM.ID}=&quot;IM&quot; <--&quot;IM&quot; is the active record indicater for the database.

or

not({IIM.ID}=&quot;IM&quot; ) <-- this would return only inactive records Mike

 

[kenhamady]

Dbase does things differently. It doesn't mark them using a field, it does it internally. This is invisible to CR.

I assume you are connecting directly. You con confirm this using Database - Convert database Driver and looking at the DLL listed in grayed out text. It will probably say PDBxbse.dll.

If so, you will not see deleted records because this DLL knows not to use them. It doesn't give you the option of using them.

R&R report writer for Xbase has this option, and I still use it on occasion just for that feature. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[cinbh]

Ken, we checked and found the pdsodbc.dll is currently being used and could not find a PDBxbse.dll (although we are using Foxpro rather than Dbase). Since I'm NOT seeing the deleted records is there another dll we should try out and it would only be for that report is that correct?

It's interesting that you bring up R&R as we used this about 15 years ago when we had a Dbase platform. My supervisor was curious about your opinion of R&R vs. Crystal.
Thanks so much for your help.
Cindy

 

[kenhamady]

I don't think that ODBC or Crystal has any way of reading deleted records.

I was one of the 50 authorized RR trainers in the US 6 years ago. R&R can read deleted Xbase records and it is the one of the few things that it has as a strength against Crystal. I just used that feature today with Goldmine data when I hit Delete to quickly and didn't know what I had deleted.

The others are RR advantages are:

Ability to link on an expression field.
Control of the index used for a link.
Ability to specify look up vs scan link.
Less restrictive license.
Ability to Batch Email.
Better export to a table (maintains field names)

But CR has dozens of things in its favor over RR like:
Ability to read many platforms
Cross-tabs.
Better formula editor and variables
Better criteria control
Ability to Edit in Preview
Better parameters
Subreports
And those are just off the top of my head.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[cinbh]

Thanks Ken. Your command of the subject is greatly appreciated! I've forwarded to my supervisor your comparison. And thank you to dgillz and mbarron for your responses.
Cindy