Hi Rick and Don,
Sorry, but I don't remember this either.
Don, I assume that you have found the error description:
*Error 154 *- *Attempt to read block 0 as text. *
The file DataPerfect is trying to read is corrupt or not a valid format.
Restore from backup. If there is no backup, try deleting the .IND file,
exporting all data, deleting panel files and .TXX file, importing data.
Since this began while editing a report, it is probably the structure file
which is damaged. The best recovery is to restore from your latest backup.
If that is not possible, there may be other alternatives.
Hopefully the damage is contained in the report area and you can get a
smaller structure file created without any reports, to allow you access to
the data itself.
There are two or three different ways to do that.
1. If someone can remember the option to DPExp to export all but reports...
2. Use of the STE-MGR.COM program should produce a file with extension .{L}
that can be imported as a t-log into the STE-BASE database (these files are
included in later DP releases, and Brian Hancock has released an updated
version described at
http://www.mail-archive.com/[email protected]/msg00965.html )
3. Use of the METADXP.COM program should produce a file with extension .{X}
that can be imported as a t-log into the METAD database (these files are
available at http://www.sanbachs.net/firestorm/download.html ). It is a part
of firestorm and is described in part 1 of
http://www.sanbachs.net/firestorm/usage.html ). Ignore the part about pba.c
and look for a report in METAD that generates an STE file.
Options 1 and 3 should get you an STE file for everything except reports
(and except the current values of auto incrementing fields) and you could
use DPIMP to get a basic STR file that would allow you access to your data.
Option 2 might also be able to generate an STE file, but I don't know this.
In any case it could get you complete documentation; enough to rebuild a
basic STR file.
All three of these programs read the structure file using the same Forth
code, and so they will probably all work or none of them work. There was
once a different program that read the structure file, to export reports,
but I can't put my hands on it immediately. If you need something like that,
please let me know and I will dig deeper.
Best wishes,
Bruce
2010/11/8 Rick Parry <[email protected]>
> If I'm remembering correctly there was a way to export everything except
> reports with DPExp. I must admit I can't remember the command off the top of
> my head.
>
> -Rick
>
> ------------------------------
> *From:* Don Friedman <[email protected]>
> *To:* [email protected]
> *Sent:* Mon, October 11, 2010 9:30:19 AM
> *Subject:* [Dataperf] Error 154
>
> I am in an election cycle and was just modifying a report on a very large
> voter database and got kicked out with an error code 154. Re-entering the
> database doesn't work. Removing the index file and attempting to rebuild
> that doesn't work. Trying to export the .str file so I could delete the
> report I was working on doesn't work. Every attempt to use the database is
> stymied by this error code. Does anyone have any ideas on how I could
> recover this?
>
>
> Don
>
> --
> Don Friedman
> ProfessionalRecords.Com LLC
> PRS Data Systems
> 205 S Main Street
> Pittsburgh, PA 15215
> 412-784-1600 - 1-800-PRS-FILE
> 412-784-1615 Fax
>
>
> _______________________________________________
> Dataperf mailing list
> [email protected]
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
