Part Description Search Criteria

Yahoo Archive
1
I must have alot to learn yet about Vantage... because I'm not sure
how to even attempt this! Could you maybe contact me offline at
mhow@... so I could ask you a few questions?

Thanks!

--- In vantage@yahoogroups.com, "Jeff Lewis" <jeff@...> wrote:
>
> You could update the records using the Procedure Editor --
>
> DEF VAR cntr AS INTEGER NO-UNDO.
> DEF VAR strt AS INTEGER FORMAT ">>9" NO-UNDO.
> DEF VAR pDescNew Like Part.PartDescription no-undo.
>
> ON WRITE OF Part OVERRIDE DO: END.
>
> For each Part where Part.Company = "YourCompany"
> EXCLUSIVE-lock:
>
> strt = R-INDEX((Part.PartDescription),",HH,").
> IF (strt>0) THEN Do:
> pDescNew = REPLACE(Part.PartDescription,",HH,"," HH ").
>
> /* DISPLAY Part.PartDescription FORMAT "x(50)" */
> /* pDescNew FORMAT "x(50)" */
> /* with 2 col. */
>
> ASSIGN Part.PartDescription = pDescNew.
> cntr = cntr + 1.
> END.
> END.
>
> DISPLAY cntr.
>
> This code does it live and on the fly. I usually take the more
> conservative approach of exporting out a list, modifying it off-
line,
> then cycling back thru the database only updating records which
have not
> changed.
>
> Jeff Lewis
>
>
2
Does anyone have any experience in writing their own "search" in
Vantage that would narrow down criteria? We find it very cumbersome
to search using "where part contains". We understand that we can put
several criteria on line one, which means "and"... and if we put
criteria on different lines that means "or". We've also played with
the * (wildcard) key. We are having issues finding things with commas
in them. For example:

CAPSCREW,HH,1/4-20UNCx3.25 GR8

We can't get the search to return this if we use the criteria

Capscrew 1/4

I think this is because of the comma (we brought over thousands of
parts from another system this way).

Any ideas? Could a BAQ be written that would work differently?
3
Hi,

What version of vantage are you using? I have in past used (v6.1)
some progress code to execute a report builder which will list the
parts using wildcards. Not sure if this is what you mean, if it is
there some code on this board.



--- In vantage@yahoogroups.com, "how2wow" <mhow@...> wrote:
>
> Does anyone have any experience in writing their own "search" in
> Vantage that would narrow down criteria? We find it very
cumbersome
> to search using "where part contains". We understand that we can
put
> several criteria on line one, which means "and"... and if we put
> criteria on different lines that means "or". We've also played
with
> the * (wildcard) key. We are having issues finding things with
commas
> in them. For example:
>
> CAPSCREW,HH,1/4-20UNCx3.25 GR8
>
> We can't get the search to return this if we use the criteria
>
> Capscrew 1/4
>
> I think this is because of the comma (we brought over thousands of
> parts from another system this way).
>
> Any ideas? Could a BAQ be written that would work differently?
>
4
We are on 8.00.807.

--- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@...>
wrote:
>
> Hi,
>
> What version of vantage are you using? I have in past used (v6.1)
> some progress code to execute a report builder which will list the
> parts using wildcards. Not sure if this is what you mean, if it is
> there some code on this board.
>
>
>
> --- In vantage@yahoogroups.com, "how2wow" <mhow@> wrote:
> >
> > Does anyone have any experience in writing their own "search" in
> > Vantage that would narrow down criteria? We find it very
> cumbersome
> > to search using "where part contains". We understand that we
can
> put
> > several criteria on line one, which means "and"... and if we put
> > criteria on different lines that means "or". We've also played
> with
> > the * (wildcard) key. We are having issues finding things with
> commas
> > in them. For example:
> >
> > CAPSCREW,HH,1/4-20UNCx3.25 GR8
> >
> > We can't get the search to return this if we use the criteria
> >
> > Capscrew 1/4
> >
> > I think this is because of the comma (we brought over thousands
of
> > parts from another system this way).
> >
> > Any ideas? Could a BAQ be written that would work differently?
> >
>
5
You could update the records using the Procedure Editor --

DEF VAR cntr AS INTEGER NO-UNDO.
DEF VAR strt AS INTEGER FORMAT ">>9" NO-UNDO.
DEF VAR pDescNew Like Part.PartDescription no-undo.

ON WRITE OF Part OVERRIDE DO: END.

For each Part where Part.Company = "YourCompany"
EXCLUSIVE-lock:

strt = R-INDEX((Part.PartDescription),",HH,").
IF (strt>0) THEN Do:
pDescNew = REPLACE(Part.PartDescription,",HH,"," HH ").

/* DISPLAY Part.PartDescription FORMAT "x(50)" */
/* pDescNew FORMAT "x(50)" */
/* with 2 col. */

ASSIGN Part.PartDescription = pDescNew.
cntr = cntr + 1.
END.
END.

DISPLAY cntr.

This code does it live and on the fly. I usually take the more
conservative approach of exporting out a list, modifying it off-line,
then cycling back thru the database only updating records which have not
changed.

Jeff Lewis


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brychanwilliams
Sent: Wednesday, April 12, 2006 10:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Description Search Criteria


Hi,

What version of vantage are you using? I have in past used (v6.1)
some progress code to execute a report builder which will list the
parts using wildcards. Not sure if this is what you mean, if it is
there some code on this board.



--- In vantage@yahoogroups.com, "how2wow" <mhow@...> wrote:
>
> Does anyone have any experience in writing their own "search" in
> Vantage that would narrow down criteria? We find it very
cumbersome
> to search using "where part contains". We understand that we can
put
> several criteria on line one, which means "and"... and if we put
> criteria on different lines that means "or". We've also played
with
> the * (wildcard) key. We are having issues finding things with
commas
> in them. For example:
>
> CAPSCREW,HH,1/4-20UNCx3.25 GR8
>
> We can't get the search to return this if we use the criteria
>
> Capscrew 1/4
>
> I think this is because of the comma (we brought over thousands of
> parts from another system this way).
>
> Any ideas? Could a BAQ be written that would work differently?
>







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]