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


Pages: 1
Send Topic Print
Maintain Database Fields Display (Read 493 times)
chrisbowden
Full Member
***


Doing it all with
DBA.

Posts: 106
Gender: male
Maintain Database Fields Display
05/14/07 at 15:28:12
 
I was looking for the Parent Material Costs in Maintain Database in Evo.  After 45 minutes of comparing fields to the DBA File Name and Field Description spreadsheet, I felt certain that what I was looking for was in MTICMSTR.  Switched from Evo's Maintain Database to Classic's Maintain Database and found the data in field RCOST_2.
 
In Classic's Maintain Database, RCost is showing as 15 separate fields labeled RCOST_1 thru RCOST_15 like below:

 
However, for some reason, Evo's Maintain Database is only listing 1 single column labeled RCost:
.
 
This results in a column which for me is all zero's:

 
Any idea why this is and can it be fixed so that I can use Evo's Maintain Database to see all of the table's fields?
 
Chris
Back to top
 
 

Chris Bowden
Amstar Foods LLC
ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09
Pervasive 2000i SP3 / XP Pro
  IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Maintain Database Fields Display
Reply #1 - 05/15/07 at 06:44:35
 
MTIC.PROD.RCOST is an array. And the powers that be...(not us the language developer)  have changed Maintain Database (back in 2004) so now you need to enable EDIT and then click on the field, a lookup button will appear in this field and then you can click and see the contents of the array.  
 
Don't shoot me, I am just the messenger on this one..
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Maintain Database Fields Display
Reply #2 - 05/15/07 at 07:04:21
 
Wow! What a great, user-friendly idea. I wish I'd thought of that  Roll Eyes
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
chrisbowden
Full Member
***


Doing it all with
DBA.

Posts: 106
Gender: male
Re: Maintain Database Fields Display
Reply #3 - 05/19/07 at 12:25:15
 
Thanks for the info, Allen!
 
And Colin, you're absolutely correct--what a great, user-friendly idea!  I think the people who thought of this helped design much of Next Gen.
 
Well, for all of you who pooh-pooh Classic, at least our MDB is better!   Tongue   Ha!
 
Thanks again for your help, guys!
 
Chris
Back to top
 
 

Chris Bowden
Amstar Foods LLC
ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09
Pervasive 2000i SP3 / XP Pro
  IP Logged
Pages: 1
Send Topic Print