Welcome, Guest. Please Login.
05/04/24 at 09:30:32
News:
Home Help Search Login


Pages: 1
Send Topic Print
Redefine fields... (Read 1036 times)
ITman
Member
**


Hello!

Posts: 76
Gender: female
Redefine fields...
11/05/03 at 07:55:35
 
Is there a way to recreate the structure of the data dictionary (filedict.dbf/mdx) for a file that you just have the source for and database for?  The only way I can think of is to by hand; compile, find fields not defined, figure out what they should be (types, and length) then define all of them again...  this is kinda time consuming...
 
I also understand that I can export all the information for the *.mdx and *.dbf info for the fields that are needed, I'm just wondering if this also works like I think:
 
1.  Create program/define fields
2.  Export FD's into XFR_*  files
3.  Copy said XFR_* files to server
4.  Import XFR_* files
 
Now the FDs will be updated with the new fields in the TAS6 prog that was created?
 
If there is no way to have the fields recreated in the above problem, I can see if I can get a hold of the original FDs (but I do not think I can...)
 
Thanks,
-ITman
 
P.S.  This forum is immensely helpful!
Back to top
 
 
  IP Logged
ITman
Member
**


Hello!

Posts: 76
Gender: female
Re: Redefine fields...
Reply #1 - 11/11/03 at 06:08:22
 
Anyone? Smiley
 
Guess I'll just try to do them by hand...   cry
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Redefine fields...
Reply #2 - 11/11/03 at 08:10:22
 
You need to be REALLY careful changing data structures because it potentially makes you an "orphan" in terms of any future updates.  If possible, the first choice would be to take advantage of existing unused fields and files.  Second, add additional files to the database that have the structure you need and can be linked to existing files, and finally as a last resort, change the structure of existing files.
 
There is a TAS6 program that runs the first time you load Evo that reads the DBA data dictionary and constructs the codebase dictionary but my understanding is, it already has the structure of the files and fields defined and is only reading FILELOC.B to establish the paths to the different companies.  There is a "clean" set of DBF/MDX files available at http://www.istechsupport.com/datadict.asp
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
ITman
Member
**


Hello!

Posts: 76
Gender: female
Re: Redefine fields...
Reply #3 - 11/11/03 at 11:57:07
 
Yes.  I created an Inventory Tracking System for the IT department here and copied the RWN, SRC, and DFM files over.  I forgot to export the FD's and import them on the server.  It is a completly seperate file itassets.c and all pretty much self contained.  I had to just recreate the fields, took the better half of the day but all appears to work ok now.
 
Thanks
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print