ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> ROHS Field
http://www.istechforum.com/YaBB.pl?num=1581618072

Message started by Keith on 02/13/20 at 11:21:12

Title: ROHS Field
Post by Keith on 02/13/20 at 11:21:12

Hi - We're using a very old version of DBA Classic 2004.1 IS update 5/8/06, I was asked to create a report listing items and the associated ROHS (Y/N) field. I understand that the ROHS flag is in DPTNT position "4", but what I am seeing on some items is a "blank" in the extracted data AND when viewing in maintain database but a Y when viewing the part in IN-A and IN-B.

How can IN-A show an entry when there is no entry in the database?

Is this an indexing issue?

Thanks

Keith

Title: Re: ROHS Field
Post by Dennis Wilkinson on 03/19/20 at 05:23:25

Kieth, what program are you using to extract the specific data?

Title: Re: ROHS Field
Post by Keith on 03/19/20 at 08:22:42

Hey Dennis - Thanks for the reply, using old crystal reports 8.5, the thing is that it seems crystal is pulling the correct database info (Y/N or blank in crystal report and "maintain database" BKICMSTR - DPTNT) but if I look at the ROHS field in IN-A/IN-B it will show an entry? Really weird....

Where else could IN-A/B be pulling this from?

Keith

Title: Re: ROHS Field
Post by Dennis Wilkinson on 03/19/20 at 09:05:24

If using crystal, you need to create a substr field, something like "SUBSTR(BKIC_PROD_DPTNT,4,1)". You only want to read position 4 of the field DPTNT.

Title: Re: ROHS Field
Post by Keith on 03/19/20 at 09:30:35

Thanks Dennis!!!

Thought I was losing it;)

Stay Healthy!

Keith