Programming in Progress

I will give you a copy if you like, but for now I am not comfortable posting
it to the group.
In part because it is not a "finished product", but for other reasons as
well.
Let me know off list is you would like a copy.
Thanks,
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Cole, Dave
Sent: Wednesday, September 14, 2005 4:56 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Programming in Progress


Aaron,



Would you post that to the Vantage Yahoo Groups website?



Thanks,



Dave Cole

Reeder & Kline

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress



Brandon,
I will go you one better. Based on a change to the tracking number field
(AKA tracking number is entered)...
You can set up a Business Activity Manager to automatically export the
information required into a text, CSV or other format file. I have not
tried to have it export the information directly into MS SQL database, but
you could set up an automated script to be called that would do that with
relative ease.
If it will help, I will send you the code I use for exporting job
information to CSV while the data is being entered into ShopFloor. It
should give you some stepping stones in the right direction.
But, in short, from the Vantage side of things, this can be done without
having to click an OK button, just by entering the data.
Let me know if you do want that procedure.
Aaron Hoyt
Vantage Plastics

PS. Everything in the .p was self taught with the progress help file and
the early examples shipped with Vantage.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, September 14, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/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/ <http://docs.yahoo.com/info/terms/> > .


_____




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




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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links










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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



SPONSORED LINKS
Membership database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem>
&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe>
&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership>
&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem>
&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb>
&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members>
&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/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/
<http://docs.yahoo.com/info/terms/> > .

_____



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




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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links









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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>




SPONSORED LINKS


Membership database software

Database mortgage software

Pda database software


Database management software

Database marketing software

Online database 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



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




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
Yahoo! Groups Links
Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




[Non-text portions of this message have been removed]
In case Aaron Hoyt is busy today...a great tip from him at the User-4-User conference was to use the Progress Help that you have on yur PC. It is chock full of code examples that you can cut/paste into .p routines then tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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



_____

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]
Reference material is available via the Progress website...



http://www.progress.com/products/documentation/index.ssp
<http://www.progress.com/products/documentation/index.ssp>



Regards,
Scott



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress



In case Aaron Hoyt is busy today...a great tip from him at the User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress

Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...





[Non-text portions of this message have been removed]
Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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



_____

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]




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
Yahoo! Groups Links
Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<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



_____

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]




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/.
<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
Yahoo! Groups Links










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/.
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]
Brandon,
I will go you one better. Based on a change to the tracking number field
(AKA tracking number is entered)...
You can set up a Business Activity Manager to automatically export the
information required into a text, CSV or other format file. I have not
tried to have it export the information directly into MS SQL database, but
you could set up an automated script to be called that would do that with
relative ease.
If it will help, I will send you the code I use for exporting job
information to CSV while the data is being entered into ShopFloor. It
should give you some stepping stones in the right direction.
But, in short, from the Vantage side of things, this can be done without
having to click an OK button, just by entering the data.
Let me know if you do want that procedure.
Aaron Hoyt
Vantage Plastics

PS. Everything in the .p was self taught with the progress help file and
the early examples shipped with Vantage.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, September 14, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<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



_____

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]




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/.
<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
Yahoo! Groups Links










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/.
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]




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
Yahoo! Groups Links
I don't know if you'll be able to do modifications on the VB Form window. I think you should work on the Shipment Window instead. When you close this window, just get the information you need and export it in a text file (I've never done a writing in MS-SQL via Progress, so I can't help you). I hope it's clear enough...

________________________________

De : vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] De la part de Brandon Murch
Envoyé : 14 septembre 2005 14:42
À : vantage@yahoogroups.com
Objet : RE: [Vantage] Programming in Progress

Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/. <http://groups.yahoo.com/group/vantage/files/>
<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



_____

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]




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/. <http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links










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/. <http://groups.yahoo.com/group/vantage/files/>
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]



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/. <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
Membership database software <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software <http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Database+marketing+software&w6=Online+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

