VB Forms

Yahoo Archive
21
Thanks, Troy,

In the set command i.e,
setDateValue("orderrel.needbydate.scrvalue":U,Date-Val). , Where did you
find that and how did you know the syntax, what to pass, etc?



[Non-text portions of this message have been removed]
22
Sarah,
A lot of this was just trying and trying and looking through the help
files. But here are some clues: The file "e:\epic51\vantage\vbp\vb.i"
which is called by the Progress program I sent you, has the names of the
functions that can be called and sent back to the VBForm. Also, there is a
sample progress program in the \VBP folder you can look at called VBSample.p
that helped me start looking.
To find the Vantage scrname of a filed, you can sometimes go to the
window in Vanage with the information you are looking for and right-click in
the open space of the window. This will show you the screen values of some
of the fields used to populate that screen. That is where I got the
orderrel.needbydate.scrvalue part of the formula. In my case, the
setdatevalue function actually populates the NeedbyDate in the Vantage
window with the results of my calculation in the VBForm.

There have also been some samples sent through the onelist. Look under the
"files" section in the Progress folder.

Here is a clip of the functions available in the vb.i program....

FUNCTION getStringValue RETURNS CHARACTER
( INPUT fld_name AS CHARACTER ) IN VBFunctions.
FUNCTION getIntegerValue RETURNS INTEGER
( INPUT fld_name AS CHARACTER ) IN VBFunctions.
FUNCTION getDateValue RETURNS DATE
( INPUT fld_name AS CHARACTER ) IN VBFunctions.
FUNCTION getDecimalValue RETURNS DECIMAL
( INPUT fld_name AS CHARACTER ) IN VBFunctions.
FUNCTION getLogicalValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER ) IN VBFunctions.
FUNCTION setStringValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER,INPUT fld_value AS CHARACTER ) IN VBFunctions.
FUNCTION setIntegerValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER,INPUT fld_value AS INTEGER ) IN VBFunctions.
FUNCTION setDateValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER,INPUT fld_value AS DATE ) IN VBFunctions.
FUNCTION setDecimalValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER,INPUT fld_value AS DECIMAL ) IN VBFunctions.
FUNCTION setLogicalValue RETURNS LOGICAL
( INPUT fld_name AS CHARACTER,INPUT fld_value AS LOGICAL ) IN VBFunctions.


Troy Funte
Liberty Electronics


----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Friday, May 17, 2002 12:31 PM
Subject: RE: [Vantage] VB Forms


Thanks, Troy,

In the set command i.e,
setDateValue("orderrel.needbydate.scrvalue":U,Date-Val). , Where did you
find that and how did you know the syntax, what to pass, etc?



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
23
Troy,

Thanks so much for the help. When I try the program from the VB Forms,
nothing happens and I don't know why. I saved it in my Z:\Vantage
directory. When I compile it, I get the error "Mismatched number of
parameters passed to procedure Z:\Vantage\P08440r.ped. (3234). But, I have
tried searching the help and cannot find any info on what is wrong. I looked
at the vbsample.p and it looks right to me. Wondering if you could take a
quick look and see if you can spot the problem?



/**************************************************************************
_Name: Quote_Total.p
_Description: This program is designed to total the 8 number fields from the
Quote Detail VB Form to create a total.
_Created By: Sarah Vareschi (modified from Troy Funte's example) */

/* include vbp/vb.i so VantageBasic functions are accessible. */ {vbp/vb.i}

/* Here define your own variables */
DEFINE VARIABLE Total-Val AS DECIMAL NO-UNDO.


/* do the calculation (number1 + number2 + number3 + number4 + number5 +
number6 + number7 + number8) */
Total-Val = getDecimalValue("QuoteDtl.NUMBER-FIELD_1") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_2") + getDecimalValue("QuoteDtl.
NUMBER-FIELD_3") + getDecimalValue("QuoteDtl.NUMBER-FIELD_4") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_5") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_6") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_7") +
getdecimalValue("QuoteDtl.NUMBER-FIELD_8").

/* Set the screen value of QuoteDtl.NUMBER-FIELD_9 to be the Total-Val
variable. */
setDecimalValue("QuoteDtl.NUMBER-FIELD_9.scrvalue":U,Total-Val).

RETURN.
/* end of Quote_Total.p routine */



[Non-text portions of this message have been removed]
24
Sarah,
After a quick look... try taking the 'QuoteDtl.' (QuoteDtl.) part off of each of the "get" statements, leaving just the field name. See if that works. for instance use: getDecimalValue("NUMBER-FIELD_1")


