Re: Can anybody tell me

#1

"Greg W" <sales (AT) winfieldsolutions (DOT) com> wrote in
news:3fcf9b40$1@forums-2-dub:

Quote:

Stephen

Thanks again for the reply and your patience. After reading your
answer I'm not sure whether using Excel/MSQuery falls entirely under
"API" or under "features" so I'm still left wondering. I am aware that
general goodies(log, SP etc) were stripped just from reading the help.
I guess my question should have been....."out of all the abilities
that are stripped from the rteng, is the ability to access data from
Excel/MSQuery one of them?"

Can I assume based on your previous answer that using Excel/MSQuery
against an ASA db falls under API stuff and therefore should work on a
rteng db. Is this a correct assumption?

TIA

Greg

Yes...

MS Query uses one of the Microsoft standard database APIs to access
data.

So as an example, I have an Excel spreadsheet that summarizes
operational statistics for the Support team (# Cases, resolution times,
customer satisfaction etc). It uses Macros and MSQuery to directly
access an ASA database using ODBC. I code the SQL statements I want
executed and when I press the update button Excel goes off and accesses
the database.

I think this is exactly like what you want to do and it can be done with
rtengx as well as a full engine.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer

#2

Stephen

That's the answer I was looking for....didn't want to purchase the studio if
we could get away with the rteng. Thanks for the explaination

Greg
"Stephen Rice" <srice_nospam (AT) ianywhere (DOT) com> wrote

Quote:

"Greg W" <sales (AT) winfieldsolutions (DOT) com> wrote in
news:3fcf9b40$1@forums-2-dub:

Stephen

Thanks again for the reply and your patience. After reading your
answer I'm not sure whether using Excel/MSQuery falls entirely under
"API" or under "features" so I'm still left wondering. I am aware that
general goodies(log, SP etc) were stripped just from reading the help.
I guess my question should have been....."out of all the abilities
that are stripped from the rteng, is the ability to access data from
Excel/MSQuery one of them?"

Can I assume based on your previous answer that using Excel/MSQuery
against an ASA db falls under API stuff and therefore should work on a
rteng db. Is this a correct assumption?

TIA

Greg

Yes...

MS Query uses one of the Microsoft standard database APIs to access
data.

So as an example, I have an Excel spreadsheet that summarizes
operational statistics for the Support team (# Cases, resolution times,
customer satisfaction etc). It uses Macros and MSQuery to directly
access an ASA database using ODBC. I code the SQL statements I want
executed and when I press the update button Excel goes off and accesses
the database.

I think this is exactly like what you want to do and it can be done with
rtengx as well as a full engine.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Can anybody tell me

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: Can anybody tell me - 12-05-2003 , 08:22 AM

Re: Can anybody tell me - 12-05-2003 , 08:29 AM