Welcome, Guest. Please Login.
04/28/24 at 07:51:59
News:
Home Help Search Login


Pages: 1
Send Topic Print
Field Descriptions (Read 1126 times)
FPreuett
Ex Member



Field Descriptions
03/20/03 at 08:00:04
 
Don't know if this goes here or in general, but here goes.
I am tryin to create a report in CR8.  I can access DBA and get to the files.  I have the listing of files from the help files.  My question is...is there any way in dba to get the field name when you are in the field?  IE. in inventory entry, I get to the reorder level field, is there any way to find out what file/field that is?
 
Thanks,
  Fred
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Field Descriptions
Reply #1 - 03/20/03 at 08:25:39
 
In DBA, in the Help is a list of file names by module and then UT-H will list the fields in each file but many of the field names are pretty cryptic.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
FPreuett
Ex Member



Re: Field Descriptions
Reply #2 - 03/20/03 at 08:41:17
 
A lot of them I can find by browsing the data and finding them that way, but some of them may be in a different file (crosslinked) .
Back to top
 
 
  IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Field Descriptions
Reply #3 - 03/20/03 at 11:21:39
 
With credit to David Waldmann:
 
Get the DBA Source Code from the CD. I have copied it to a folder on my hard drive called DBA Source Code, with a shortcut to that folder on my desktop. Don't be afraid of the source code - you can't break DBA with it unless you change it, recompile it, and replace the original files in the DBAMFG folder with it.
 
Each of the menu items in DBA runs a program which correspond to the menu name, prefixed with a "BK" and an extension of "RUN". The source code files are named the same way with the exception of the extension, which is "SRC". For instance, AP-B runs the program named bkAPB.run, so open the Source Code file named bkAPB.src.
 
The first time you try to open one of the files you will most likely get an "Open this file with what application?" Dialog box. Select Notepad (unless you really want to use your word processor), and make sure the "always use this application for this file type?" is checked off so you don't have to go through this every time (you could also rename all the source code files with an extension of TXT if for some reason you have other SRC files you open with another application).
 
Once the file is open scroll all the way down to the bottom. The last section will consist primarily of a table-like list of data looking something like this:
 
\FIELDS
BKAP.INVL.CODE   0 21  3  0  0 0   10    0    0AYRGBKAPINVLNNN    0
BKAP.VENDNAME   0 48  3  0  0 0   30    0    0ANRGBKAPVENDNNN    0
BKAP.INVL.NUM     0 21  4  0  0 0   10    0    0AYRGBKAPINVLNNN    0
INV.DATE                              0 48  4  0  0 0    8    0    0S RGMEMORY  NNN    0
BKAP.INVL.TYPED  0 21  5  0  0 0   10    0    0AYRGBKAPINVLNNN    0
BKAP.INVL.DATE    0 48  5  0  0 0    8    0    0DNRGBKAPINVLNNN    0
 
(if the above list looks funny, make sure that the display window is wide enough to display each full line on one line)
 
This is a list of all the information required to run the menu item. The first item is the field name, followed by a bunch of numbers that you don't need to worry about, and then the file name somewhat hidden in the middle of some other gobbledygook. In the example above I've highlighted the file names, and you can see two different files plus one called "Memory". Any field in "Memory" or "Defined" which is another one you may see occasionally are not actual fields in the file, but information that you enter on the screen, or calculated by DBA with another program.
 
So you sometimes must link two or more files to get all the information, or you might have to make a formula to figure out some others, but most of the information is available this way.
 
And of course the actual file name in the DBA folder has an extension. If you are using the default company the extension is just "B". If you've created a new company number 13 then the extension would be "B13", etc.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
Pages: 1
Send Topic Print