Vantage ODBC query

Will Do!

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...

-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Thursday, August 08, 2002 8:26 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Hey Thad, keep us posted with what you find with Open Client. I've got some
stuff I've done in Crystal that I would like to speed up and I've been
looking at the Open Client also.



Ted Kitch
ted@...



-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 7:07 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query



Yes,

The Open Client and the AppServer are available from progress (not through
epicor according to my sales rep). Licensing is $140 per user for
appserver, and $500 per developer for open client.

I'll be getting it in the next week or so, so I'll let you know what my
initial findings are. I've read the documentation and have contacted
numerous developers regarding it, and i'm excited about the new
possibilities.

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 5:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Yes

-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 4:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Thanks Thad,

i am doing similar to what you describe except i am using serverside cursor.
my issue is the best response i seem to get from the query is about 5
seconds towards the end of day when the server is lightly loaded. during
the day it is more like 10-15 seconds, and sometimes fails. perhaps that is
the best i can expect, but it seems excessive to me. i am thinking this
must be an un-indexed search. i do not understand how the indexing works on
these tables. if epicor states there is an index of the company, and the
quotenum fields, wouldn't there need to be a field created to point at this
index? (in the database schema)
i guess i was expecting something like:
SELECT * FROM PUB.QUOTEHED WHERE indx = "XXXNNNN"
where XXX=company, and NNNN=quotenum concatenated together, or perhaps
delimited. but i find no definition for indx.

i was unaware of openclient, appserver products. i thought openclient was a
sybase tool. are these available from progress?

regards,

