Welcome, Guest. Please Login.
05/18/25 at 14:08:24
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
Modify Forms (Read 2154 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Modify Forms
Reply #15 - 02/07/07 at 04:48:01
 
Quote from kkmfg   on 02/06/07 at 19:04:00:
So why don't we add the descriptions right in there rather than waste time with an external file?

If it were going to be only in one place I'd rather have it in an external file so I can search the entire database at once, rather than first trying to guess which table it's in and then looking through all the fields. However, it would be nice to have the description in the database (as some already are).
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 375
Gender: male
Re: Modify Forms
Reply #16 - 02/07/07 at 05:13:35
 
It would be difficult to do a search across the whole database for what you are looking for regardless. If you search for unit on hand you'll find it in 20 places and you'll still have to guess which one you really want. Also, unless we come up with a standard method of description you will be hard pressed to guess what someone has used as the description of a field. I would think that it would be much more valuable to have the information associated with the fields themselves in the database so that one could figure out what a field is when they need it most. That is, when they are building a report or screen. Even then, I could see the use for at least a list of the tables with descriptions in an external file so that looking up the right table to use is easier. On that note, it might be nice to get a list of which reports reference which tables. I would think that that would be the most important information to have external to the database.
 
Still, I don't mean to suggest that I'm opposed to having the info externally. It would certainly be good to have the info in both internal and external form. I wonder how easy it is to programatically insert the field descriptions into BTrieve. That way people could work on the descriptions in the excel file and then import them into the database. That way we've got it both ways.  
 
Quote from David Waldmann   on 02/07/07 at 04:48:01:

If it were going to be only in one place I'd rather have it in an external file so I can search the entire database at once, rather than first trying to guess which table it's in and then looking through all the fields. However, it would be nice to have the description in the database (as some already are).

Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Modify Forms
Reply #17 - 02/07/07 at 05:17:31
 
Quote from David Waldmann   on 02/07/07 at 04:48:01:

If it were going to be only in one place I'd rather have it in an external file so I can search the entire database at once, rather than first trying to guess which table it's in and then looking through all the fields. However, it would be nice to have the description in the database (as some already are).

 
Let me give a hearty "me too" for the consolidated external repository. Having it in both places is a great goal, but the single table is very handy.  
 
On the other hand, if we have the descriptions attached to the fields, and we have a simple script that will generate a table at will... that's a lot of work, but at least there would only be one, master repository of knowledge.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Modify Forms
Reply #18 - 02/07/07 at 05:22:58
 
Quote from kkmfg   on 02/07/07 at 05:13:35:
Still, I don't mean to suggest that I'm opposed to having the info externally. It would certainly be good to have the info in both internal and external form. I wonder how easy it is to programatically insert the field descriptions into BTrieve. That way people could work on the descriptions in the excel file and then import them into the database. That way we've got it both ways.

 
Wouldn't the opposite be easier? Get the descriptions into the tables and then extract it into a table.  
 
The other point you bring up is key: having a list of what tables/fields are used for various reports and even screens in DBA/Evo would be... unlikely. Um, no, I mean that it would be extremely useful!
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Modify Forms
Reply #19 - 02/07/07 at 05:29:43
 
Quote from NovaZyg   on 02/06/07 at 13:07:01:
We are working on a new Evo~ERP web site, that will have a place to share user programs like RTM's and Crystal and access or whatever.

 
I gave this some more thought overnight and am kind of excited about it. There are some really talented folks contributing to this forum, but running from pillar to post to keep up with the useful bits, and then having private threads and emailing files back and forth gets confusing and slows down progress. The separate area for hacks is exactly what the doctor ordered. It could really lead to a better Evo for everyone, especially half-baked hackers like me who can almost come up with good utilities, but need the occasional boost.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Modify Forms
Reply #20 - 02/15/07 at 10:29:59
 
Count us in on the group effort to get it updated.  We desperately need it ourselves!
 
Val
Back to top
 
 

Val Feehan
  IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 375
Gender: male
Re: Modify Forms
Reply #21 - 02/15/07 at 10:46:28
 
Quote from GasGiant   on 02/07/07 at 05:22:58:


Wouldn't the opposite be easier? Get the descriptions into the tables and then extract it into a table.

 
Yes, I suppose that way could be easier.
 
Quote:

The other point you bring up is key: having a list of what tables/fields are used for various reports and even screens in DBA/Evo would be... unlikely. Um, no, I mean that it would be extremely useful!

 
Well, we can all have hopes and dreams. Whether they are realistic is beside the point. Wink
Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Modify Forms
Reply #22 - 02/15/07 at 11:05:24
 
Quote:
BTrieve (terrible as it is) still has support for putting a description to each field of each database file. This would allow the descriptions of fields to be stored right in the database itself so that in the screen and report editors the descriptions will pop up right along with all of the fields. So why don't we add the descriptions right in there rather than waste time with an external file? Wouldn't it make sense to store the descriptions right in where they'd be of the most use? Someone at DBA has already put some field descriptions in but very few are filled in.

 
If the description fields were populated as suggested, it  would be just short of trivial to create a Crystal Report (or Access, Excel, anything that can access the database with ODBC ...)  to generate a flat text file for those that want it.   Grin
 
This would allow us to separate the content (descriptions) from the presentation (database lookup, flat file).  Doing so keeps us from constantly trying to synchronize everything.  Doesn't it make sense to use a 'DATABASE' to document our databases   Tongue
 
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print