Troy Funte
Liberty Electronics


----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Friday, May 17, 2002 1:03 PM
Subject: RE: [Vantage] VB Forms


Troy,

Thanks so much for the help. When I try the program from the VB Forms,
nothing happens and I don't know why. I saved it in my Z:\Vantage
directory. When I compile it, I get the error "Mismatched number of
parameters passed to procedure Z:\Vantage\P08440r.ped. (3234). But, I have
tried searching the help and cannot find any info on what is wrong. I looked
at the vbsample.p and it looks right to me. Wondering if you could take a
quick look and see if you can spot the problem?



/**************************************************************************
_Name: Quote_Total.p
_Description: This program is designed to total the 8 number fields from the
Quote Detail VB Form to create a total.
_Created By: Sarah Vareschi (modified from Troy Funte's example) */

/* include vbp/vb.i so VantageBasic functions are accessible. */ {vbp/vb.i}

/* Here define your own variables */
DEFINE VARIABLE Total-Val AS DECIMAL NO-UNDO.


/* do the calculation (number1 + number2 + number3 + number4 + number5 +
number6 + number7 + number8) */
Total-Val = getDecimalValue("QuoteDtl.NUMBER-FIELD_1") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_2") + getDecimalValue("QuoteDtl.
NUMBER-FIELD_3") + getDecimalValue("QuoteDtl.NUMBER-FIELD_4") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_5") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_6") +
getDecimalValue("QuoteDtl.NUMBER-FIELD_7") +
getdecimalValue("QuoteDtl.NUMBER-FIELD_8").

/* Set the screen value of QuoteDtl.NUMBER-FIELD_9 to be the Total-Val
variable. */
setDecimalValue("QuoteDtl.NUMBER-FIELD_9.scrvalue":U,Total-Val).

RETURN.
/* end of Quote_Total.p routine */



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


Yahoo! Groups Sponsor
ADVERTISEMENT

Height: 4 5 6 7 ft 0 1 2 3 4 5 6 7 8 9 10 11in
Weight:
Sex: F M






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

Thanks so much for all your help, it's working now! I tried so many things,
and I finally put in everything i.e.
getDecimalValue("QuoteDtl.NUMBER-FIELD_1.scrvalue":U) and it's working.
Without your help and sample, I would never have gotten there! Thanks!



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

I'm glad you got it working. I had to fiddle and fiddle with settings to get it working also. It opens a whole realm of possibilities though, doesn't it?

Troy
----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Friday, May 17, 2002 2:15 PM
Subject: RE: [Vantage] VB Forms


Troy,

Thanks so much for all your help, it's working now! I tried so many things,
and I finally put in everything i.e.
getDecimalValue("QuoteDtl.NUMBER-FIELD_1.scrvalue":U) and it's working.
Without your help and sample, I would never have gotten there! Thanks!



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
27
I agree, opens lots of new possibilities! Thanks, again.



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

I have to attach operator instructions with every part. and then have
them printed with every job.

Is it possible to do that?

I have create the vb form button to attach the file in part table.
now i want that value should go automatically to Job header vbform
charactor field, and we can print directly from there all the time
instead of attach them for every single job.


Any help
29
Perhaps consider to put the text into the Job Traveler line comments in the Part Router. We do that and it works very well for static instructions. For variable info, all you have to do is modify prior to printing the Traveler.

Hope this helps.

Rick Gors
----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Wednesday, May 22, 2002 5:53 PM
Subject: [Vantage] VB Forms


Hi

I have to attach operator instructions with every part. and then have
them printed with every job.

Is it possible to do that?

I have create the vb form button to attach the file in part table.
now i want that value should go automatically to Job header vbform
charactor field, and we can print directly from there all the time
instead of attach them for every single job.


Any help


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
30
Thanks for reply

But isn't it possible to pull that directly from part table because
it is different of every part.

Any way of doing that?
31
HI

Could anyone please get me a code to pull vbform value from part
table to vbform value in jobhead table.

I know it is possible i have seen somewhwre but it os just not
working for me.
I will really appreciate that.
32
Sharma,
I have not done it before, but it would seem that you could use a Progress routine which would pull in the appropriate Part number from the JobHead table, and then use that field to filter out the data you need directly from the Part table.

There is a sample program in the vbp folder, and a list of function calls in the vb.i file in that same folder. You would use one of the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum = getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the PartNumber.
Then use progress language to Filter the Part Table.