________________________________

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]
Well,

After some searching I was able to find some example code to create an
ADODB connection in Progress. I am in the process of trying to get the
connection to our SQL server to work.

I would love to use the BAM, however, being on 5.2 puts that out of
reach right now.

Having experience with Visual Basic seems to be helping quite a bit in
regards to the progress language. Not too far in terms of commands and
such.

I will post more information as I progress through this difficult task.
Any help along the way is greatly appreciated.

PS: Aaron, if you don't mind sending me some example code off - list,
anything you may think would help out, I would love that.

Thanks again !!


Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 1:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Brandon,
I will go you one better. Based on a change to the tracking number
field
(AKA tracking number is entered)...
You can set up a Business Activity Manager to automatically export the
information required into a text, CSV or other format file. I have not
tried to have it export the information directly into MS SQL database,
but
you could set up an automated script to be called that would do that
with
relative ease.
If it will help, I will send you the code I use for exporting job
information to CSV while the data is being entered into ShopFloor. It
should give you some stepping stones in the right direction.
But, in short, from the Vantage side of things, this can be done without
having to click an OK button, just by entering the data.
Let me know if you do want that procedure.
Aaron Hoyt
Vantage Plastics

PS. Everything in the .p was self taught with the progress help file
and
the early examples shipped with Vantage.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, September 14, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<http://groups.yahoo.com/group/vantage/files/>
<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



_____

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]




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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links










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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]




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/.
<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
Yahoo! Groups Links









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/.
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]
Update:

I now have a working .p file that pulls information from our SQL server
and displays it on-screen as a message box. With this knowledge, I
think I should be able to get the order number that the user is
currently looking at, as well as VB form information and pass this along
to our SQL server.

I want to thank everyone for their help with this - just another
checkmark in the PLUS column for this user group.

Thank you again !!

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Brandon Murch
Sent: Wednesday, September 14, 2005 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Well,

After some searching I was able to find some example code to create an
ADODB connection in Progress. I am in the process of trying to get the
connection to our SQL server to work.

I would love to use the BAM, however, being on 5.2 puts that out of
reach right now.

Having experience with Visual Basic seems to be helping quite a bit in
regards to the progress language. Not too far in terms of commands and
such.

I will post more information as I progress through this difficult task.
Any help along the way is greatly appreciated.

PS: Aaron, if you don't mind sending me some example code off - list,
anything you may think would help out, I would love that.

Thanks again !!


Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 1:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Brandon,
I will go you one better. Based on a change to the tracking number
field
(AKA tracking number is entered)...
You can set up a Business Activity Manager to automatically export the
information required into a text, CSV or other format file. I have not
tried to have it export the information directly into MS SQL database,
but
you could set up an automated script to be called that would do that
with
relative ease.
If it will help, I will send you the code I use for exporting job
information to CSV while the data is being entered into ShopFloor. It
should give you some stepping stones in the right direction.
But, in short, from the Vantage side of things, this can be done without
having to click an OK button, just by entering the data.
Let me know if you do want that procedure.
Aaron Hoyt
Vantage Plastics

PS. Everything in the .p was self taught with the progress help file
and
the early examples shipped with Vantage.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, September 14, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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



_____

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]




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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links










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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]




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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links









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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

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]



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/.
<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



_____

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]
Aaron,



Would you post that to the Vantage Yahoo Groups website?



Thanks,



Dave Cole

Reeder & Kline

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress



Brandon,
I will go you one better. Based on a change to the tracking number field
(AKA tracking number is entered)...
You can set up a Business Activity Manager to automatically export the
information required into a text, CSV or other format file. I have not
tried to have it export the information directly into MS SQL database, but
you could set up an automated script to be called that would do that with
relative ease.
If it will help, I will send you the code I use for exporting job
information to CSV while the data is being entered into ShopFloor. It
should give you some stepping stones in the right direction.
But, in short, from the Vantage side of things, this can be done without
having to click an OK button, just by entering the data.
Let me know if you do want that procedure.
Aaron Hoyt
Vantage Plastics

