Article View: borland.public.interbase.sql
Article #551Re: retrieve query plan
From: Craig Stuntz TeamB
Date: Wed, 19 Sep 2007 20:23
Date: Wed, 19 Sep 2007 20:23
26 lines
1974 bytes
1974 bytes
RB Smissaert wrote: > How could I get access the API from VB? The same way you call any other function in a DLL, I suppose. I'm not a VB user, so I can't give you details, but the IB API is just C functions in a DLL. The specific function you want is isc_dsql_sql_info. It's documented in the IB API guide. You'll need to connect to the DB, prepare a statement, and then call this function. > How would I do it with ISQL from the commandline? Type: SET PLAN; ...and then execute your query. Or add this statement to the top of your input file. -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Want to help make Delphi and InterBase better? Use QC! http://qc.borland.com -- Vote for important issues
Technical Details
Message-ID:
<46f1853e@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<46f174bb$1@newsgroups.borland.com> <46f17982$1@newsgroups.borland.com> <46f17d33$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,c546675c5ab4ad6e X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: retrieve query plan Newsgroups: borland.public.interbase.sql References: <46f174bb$1@newsgroups.borland.com> <46f17982$1@newsgroups.borland.com> <46f17d33$1@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.18.1.5 X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 24.106.104.205 Message-ID: <46f1853e@newsgroups.borland.com> Date: 19 Sep 2007 13:23:26 -0700 X-Trace: newsgroups.borland.com 1190233406 24.106.104.205 (19 Sep 2007 13:23:26 -0700) Lines: 26 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail