Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where is website stored with # signs,not contsupref !!

Status
Not open for further replies.

petrovlis

Programmer
Jan 15, 2002
114
NL
Upon importing I have 50 percent websites (5000) in Goldmine
dbase 6.7 version which are NOT all in the Consupref field
but somewhere else if the website contains some # signs:
like:
is in the correct place.
but
in NOT in consupref field,but
somewhere else...

I can do it by hand in the Goldmine Website field,rt-click search website and then among some I find the website with
# signs. But checking with Goldbox/BR7 cannot trace the field where the ## web site is stored.
I made dummy "add address" with but cannot find it in contsupref, but yeas in the standard
underlined Website default field.
I need top make a filter for only those ## website,how ??

Thanks
William
 
create a sql query to see if you can find them.

select*
from contsupp
where rectype ='P' and contact like 'Web%'


see if you get them now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top