Vantage 6.1 - Vantage Basic

Yahoo Archive
1
Here is some code that I was going to use during implementation that
takes some data from tables and populates them in the vb field. Sounds
like you want to do something very similar:

/***********************************************************************
***
Description: This program pulls Benchstock, Bulk Issue and MPI
information
from previous revisions from the ECORev table

Vantage 6.1
-----------------

************************************************************************
***/

/* INCLUDE vb.i SO THAT VantageBasic FUNCTIONS ARE AVAILABLE. */

{vbp/vb.i}

DEFINE VARIABLE pn AS char NO-UNDO.

find first EcoRev Where RowID(EcoRev) = GetCurrentRowID() no-lock
no-error.
pn = EcoRev.PartNum.
release EcoRev.

find EcoRev where (PartNum = pn) and
(RevisionNum = getStringValue("PrevRev.ScrValue")) no-lock
no-error.

if available (EcoRev) then do:
setStringValue("MPI.ScrValue", EcoRev.Character01).
setStringValue("Benchstock.ScrValue", EcoRev.Character02).
setStringValue("BulkIssue.ScrValue", EcoRev.Character03).
end.
else
Message "Previous revision information is not available."
View-as alert-box information buttons ok.

release EcoRev.

RETURN.


Butch


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of joeynsknew
Sent: Thursday, October 27, 2005 10:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 - Vantage Basic


Have Anybody have experience in Vantage Basic , I want to create a VB
form in SO detail , and used Char1 field (orderdtl.char1) , I want to
create a Button that can copy content from the part.char1 , How can I
do this ? any advise are appreciated , Thanks

Joey
TTG





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]
2
Have Anybody have experience in Vantage Basic , I want to create a VB
form in SO detail , and used Char1 field (orderdtl.char1) , I want to
create a Button that can copy content from the part.char1 , How can I
do this ? any advise are appreciated , Thanks

Joey
TTG
3
This definitely isn't the whole solution but might be a few steps in the right direction.....

I populate a char field on a VB Form for Order Header from the OrderHeader screen. This is done on entry to the entire VB Form (without a button) so that it is already populated when the form is activated and gets saved when closed. Can't recall why I wanted to do this but it is there - probably for use on some Crystal form via DBF file.

Anyway the command in the VB form frame attributes (double click on outer edge of form away from any fields) and in the On Entry command (from drop down) is:
set orderhed.char-field_3.scrvalue = {bill-id.scrvalue}

bill-id.scrvalue is the screen value for the bill-id field on the form - the name of fields are often different from database names. You can get field list by right clicking on a background areas of a form and selecting Control List. This might be slightly different if you are not auithorized for personalization.

Problem for your situation though is copying from a field not on the form the VB Form belongs to. I think this starts to enter the realm of .p procedures to try to create a link to the part table. Once in the Progress procedure editor (like try opening vbsample.p in mfgsys61\VBP folder) go to Help and "find" help for the GET statement (as one example of Progress code) and scroll down to the sample code (a nice tip Arron Hoyt posted and presented at User-4-User). This might be a good jumping off point for writing the .p routine to try to obtain the part.char1 field and write it to the VB form scrvalue for char1. I think this is possible to do anyway. If so there are still probably a lot of gotchas in the query rules. One more tip...use the vbsample code as a starting point and only change lines after the vbp/vb.i reference and the RETURN at the end (comment section at top is OK to change too). The vbi include is critical.

This now exhausts my knowledge (if even accurate) about .p routines for table acces in a VB Form. I've never actually tried it.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of joeynsknew
Sent: Friday, October 28, 2005 12:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 - Vantage Basic


Have Anybody have experience in Vantage Basic , I want to create a VB
form in SO detail , and used Char1 field (orderdtl.char1) , I want to
create a Button that can copy content from the part.char1 , How can I
do this ? any advise are appreciated , Thanks

Joey
TTG





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 <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

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]