I don't know my Column Names (AREV Specific)
At 23 SEP 1998 09:06:38AM Greg Gates wrote:
I am trying to export a table to ASCII. I'm using TCL - RUNMENU APPMAIN then Utilities Export ASCII. I'm ok on everything up to the Field Name. When I press F2 on the fieldname, I only get (Empty). I'm trying to export the entire contents of all the files on my system, but I think I am missing a key component, like a dictionary file. Is there anyway around this? Can I just export all the fields as one long record?
At 23 SEP 1998 10:33AM Matt Sorrell wrote:
Is this happening for all of your tables, or just one?
If it's just one table, you could go in a create dictionaries columns just to reference them, like 1, 2, 3, etc…
I know this is not elegant, but it would work. You would just need to make sure you defined enough columns to cover your largest record. The only other consideration would be what data types are stored in the columns. If you don't already know the file layout, it might be interesting trying to determine if they are date, time, or dollar fields.
As far as exporting a table that does not have a dictionary, I'm not sure.
Matt Sorrell
At 23 SEP 1998 10:56AM Greg Gates wrote:
Yes it is happening to all my tables. The company that wrote our program went bankrupt 2 years ago, and never provided us with the dictionary files. How would I create the 1,2,3 fields?
At 23 SEP 1998 11:45AM Matt Sorrell wrote:
Greg,
If you don't have dictionaries for any of your tables, your best bet is going to be to write a program that will loop through all the tables in the system, and dump them out to DOS.
Having to create dictionaries for all of your tables would take just about as much time, and you would not be sure if you were getting all of your data.
If you don't know much about programming in AREV, I'll help you as best I can.
I'm sure there are others on this site that could do it better than myself, but I'll give it my best shot.
Matt Sorrell
At 23 SEP 1998 12:23PM Greg Gates wrote:
Matt,
I would really appreciate your help with that program. I program in other languages but I don't know anything about programming in AREV. Matter of fact I don't know that I even have the right software to write a program in AREV. I may have a runtime version only although I can run TCL commands. *Shrug* I would really like to try it though. Thanks.
At 23 SEP 1998 01:42PM Matt Sorrell wrote:
Greg,
If you'll send me your e-mail address, I'll see what I can do for you.
Matt Sorrell
msorrell@movgal.com