Hi That query class is not used very much, you can do everything with the other functions.
If you want to see the table layout, you can open the SMASTER.QPF file in the quotes plus data directory as an ms access database file. That's what it is. Best regards Gary ----- Original Message ----- From: galatyphoon To: [email protected] Sent: Friday, December 14, 2007 3:33 PM Subject: [quotes-plus] Re: Query class in Developer's Kit COM Library --- In [email protected], Howard Hansen <[EMAIL PROTECTED]> wrote: > > galatyphoon wrote: > > > > Hi; > > > > I've checked all sample codes in Developer's Kit and "DjTrader's Un- > > Official Developer's Document" but i've found nothing about the Query > > class in the COM library. Looking at the members of this class, i guess > > that this class lets developers to query QP3 databases. But since i've > > no idea about the internal structure about the databases (table names, > > column names etc.) i couldn't make it work so far. > > > > And a second question, how can i list the components of a certain index > > (let's say SP500) with QP3 COM library? Symbols class list symbols only > > according to exchange memberships or types (futures, stocks etc.)? > > > > > > > > > > > > > > What do you mean by the Query class? I have occasionally used COM to > access the Quotes Plus database and I don't remember seeing a class > called Query. There are no Quote Plus COM methods for listing the > components of the SP 500 index. > > Howard > > > > > When you add a reference to "Quotes Plus Type Library 1.1, QPSRV.DLL", it exposes a Query class under QuotesPlus namespace. It has 9 members, which one of them is "ExecuteSQL" which made me think that this class enables us to query QP3 database. Anyways i've solved the problem, no need for that class. I natively query QP3 databases instead of using this class.
