Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ACE32.DLL

4 posts in FoxPro Last posting was on 2004-05-03 20:10:26.0Z
Harry Lefto Posted on 2003-12-04 23:45:04.0Z
Reply-To: "Harry Lefto" <lefto@citilink.com>
From: "Harry Lefto" <lefto@citilink.com>
Newsgroups: advantage.foxpro
Subject: ACE32.DLL
Date: Thu, 4 Dec 2003 17:45:04 -0600
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 206.196.49.23
Message-ID: <3fcfc7ea@solutions.advantagedatabase.com>
X-Trace: 4 Dec 2003 16:48:58 -0700, 206.196.49.23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!206.196.49.23
Xref: solutions.advantagedatabase.com Advantage.FoxPro:163
Article PK: 1109518

The header file for using the ACE API, which may be
downloaded from the ADS Website is very nice, but
ADS provides no examples of actually using the functions
via Visual FoxPro.

Does anyone have a sample procedure showing how to
use the API to do some basic operations, such as connect
to a database, open a table, find a record, pack...?

In fact, it would be very handy to have something like
this in the ADS documentation.
__________________________________________________________
Harry Lefto
lefto@citilink.com


Alex Wong Posted on 2003-12-08 15:00:12.0Z
From: "Alex Wong" <alexw@extendsys.com>
Newsgroups: advantage.foxpro
References: <3fcfc7ea@solutions.advantagedatabase.com>
Subject: Re: ACE32.DLL
Date: Mon, 8 Dec 2003 08:00:12 -0700
Lines: 31
Organization: ESI
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 198.102.102.214
Message-ID: <3fd4936b@solutions.advantagedatabase.com>
X-Trace: 8 Dec 2003 08:06:19 -0700, 198.102.102.214
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.214
Xref: solutions.advantagedatabase.com Advantage.FoxPro:164
Article PK: 1109519

Hi Harry,

The easiest ways to access Advantage from VFP are ODBC or ADO/OLEDB.
Although it is possible to call the API's directly, it will be very
difficult to manipulate the data obtained from ACE in VFP. ACE uses the
native format of the data while FoxPro has its own data storage. A data
conversion has to be performed between ACE and VFP in order to use the API.
Hence, I doubt anyone has used the API approach in VFP.

Alex

"Harry Lefto" <lefto@citilink.com> wrote in message
news:3fcfc7ea@solutions.advantagedatabase.com...
> The header file for using the ACE API, which may be
> downloaded from the ADS Website is very nice, but
> ADS provides no examples of actually using the functions
> via Visual FoxPro.
>
> Does anyone have a sample procedure showing how to
> use the API to do some basic operations, such as connect
> to a database, open a table, find a record, pack...?
>
> In fact, it would be very handy to have something like
> this in the ADS documentation.
> __________________________________________________________
> Harry Lefto
> lefto@citilink.com
>
>


Hugo Cantin Posted on 2004-05-01 15:06:02.0Z
Reply-To: "Hugo Cantin" <godcantin@yahoo.ca>
From: "Hugo Cantin" <godcantin@yahoo.ca>
Newsgroups: advantage.foxpro
References: <3fcfc7ea@solutions.advantagedatabase.com> <3fd4936b@solutions.advantagedatabase.com>
Subject: Re: ACE32.DLL
Date: Sat, 1 May 2004 11:06:02 -0400
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 24.203.182.185
Message-ID: <4093be6d@solutions.advantagedatabase.com>
X-Trace: 1 May 2004 09:12:45 -0700, 24.203.182.185
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.203.182.185
Xref: solutions.advantagedatabase.com Advantage.FoxPro:180
Article PK: 1109535

Hello,

I use calls to ACE32.dll extensively, mainly for performance reasons and for
tasks impossible to do via ODBC (i.e. create an index, re-structure a table,
etc...)

My app is created with VFP 6, with a ADS 6.2 back-end running on a Win2k
server.

I use remote views / ODBC for regular access to data (retrieve a record at a
time).

Sometimes I use SQL Passthru when the query is too complex for the VFP view
designer.

When running certain reports, it is much faster to use ACE than to requery()
a remote view after changing some view parameters, especially in a loop.

Here are some details on how to use ACE with VFp:

Declare the ACE32 functions before using them

Declare LONG AdsOpenTable IN ACE32.DLL LONG hConnect,STRING pucName,STRING
pucAlias,SHORT usTableType,;
SHORT usCharType,SHORT usLockType,SHORT usCheckRights,LONG ulOptions,LONG
@phTbl

rename ACE.PRG from the support website to ACE.h and include it in any file
that uses ACE

#include ACE.H

Then do the actual opening of the table

local lhTable
*
If AdsOpenTable( 0, "TABLE.DBF", "TABLE_ALIAS", ADS_CDX,ADS_OEM,
ADS_PROPRIETARY_LOCKING, ;
ADS_CHECKRIGHTS, ADS_DEFAULT, @lhTable) != AE_SUCCESS
/* You error handler goes here */
Return .f.
Endif

if this calls succeds, lhTable will contain the table handle you can use
with other ACe calls.


Good luck

Hugo Cantin