For instance;
FOR EACH Part
WHERE Part.Company = 'yourcompany'
AND Part.PartNum = JobPartNum:

Then you should have the field you need from the Part Table available.

The hard part for me is knowing the exact syntax for the 'getstringvalue' function. Sometimes you need the part that says 'scrvalue' and sometimes you don't.

Hopefully this will put you on the right path to figure something out.

Please let us know how you make out.

Troy Funte
Liberty Electronics

----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Thursday, May 23, 2002 1:16 PM
Subject: [Vantage] Re: VB Forms




HI

Could anyone please get me a code to pull vbform value from part
table to vbform value in jobhead table.

I know it is possible i have seen somewhwre but it os just not
working for me.
I will really appreciate that.




Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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

I tried , my syntax is correct for the program(suggested by you) but
when i run the program it gives me an error written below.i am really
not sure what to do
Any comments

Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped.




--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Sharma,
> I have not done it before, but it would seem that you could use
a Progress routine which would pull in the appropriate Part number
from the JobHead table, and then use that field to filter out the
data you need directly from the Part table.
>
> There is a sample program in the vbp folder, and a list of function
calls in the vb.i file in that same folder. You would use one of
the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum =
getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the PartNumber.
> Then use progress language to Filter the Part Table.
>
> For instance;
> FOR EACH Part
> WHERE Part.Company = 'yourcompany'
> AND Part.PartNum = JobPartNum:
>
> Then you should have the field you need from the Part Table
available.
>
> The hard part for me is knowing the exact syntax for
the 'getstringvalue' function. Sometimes you need the part that
says 'scrvalue' and sometimes you don't.
>
> Hopefully this will put you on the right path to figure something
out.
>
> Please let us know how you make out.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@y...
> Sent: Thursday, May 23, 2002 1:16 PM
> Subject: [Vantage] Re: VB Forms
>
>
>
>
> HI
>
> Could anyone please get me a code to pull vbform value from part
> table to vbform value in jobhead table.
>
> I know it is possible i have seen somewhwre but it os just not
> working for me.
> I will really appreciate that.
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]
34
HI Troy

I tried , my syntax is correct for the program(suggested by you) but
when i run the program it gives me an error written below.i am really
not sure what to do
Any comments

Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped.




--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Sharma,
> I have not done it before, but it would seem that you could use
a Progress routine which would pull in the appropriate Part number
from the JobHead table, and then use that field to filter out the
data you need directly from the Part table.
>
> There is a sample program in the vbp folder, and a list of function
calls in the vb.i file in that same folder. You would use one of
the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum =
getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the PartNumber.
> Then use progress language to Filter the Part Table.
>
> For instance;
> FOR EACH Part
> WHERE Part.Company = 'yourcompany'
> AND Part.PartNum = JobPartNum:
>
> Then you should have the field you need from the Part Table
available.
>
> The hard part for me is knowing the exact syntax for
the 'getstringvalue' function. Sometimes you need the part that
says 'scrvalue' and sometimes you don't.
>
> Hopefully this will put you on the right path to figure something
out.
>
> Please let us know how you make out.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@y...
> Sent: Thursday, May 23, 2002 1:16 PM
> Subject: [Vantage] Re: VB Forms
>
>
>
>
> HI
>
> Could anyone please get me a code to pull vbform value from part
> table to vbform value in jobhead table.
>
> I know it is possible i have seen somewhwre but it os just not
> working for me.
> I will really appreciate that.
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]
35
Sharma,
Why don't you pass on your code here on the list by pasting it to an email and maybe someone will pick up something that isn't quite right. I suspect that it's the syntax of the 'getstringvalue' function. Try various forms of the field name to begin with.

Troy Funte
Liberty Electronics

----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Friday, May 24, 2002 8:41 AM
Subject: [Vantage] Re: VB Forms


HI Troy

I tried , my syntax is correct for the program(suggested by you) but
when i run the program it gives me an error written below.i am really
not sure what to do
Any comments

Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped.