bob throckmorton
Schlosser Forge Co


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
>
83:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085
<http://www.classmates.com/index.tf?s=5085> >

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

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>

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



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>

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






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=17050071
83:HM/A=1182710/R=0/*http:/adfarm.mediaplex.com/ad/ck/990-1736-1039-335%0d%0
a>


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>

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co
If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Thanks Thad,

i am doing similar to what you describe except i am using serverside cursor.
my issue is the best response i seem to get from the query is about 5
seconds towards the end of day when the server is lightly loaded. during
the day it is more like 10-15 seconds, and sometimes fails. perhaps that is
the best i can expect, but it seems excessive to me. i am thinking this
must be an un-indexed search. i do not understand how the indexing works on
these tables. if epicor states there is an index of the company, and the
quotenum fields, wouldn't there need to be a field created to point at this
index? (in the database schema)
i guess i was expecting something like:
SELECT * FROM PUB.QUOTEHED WHERE indx = "XXXNNNN"
where XXX=company, and NNNN=quotenum concatenated together, or perhaps
delimited. but i find no definition for indx.

i was unaware of openclient, appserver products. i thought openclient was a
sybase tool. are these available from progress?

regards,

bob throckmorton
Schlosser Forge Co


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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>

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
83:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085>

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>

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]
Yes

-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 4:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Thanks Thad,

i am doing similar to what you describe except i am using serverside cursor.
my issue is the best response i seem to get from the query is about 5
seconds towards the end of day when the server is lightly loaded. during
the day it is more like 10-15 seconds, and sometimes fails. perhaps that is
the best i can expect, but it seems excessive to me. i am thinking this
must be an un-indexed search. i do not understand how the indexing works on
these tables. if epicor states there is an index of the company, and the
quotenum fields, wouldn't there need to be a field created to point at this
index? (in the database schema)
i guess i was expecting something like:
SELECT * FROM PUB.QUOTEHED WHERE indx = "XXXNNNN"
where XXX=company, and NNNN=quotenum concatenated together, or perhaps
delimited. but i find no definition for indx.

i was unaware of openclient, appserver products. i thought openclient was a
sybase tool. are these available from progress?

regards,

bob throckmorton
Schlosser Forge Co


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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>

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
83:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085>

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>

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yes,

The Open Client and the AppServer are available from progress (not through
epicor according to my sales rep). Licensing is $140 per user for
appserver, and $500 per developer for open client.

I'll be getting it in the next week or so, so I'll let you know what my
initial findings are. I've read the documentation and have contacted
numerous developers regarding it, and i'm excited about the new
possibilities.

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 5:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Yes

-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 4:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Thanks Thad,

i am doing similar to what you describe except i am using serverside cursor.
my issue is the best response i seem to get from the query is about 5
seconds towards the end of day when the server is lightly loaded. during
the day it is more like 10-15 seconds, and sometimes fails. perhaps that is
the best i can expect, but it seems excessive to me. i am thinking this
must be an un-indexed search. i do not understand how the indexing works on
these tables. if epicor states there is an index of the company, and the
quotenum fields, wouldn't there need to be a field created to point at this
index? (in the database schema)
i guess i was expecting something like:
SELECT * FROM PUB.QUOTEHED WHERE indx = "XXXNNNN"
where XXX=company, and NNNN=quotenum concatenated together, or perhaps
delimited. but i find no definition for indx.

i was unaware of openclient, appserver products. i thought openclient was a
sybase tool. are these available from progress?

regards,

bob throckmorton
Schlosser Forge Co


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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>

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
83:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085>

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>

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Hey Thad, keep us posted with what you find with Open Client. I've got some
stuff I've done in Crystal that I would like to speed up and I've been
looking at the Open Client also.



Ted Kitch
ted@...



-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 7:07 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query



Yes,

The Open Client and the AppServer are available from progress (not through
epicor according to my sales rep). Licensing is $140 per user for
appserver, and $500 per developer for open client.

I'll be getting it in the next week or so, so I'll let you know what my
initial findings are. I've read the documentation and have contacted
numerous developers regarding it, and i'm excited about the new
possibilities.

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 5:00 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Yes

-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 4:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


Thanks Thad,

i am doing similar to what you describe except i am using serverside cursor.
my issue is the best response i seem to get from the query is about 5
seconds towards the end of day when the server is lightly loaded. during
the day it is more like 10-15 seconds, and sometimes fails. perhaps that is
the best i can expect, but it seems excessive to me. i am thinking this
must be an un-indexed search. i do not understand how the indexing works on
these tables. if epicor states there is an index of the company, and the
quotenum fields, wouldn't there need to be a field created to point at this
index? (in the database schema)
i guess i was expecting something like:
SELECT * FROM PUB.QUOTEHED WHERE indx = "XXXNNNN"
where XXX=company, and NNNN=quotenum concatenated together, or perhaps
delimited. but i find no definition for indx.

i was unaware of openclient, appserver products. i thought openclient was a
sybase tool. are these available from progress?

regards,

bob throckmorton
Schlosser Forge Co


-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 08, 2002 2:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage ODBC query


If you don't already, you probably want to use a SQL select statement as the
first argument in the recordset's open statement. You'll probably want to
use a clientside static recordset with Batch Optimistic locking, as that
puts the least amount of load on the server.

rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM PUB.QUOTEHED WHERE Company = "001" AND QuoteNum = " _
& Cstr(intQuoteNumber) "select", cnnVantage, adOpenStatic,
adLockBatchOptimistic

cnnVantage is either the connectionstring you use to connect to vantage, or
an existing connection object that you've connected to vantage.
intQuoteNumber is a predefined integer containing the quote number.

As a footnote, I have had very limited success connecting vantage to VB
using ADO and ODBC. I'd strongly recommend looking into the OpenClient and
Appserver, which would allow you to call progress programs from visual basic
as if they were functions in an activex object.

The OpenClient will automatically convert a progresss temp-table into an ADO
recordset and vice versus.

HTH,

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Thursday, August 08, 2002 2:39 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Vantage ODBC query



can anyone post the syntax to perform an indexed read into a
Vantage/Progress table. I have a VB app siting outside vantage using ado
to access the QuoteHed table, the search to return the quotenum is painfully
slow as it searches the entire table to return the matching record. per the
data dict viewer an indexed field is company, quotenum. but what would that
look like?

thanks in advance

Bob Throckmorton
Schlosser Forge Co




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

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=213858.2225295.3666737.1829184/D=egroupweb/S=17050071
>
83:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085
<http://www.classmates.com/index.tf?s=5085> >

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

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>

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



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>

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






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=17050071
83:HM/A=1182710/R=0/*http:/adfarm.mediaplex.com/ad/ck/990-1736-1039-335%0d%0
a>


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>

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]