Address Book

[dhendin]

I have a blank address # in the address book. It is the first entry ,it looks like nothing is in the line of the grid , when I select it the address # is greyed out with no number in it , I try and put a name in there when i go OK. I get the error message Parent # invalid. Because of this , the word search will not work (P01BDWRD) Any suggestions how to get that first line out for good ?

 

[bwilkinson]

Use your database tool and go directly in to the table and delete the
record. for SQL use Enterprise Manager, i dont know what it is for the other
databases.

-Brian

Brian Wilkinson
Senior Technical Specialist
Quickie Manufacturing
Phone: 856-829-7900 x143
E-Mail: [email protected]




William “Brian” Wilkinson
Quickie Manufacturing
[email protected]
856-829-7900 x143

 

[DBohner-(db)]

What is your OS/DB? We can help you back door, if we know a little more...



Daniel Bohner | JDE P/A III | Freelance-Web/Photo
www.ExistingLight.Net | [email protected]
JDE XE | SP18 | AS/400 | V5R1

 

[got_to_love_jde]

Hi dhendin,

I think this will depend upon your system configuration which you did not include. I would use Access to do a back door link to my SQl database and delete it there. On an AS400 you could use DFU or DBU. On Oracle ? , can't help you.
I would concentrate in how you got that blank entry in there.
dave

 

[dhendin]

Thanks

Diane Hendin
One World Administrator
Macdon Industries Ltd.
(204) 831-4412
Fax # 832-7749
www.macdon.com

 

[riccomm]

Sounds like you have a corrupt record...

Only way of deleting is through a database utility..

Oracle I use SQL Plus
AS400 either DFU or SQL
SQL Server do an sql delete command

It would be good to check if you have any similar records in the other
address book files with this number..

I would check the F0116 as this holds the main address book information,
but if it complaining about parent number then I would look at the F0150