tag:blogger.com,1999:blog-5599902997355913399.post614480034977650797..comments2023-10-19T12:32:01.472+01:00Comments on Random consultant: Using ClearQuest API from VB 6 or VBASMhttp://www.blogger.com/profile/12739561458581174311noreply@blogger.comBlogger43125tag:blogger.com,1999:blog-5599902997355913399.post-50625301034558106822017-10-24T10:34:12.298+01:002017-10-24T10:34:12.298+01:00Did you follow these two steps?
The first thing t...Did you follow these two steps?<br /><br />The first thing to do is to import the module clearquest.bas from C:\Program Files\Rational\Clearquest or wherever cq is installed. This module contains a whole load of useful contstants that you may need later on.<br /><br />Next open Tools>References and look in the Available references list and make sure "ClearQuestOLEServer" is selected.SMhttps://www.blogger.com/profile/12739561458581174311noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-11962401180441613442017-10-23T15:31:29.022+01:002017-10-23T15:31:29.022+01:00Hello!
I run into an error when I try to run the ...Hello!<br /><br />I run into an error when I try to run the line "Set cqsession = New Session".<br /><br />The error message states "Automation Error. The specified module could not be found." Any advice?<br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-55126214229485531912016-07-22T08:48:31.045+01:002016-07-22T08:48:31.045+01:00I am new to Clearquest and excel data fetch
Plea...I am new to Clearquest and excel data fetch <br />Please help me<br /><br />I am getting below error <br /><br />---------------------------<br />Microsoft Visual Basic<br />---------------------------<br />The database "dbname" belonging to the dbset "dbsetname" is not registered.<br /><br />Please first make sure you entered the correct database name and the correct dbset name, and then make sure the database and the dbset are registered.<br />---------------------------<br />OK Help <br />---------------------------<br />Anonymoushttps://www.blogger.com/profile/03221764065237564775noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-62902103959841862602014-03-14T07:52:51.346+00:002014-03-14T07:52:51.346+00:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/16150906605171868474noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-81007248887708110342013-04-18T09:33:21.274+01:002013-04-18T09:33:21.274+01:00I cannot find the ClearQuest client that must be i...I cannot find the ClearQuest client that must be installed in order for this to be functionalAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-44053392252794477052013-02-19T19:36:02.576+00:002013-02-19T19:36:02.576+00:00Do you have Clearquest Desktop client exe file?Do you have Clearquest Desktop client exe file?Anonymoushttps://www.blogger.com/profile/02688410029550770006noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-34478847661534574312012-11-14T05:42:32.084+00:002012-11-14T05:42:32.084+00:00Visesh,
I have also faced the same error, I found ...Visesh,<br />I have also faced the same error, I found that the CQ DB name was not correct in my case.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-31138725657078388122012-10-26T07:39:56.608+01:002012-10-26T07:39:56.608+01:00I have enter the fields and then there is error sc...I have enter the fields and then there is error screen with "RED CROSS" and no other comment in the error message. Please help me the same asap.<br />Thanks in advanceVisheshhttps://www.blogger.com/profile/15798071240639263394noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-34508700779445909032012-10-26T06:39:41.978+01:002012-10-26T06:39:41.978+01:00Hi,
I tried to run the file but i am currently ge...Hi,<br /><br />I tried to run the file but i am currently getting an Run Time error saying :<b>Run Time Error :13224<br />The database 'DWP_BPM' belonging to dbset 'DWP_BPM' is not registered.</b>Visheshhttps://www.blogger.com/profile/15798071240639263394noreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-48297558568289460242012-10-09T11:51:46.965+01:002012-10-09T11:51:46.965+01:00Hi,
Can you please let me know what do you mean b...Hi,<br /><br />Can you please let me know what do you mean by "The first thing to do is to import the module clearquest.bas from C:\Program Files\Rational\Clearquest or wherever cq is installed" <br /><br />I have a file with clearquest.bas do I have to import it in excel or what should i do with it.<br /><br />Can you also let me know what should we put in "record type" in excelAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-28318571155708191422012-07-19T03:48:44.072+01:002012-07-19T03:48:44.072+01:00Hi all,
I am trying to use Macro in Excel 2010 to ...Hi all,<br />I am trying to use Macro in Excel 2010 to query data from ClearQuest, but after follow the instruction from this link,<br />I am still getting some runtime error, saying that "Run-time Error '429', ActiveX component can't create object". As you have got this work, can you provide me some guidance?<br />Btw, are you using Excel 2003-2007 or Excel 2010?<br /><br />Thanks a lot,<br />YLAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-39163619998654830132012-07-06T13:22:07.187+01:002012-07-06T13:22:07.187+01:00Hello,
i found it. It was BuildEntity.
Is it po...Hello, <br />i found it. It was BuildEntity. <br /><br />Is it possible, that i See the ID (not entity.GetDbId), before I commit the entity?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-38767530482078486792012-07-06T08:19:56.233+01:002012-07-06T08:19:56.233+01:00Hello,
is it possible to enter a new Entity (Chan...Hello, <br />is it possible to enter a new Entity (Change Request, Finding...). <br />Until now i only edit a entity with session.EditEntity<br /><br />I not found the function do enter a entity in ClearQuest. <br /><br />RegardsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-61664186626595232332012-07-05T15:38:35.758+01:002012-07-05T15:38:35.758+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-20390454361660182662012-07-05T15:37:52.760+01:002012-07-05T15:37:52.760+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-85539847581670812062012-07-05T15:37:01.999+01:002012-07-05T15:37:01.999+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-51415535847396720132012-07-05T15:36:23.654+01:002012-07-05T15:36:23.654+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-89375643289767488082012-07-05T15:36:09.153+01:002012-07-05T15:36:09.153+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-42238407271498349092012-07-05T15:35:48.150+01:002012-07-05T15:35:48.150+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-39603122942740107132012-07-05T15:35:14.860+01:002012-07-05T15:35:14.860+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-8171568858963479752012-07-05T15:34:58.458+01:002012-07-05T15:34:58.458+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-83240391477549083722012-07-05T15:34:35.748+01:002012-07-05T15:34:35.748+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-10060076134202124452012-07-05T15:34:17.620+01:002012-07-05T15:34:17.620+01:00Hello,
I see In ClearQuestOleServer the Function E...Hello,<br />I see In ClearQuestOleServer the Function EditEntity. Is it possible to add ja new Entity (Finding, Change Request and so one) in Clear Quest with VBA?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-4872719431505208482012-04-10T15:19:43.789+01:002012-04-10T15:19:43.789+01:00ClearQuestOleServer is missing. Where can get itClearQuestOleServer is missing. Where can get itAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5599902997355913399.post-86046900110036237002011-12-16T11:53:36.978+00:002011-12-16T11:53:36.978+00:00Hi,
Thank you very much, it works fine for me.
I w...Hi,<br />Thank you very much, it works fine for me.<br />I wonder how to extract all the field of a given record type (w/o any filter)<br />the aim is to generate metrics using exel pivot table<br />Thanks again<br />Stephane<br />(France)slelinoreply@blogger.com