PS. Everything in the .p was self taught with the progress help file and
the early examples shipped with Vantage.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, September 14, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


Before I look at tackling this "mountain", let me ask if what I want to
do is possible with little up front knowledge of Progress...

1. I would like to have a procedure run when the user clicks on the
OK button through a VB form
2. The procedure would either update a table in MS SQL, or export
information to a text file to allow a DTS package to import the data
into MS SQL

Basically, we are looking at having our website update throughout the
day with tracking numbers on shipments. We use MS SQL as the backend of
our website, using nightly DTS packages to extract information from
Vantage and update MS SQL. Management would like to have the tracking
information entered at the time of shipment automatically updated on the
website when our shipping department hits OK on the VB form that is used
for tracking numbers.

I hope all this made sense, was a long night last night with a backup
problem and am running on minimal amount of sleep.

Thank you,




Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, September 14, 2005 12:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress

Thanks Todd,
It's amazing what you can teach yourself with Progress Help. Sad I
can't
say Vantage help is as impressive.
Aaron

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Wednesday, September 14, 2005 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Programming in Progress


In case Aaron Hoyt is busy today...a great tip from him at the
User-4-User
conference was to use the Progress Help that you have on yur PC. It is
chock full of code examples that you can cut/paste into .p routines then
tweak as needed.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of
Brandon Murch
Sent: Wednesday, September 14, 2005 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Programming in Progress


Anyone have any good resources for someone wanting to dabble with a bit
of progress programming? Any ideas, websites, etc. would be greatly
appreciated.

Thank you,



Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...




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



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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



_____

YAHOO! GROUPS LINKS



* Visit your group " vantage
<http://groups.yahoo.com/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/ <http://docs.yahoo.com/info/terms/> > .


_____




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




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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links










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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



SPONSORED LINKS
Membership database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem>
&k=Membership+database+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=zumlzfMugtt6gdHbPv4SEw>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe>
&k=Database+mortgage+software&w1=Membe
rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so
ftware&w4=Database+management+software&w5=Database+marketing+software&w6
=Online+database+software&c=6&s=190&.sig=gjZta7wG6hZqdrJXzK2Teg>
Pda database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership>
&k=Pda+database+software&w1=Membership
+database+software&w2=Database+mortgage+software&w3=Pda+database+softwar
e&w4=Database+management+software&w5=Database+marketing+software&w6=Onli
ne+database+software&c=6&s=190&.sig=3Hn54KU1wFHab_pC8mcmQw>
Database management software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem>
&k=Database+management+software&w1=Mem
bership+database+software&w2=Database+mortgage+software&w3=Pda+database+
software&w4=Database+management+software&w5=Database+marketing+software&
w6=Online+database+software&c=6&s=190&.sig=36Lz5dDq6L3dzupiJwAffg>
Database marketing software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Memb>
&k=Database+marketing+software&w1=Memb
ership+database+software&w2=Database+mortgage+software&w3=Pda+database+s
oftware&w4=Database+management+software&w5=Database+marketing+software&w
6=Online+database+software&c=6&s=190&.sig=k5h2EoDyGba8G2MtsW5WSQ>
Online database software
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Members>
&k=Online+database+software&w1=Members
hip+database+software&w2=Database+mortgage+software&w3=Pda+database+soft
ware&w4=Database+management+software&w5=Database+marketing+software&w6=O
nline+database+software&c=6&s=190&.sig=-puLLcDG0gUTIJTiT0fjEw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/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/
<http://docs.yahoo.com/info/terms/> > .

_____



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




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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links









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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>




SPONSORED LINKS


Membership database software

Database mortgage software

Pda database software


Database management software

Database marketing software

Online database 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



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