--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Sharma,
> I have not done it before, but it would seem that you could use
a Progress routine which would pull in the appropriate Part number
from the JobHead table, and then use that field to filter out the
data you need directly from the Part table.
>
> There is a sample program in the vbp folder, and a list of function
calls in the vb.i file in that same folder. You would use one of
the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum =
getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the PartNumber.
> Then use progress language to Filter the Part Table.
>
> For instance;
> FOR EACH Part
> WHERE Part.Company = 'yourcompany'
> AND Part.PartNum = JobPartNum:
>
> Then you should have the field you need from the Part Table
available.
>
> The hard part for me is knowing the exact syntax for
the 'getstringvalue' function. Sometimes you need the part that
says 'scrvalue' and sometimes you don't.
>
> Hopefully this will put you on the right path to figure something
out.
>
> Please let us know how you make out.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@y...
> Sent: Thursday, May 23, 2002 1:16 PM
> Subject: [Vantage] Re: VB Forms
>
>
>
>
> HI
>
> Could anyone please get me a code to pull vbform value from part
> table to vbform value in jobhead table.
>
> I know it is possible i have seen somewhwre but it os just not
> working for me.
> I will really appreciate that.
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
36
Actually when i check the syntax, it gives me a message the sysntax
is correct.
Below is the code i have written.

{e:\epic50\vantage\VBP/part.i}

/* Here define your own variables */
DEFINE VARIABLE jobpartnum AS char NO-UNDO.

/* do the calculation */
jobpartnum = getStringValue("jobhead.partnum.SCRVALUE").
DISPLAY jobpartnum.

/*FOR each Part Where part.company = "tri-star":
and part.partnum = jobpartnum

SET jobhead.char-field_1.scrvalue=part.char-field_1.scrvalue

END.*/
RETURN.




--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Sharma,
> Why don't you pass on your code here on the list by pasting it
to an email and maybe someone will pick up something that isn't quite
right. I suspect that it's the syntax of the 'getstringvalue'
function. Try various forms of the field name to begin with.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: sharma_nalini
> To: vantage@y...
> Sent: Friday, May 24, 2002 8:41 AM
> Subject: [Vantage] Re: VB Forms
>
>
> HI Troy
>
> I tried , my syntax is correct for the program(suggested by you)
but
> when i run the program it gives me an error written below.i am
really
> not sure what to do
> Any comments
>
> Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped.
>
>
>
>
> --- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> > Sharma,
> > I have not done it before, but it would seem that you could
use
> a Progress routine which would pull in the appropriate Part
number
> from the JobHead table, and then use that field to filter out the
> data you need directly from the Part table.
> >
> > There is a sample program in the vbp folder, and a list of
function
> calls in the vb.i file in that same folder. You would use one of
> the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum =
> getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the
PartNumber.
> > Then use progress language to Filter the Part Table.
> >
> > For instance;
> > FOR EACH Part
> > WHERE Part.Company = 'yourcompany'
> > AND Part.PartNum = JobPartNum:
> >
> > Then you should have the field you need from the Part Table
> available.
> >
> > The hard part for me is knowing the exact syntax for
> the 'getstringvalue' function. Sometimes you need the part that
> says 'scrvalue' and sometimes you don't.
> >
> > Hopefully this will put you on the right path to figure
something
> out.
> >
> > Please let us know how you make out.
> >
> > Troy Funte
> > Liberty Electronics
> >
> > ----- Original Message -----
> > From: sharma_nalini
> > To: vantage@y...
> > Sent: Thursday, May 23, 2002 1:16 PM
> > Subject: [Vantage] Re: VB Forms
> >
> >
> >
> >
> > HI
> >
> > Could anyone please get me a code to pull vbform value from
part
> > table to vbform value in jobhead table.
> >
> > I know it is possible i have seen somewhwre but it os just
not
> > working for me.
> > I will really appreciate that.
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> > 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
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]
37
I am no progress expert, but I believe that everything in between /*
and */ is "Remmed Out", or a remark. If that is true, then this
entire part of the code is not being run. Could this be the problem?

> /*FOR each Part Where part.company = "tri-star":
> and part.partnum = jobpartnum
>
> SET jobhead.char-field_1.scrvalue=part.char-field_1.scrvalue
>
> END.*/

Any experts want to verify this statement, or correct it?

Brian Stenglein
Clow Stamping Co.