"Alex Wong" <alexw@extendsys.com> wrote in message
news:3fd4936b@solutions.advantagedatabase.com...
> Hi Harry,
>
> The easiest ways to access Advantage from VFP are ODBC or ADO/OLEDB.
> Although it is possible to call the API's directly, it will be very
> difficult to manipulate the data obtained from ACE in VFP. ACE uses the
> native format of the data while FoxPro has its own data storage. A data
> conversion has to be performed between ACE and VFP in order to use the
API.
> Hence, I doubt anyone has used the API approach in VFP.
>
> Alex
>
> "Harry Lefto" <lefto@citilink.com> wrote in message
> news:3fcfc7ea@solutions.advantagedatabase.com...
> > The header file for using the ACE API, which may be
> > downloaded from the ADS Website is very nice, but
> > ADS provides no examples of actually using the functions
> > via Visual FoxPro.
> >
> > Does anyone have a sample procedure showing how to
> > use the API to do some basic operations, such as connect
> > to a database, open a table, find a record, pack...?
> >
> > In fact, it would be very handy to have something like
> > this in the ADS documentation.
> > __________________________________________________________
> > Harry Lefto
> > lefto@citilink.com
> >
> >
>
>


Alex Wong (ADS) Posted on 2004-05-03 20:10:26.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: advantage.foxpro
References: <3fcfc7ea@solutions.advantagedatabase.com> <3fd4936b@solutions.advantagedatabase.com> <4093be6d@solutions.advantagedatabase.com>
Subject: Re: ACE32.DLL
Date: Mon, 3 May 2004 14:10:26 -0600
Lines: 105
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 198.102.102.20
Message-ID: <4096a7ff@solutions.advantagedatabase.com>
X-Trace: 3 May 2004 14:13:51 -0700, 198.102.102.20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.20
Xref: solutions.advantagedatabase.com Advantage.FoxPro:182
Article PK: 1109536

Hello Hugo,

Thanks for sharing the information. It is very helpful. You are the first
and only person I know that uses the API directly from VFP.

Alex

"Hugo Cantin" <godcantin@yahoo.ca> wrote in message
news:4093be6d@solutions.advantagedatabase.com...
> Hello,
>
> I use calls to ACE32.dll extensively, mainly for performance reasons and
for
> tasks impossible to do via ODBC (i.e. create an index, re-structure a
table,
> etc...)
>
> My app is created with VFP 6, with a ADS 6.2 back-end running on a Win2k
> server.
>
> I use remote views / ODBC for regular access to data (retrieve a record at
a
> time).
>
> Sometimes I use SQL Passthru when the query is too complex for the VFP
view
> designer.
>
> When running certain reports, it is much faster to use ACE than to
requery()
> a remote view after changing some view parameters, especially in a loop.
>
> Here are some details on how to use ACE with VFp:
>
> Declare the ACE32 functions before using them
>
> Declare LONG AdsOpenTable IN ACE32.DLL LONG hConnect,STRING pucName,STRING
> pucAlias,SHORT usTableType,;
> SHORT usCharType,SHORT usLockType,SHORT usCheckRights,LONG ulOptions,LONG
> @phTbl
>
> rename ACE.PRG from the support website to ACE.h and include it in any
file
> that uses ACE
>
> #include ACE.H
>
> Then do the actual opening of the table
>
> local lhTable
> *
> If AdsOpenTable( 0, "TABLE.DBF", "TABLE_ALIAS", ADS_CDX,ADS_OEM,
> ADS_PROPRIETARY_LOCKING, ;
> ADS_CHECKRIGHTS, ADS_DEFAULT, @lhTable) != AE_SUCCESS
> /* You error handler goes here */
> Return .f.
> Endif
>
> if this calls succeds, lhTable will contain the table handle you can use
> with other ACe calls.
>
>
> Good luck
>
> Hugo Cantin
>
>
> "Alex Wong" <alexw@extendsys.com> wrote in message
> news:3fd4936b@solutions.advantagedatabase.com...
> > Hi Harry,
> >
> > The easiest ways to access Advantage from VFP are ODBC or ADO/OLEDB.
> > Although it is possible to call the API's directly, it will be very
> > difficult to manipulate the data obtained from ACE in VFP. ACE uses the
> > native format of the data while FoxPro has its own data storage. A data
> > conversion has to be performed between ACE and VFP in order to use the
> API.
> > Hence, I doubt anyone has used the API approach in VFP.
> >
> > Alex
> >
> > "Harry Lefto" <lefto@citilink.com> wrote in message
> > news:3fcfc7ea@solutions.advantagedatabase.com...
> > > The header file for using the ACE API, which may be
> > > downloaded from the ADS Website is very nice, but
> > > ADS provides no examples of actually using the functions
> > > via Visual FoxPro.
> > >
> > > Does anyone have a sample procedure showing how to
> > > use the API to do some basic operations, such as connect
> > > to a database, open a table, find a record, pack...?
> > >
> > > In fact, it would be very handy to have something like
> > > this in the ADS documentation.
> > > __________________________________________________________
> > > Harry Lefto
> > > lefto@citilink.com
> > >
> > >
> >
> >
>
>