Copy table to DOS (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 24 FEB 2009 01:07:32PM Jim Foulkrod wrote:

AREV Specific

I'm relearning AREV after a 12 year absence. I'm using AREV 3.1.2.

I need to copy a table to a .txt file. I've read some previous posts on the topic and have tried the suggestion that seemed most direct and appropriate:

COPYTABLE HELP TO:(DOS C:\ HELP.TXT (I

COPYTABLE HELP TO:(DOS C:\HELP.TXT (I

COPYTABLE HELP TO:(DOS C:\HELP.TXT (I)

COPYTABLE HELP TO:(DOS C:\HELP.TXT (I))

COPYTABLE HELP TO:(DOS C:\ HELP.TXT (I))

I get the error "The destination table name was not specified."

Can anyone tell me what I am doing wrong?

I no longer have any Advanced Revelations programming books or manuals so I will be glad to pay a premium to purchase or rent one that will help me get back up to speed.

Thanks in advance.

At 24 FEB 2009 09:52PM Barry Stevens wrote:

Try

COPYROW HELP * TO: (DOS C:\HELP.TXT (IO

At 25 FEB 2009 10:10AM Jim Foulkrod wrote:

COPYROW HELP * TO: (DOS C:\HELP.TEXT (IO

Gives "Physical Error Writing AW*SHIPPER*4 in table DOS

FS272

"AW*SHIPPER*4" is not a valid tablename in the DOS environment.

At 25 FEB 2009 10:49AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

You can't do it from TCL without creating an EXPORT first. So use the EXPORT Tool to do it and create a symbolic on HELP which says something like

@Ans=@Record

Swap @Fm with \0D0A\ In @Ans

and just export this.

The Sprezzatura Group

World leaders in all things RevSoft

At 26 FEB 2009 10:20AM Michael Slack wrote:

I like the Export idea. It all depends on what you are aiming for. An alternate idea is to use a LIST statement report to create a text file. I assume using header suppress and the like. Then do whatever processing on the other side.

Michael Slack

At 10 MAR 2009 09:38AM Warren Auyong wrote:

This would work as long as you don't violate the 8.3 naming limitation of DOS. However, you'll only get the last record copied in HELP.TEXT (overwritten not appended).

And value, sub-value, text marks etc. will not be converted.

So if you copy the contents of the HELP file to a temporary file and use perhaps a sequential number as the key (insert the ARev key before field 1). You can use the COPY method as long as you have less than 100,000,000 records in the file.

At 11 MAR 2009 04:40PM Victor Engel wrote:

The suggestion posted by The Sprezztura Group is a good one, but it could fail if you encounter a record size that is close to the maximum.

Here is another alternative that doesn't require the creation of a dictionary item.

PDISK C:\HELP.TXT

SELECT HELP

BLIST HELP

PDISK PRN

This will attempt to interpret the contents of the records of the HELP file as programs. For text that doesn't look like code, it will print just as plain text. If the lines wrap in the wrong place, you may wish to use a SET-LPTR command first to change the default report width.

You may also wish to do the same thing with the SYSHELP file.

A useful keystroke to remember:

CTRL-F9 (this is context sensitive and will get you a list of most of the keystrokes available to you given your current context)

Now that I've shown you the BLIST command, if you want to list programs out, you'll want to use it for that, too. Be default, in Arev 3.12 the programming file name is SOURCE. This file also includes symbol tables, to exclude symbol tables, do the following:

PDISK C:\PROGRAMS.TXT

SELECT SOURCE NOT STARTING "*"

BLIST SOURCE

PDISK PRN

The BLIST command by default directs output to the printer. The PDISK command redirects printer output to the nominated file.

I hope this was helpful.

View this thread on the forum...