--- In vantage@y..., "sharma_nalini" <sharma_nalini@y...> wrote:
> Actually when i check the syntax, it gives me a message the sysntax
> is correct.
> Below is the code i have written.
>
> {e:\epic50\vantage\VBP/part.i}
>
> /* Here define your own variables */
> DEFINE VARIABLE jobpartnum AS char NO-UNDO.
>
> /* do the calculation */
> jobpartnum = getStringValue("jobhead.partnum.SCRVALUE").
> DISPLAY jobpartnum.
>
> /*FOR each Part Where part.company = "tri-star":
> and part.partnum = jobpartnum
>
> SET jobhead.char-field_1.scrvalue=part.char-field_1.scrvalue
>
> END.*/
> RETURN.
>
>
>
>
> --- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> > Sharma,
> > Why don't you pass on your code here on the list by pasting it
> to an email and maybe someone will pick up something that isn't
quite
> right. I suspect that it's the syntax of the 'getstringvalue'
> function. Try various forms of the field name to begin with.
> >
> > Troy Funte
> > Liberty Electronics
> >
> > ----- Original Message -----
> > From: sharma_nalini
> > To: vantage@y...
> > Sent: Friday, May 24, 2002 8:41 AM
> > Subject: [Vantage] Re: VB Forms
> >
> >
> > HI Troy
> >
> > I tried , my syntax is correct for the program(suggested by
you)
> but
> > when i run the program it gives me an error written below.i am
> really
> > not sure what to do
> > Any comments
> >
> > Mismatched no of parameters passed to
C:\ProdDev\Wrk\P69157r.ped.
> >
> >
> >
> >
> > --- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> > > Sharma,
> > > I have not done it before, but it would seem that you
could
> use
> > a Progress routine which would pull in the appropriate Part
> number
> > from the JobHead table, and then use that field to filter out
the
> > data you need directly from the Part table.
> > >
> > > There is a sample program in the vbp folder, and a list of
> function
> > calls in the vb.i file in that same folder. You would use one
of
> > the "getdecimalvalue" or "getstringvalue" [ie. JobPartNum =
> > getStringValue("JobHead.PartNum.SCRVALUE")] to pull in the
> PartNumber.
> > > Then use progress language to Filter the Part Table.
> > >
> > > For instance;
> > > FOR EACH Part
> > > WHERE Part.Company = 'yourcompany'
> > > AND Part.PartNum = JobPartNum:
> > >
> > > Then you should have the field you need from the Part Table
> > available.
> > >
> > > The hard part for me is knowing the exact syntax for
> > the 'getstringvalue' function. Sometimes you need the part
that
> > says 'scrvalue' and sometimes you don't.
> > >
> > > Hopefully this will put you on the right path to figure
> something
> > out.
> > >
> > > Please let us know how you make out.
> > >
> > > Troy Funte
> > > Liberty Electronics
> > >
> > > ----- Original Message -----
> > > From: sharma_nalini
> > > To: vantage@y...
> > > Sent: Thursday, May 23, 2002 1:16 PM
> > > Subject: [Vantage] Re: VB Forms
> > >
> > >
> > >
> > >
> > > HI
> > >
> > > Could anyone please get me a code to pull vbform value from
> part
> > > table to vbform value in jobhead table.
> > >
> > > I know it is possible i have seen somewhwre but it os just
> not
> > > working for me.
> > > I will really appreciate that.
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> > > 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
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> > 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
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
> >
> >
> > [Non-text portions of this message have been removed]
38
HI I need some help from Progress expterts
I don't know why my program is not working .
Troy has given me an idea and based on that i wrote small program but
is it giving me an error for mismatched parameters and i have no idea
what is that.
"Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped."

What i want to do is create a vb field in part table.
and create a vbfield in jobhead table and where part.partnum =
part.jobhead
set part.char field= jobhead.charfield

I know it should not be complicated but it is just not working for me.

Please advise me what i am doing wrong.
39
No,no, no that is not a problem i just have that because first i
want to display the value what i have assiged, if i take that (/*) it
gives me syntax is correct but when i run the program it gives me the
error.
40
Sharma,
to make sure you are calling the functions properly, please do two things:
1. Locate your .p program in the V:\vantage\vbp folder of vantage.
2. Put the following line at the beginning of your .p program...

/* include vbp/vb.i so VantageBasic functions are accessible. */

{vbp/vb.i}



See if that changes the error message or clears things up.

Troy







----- Original Message -----
From: sharma_nalini
To: vantage@yahoogroups.com
Sent: Tuesday, May 28, 2002 6:05 AM
Subject: [Vantage] Re: VB Forms


HI I need some help from Progress expterts
I don't know why my program is not working .
Troy has given me an idea and based on that i wrote small program but
is it giving me an error for mismatched parameters and i have no idea
what is that.
"Mismatched no of parameters passed to C:\ProdDev\Wrk\P69157r.ped."

What i want to do is create a vb field in part table.
and create a vbfield in jobhead table and where part.partnum =
part.jobhead
set part.char field= jobhead.charfield

I know it should not be complicated but it is just not working for me.

Please advise me what i am doing wrong.


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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