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


Pages: 1
Send Topic Print
ROHS Field (Read 1114 times)
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
ROHS Field
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
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Dennis Wilkinson
Full Member
***


Life is Good :o)

Posts: 148
Gender: male
Re: ROHS Field
Reply #1 - 03/19/20 at 05:23:25
 
Kieth, what program are you using to extract the specific data?
Back to top
 
 

Dennis Wilkinson
IS Tech Support Contractor
dwilkinson@istechsupport.com

IS Tech Support Update 2022.1
PSQL Workgroup, Zen 14
Windows 11, Home Premium
  IP Logged
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
Re: ROHS Field
Reply #2 - 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
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Dennis Wilkinson
Full Member
***


Life is Good :o)

Posts: 148
Gender: male
Re: ROHS Field
Reply #3 - 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.
Back to top
 
 

Dennis Wilkinson
IS Tech Support Contractor
dwilkinson@istechsupport.com

IS Tech Support Update 2022.1
PSQL Workgroup, Zen 14
Windows 11, Home Premium
  IP Logged
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
Re: ROHS Field
Reply #4 - 03/19/20 at 09:30:35
 
Thanks Dennis!!!
 
Thought I was losing it;)
 
Stay Healthy!
 
Keith
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Pages: 1
Send Topic Print