topic Re: Executing multiple queries in AutoCAD Map 3D Developer Forum

Executing multiple queries

Anonymous — Wed, 05 May 2004 03:27:25 GMT

Hi all,

Do any one have a solution to execute multiple queries available on the project workspace with a single command or click?

This issue posted at
http://discussion.autodesk.com/thread.jspa?threadID=330556
did not receive any response for 3 days. Hence, I am trying here. (Hope Annie forgives me)

Thanks,

MNRaghu

Re: Executing multiple queries

Anonymous — Wed, 05 May 2004 14:33:32 GMT

Hello MNRaghu.

Anne might forgive the 'double post', but I don't know how if she'll forgive you for calling her 'Annie'? 🙂

Anyways.
What you are asking can only be accomplished with some customization... You need to create a 'wrapper' to call all of the required queries in one shot...

Hope this helps
Warren M

Re: Executing multiple queries

Anonymous — Thu, 06 May 2004 03:33:09 GMT

Thanks for the suggestion Warren,

I will look into some available functions and come back if required.

MNRaghu

Re: Executing multiple queries

Anonymous — Thu, 06 May 2004 14:02:14 GMT

I answer to most anything Anne -- Anne Brown Discussion Groups Administrator Autodesk, Inc. Warren M wrote: > > Hello MNRaghu. > > Anne might forgive the 'double post', but I don't know how if she'll forgive you for calling her 'Annie'? 🙂

Re: Executing multiple queries

Anonymous — Fri, 07 May 2004 07:32:35 GMT

Anne, Thanks for soft remarks.

Can any one help me programatically getting all the names of saved queries on the project workspace and executing them in draw mode?

I tried this way, by manually supplying the names of the saved queries.
This executed only some queries.
If I execute the left out queries manually, it works perfectly, which the program did not perform.

(foreach item (list "All_Except_Line_Polys" "Conduit" "Graphic_Lines" "Commercial"
"Fire" "Hydrant" "Irrigation" "Residential" "Sampling"
"Easements_Polygon" "PipeCasing_Polygon" "Station_Polygon"
)
(setq qid (ade_qlqrygetid item))
(ade_qlloadqry qid)
(ade_qrysettype "draw")
(ade_qryexecute)
(command "zoom" "e")
)

Also, I would also request to get me some ideas to improve the coding and get complete output.

Any help much appreciated.

Thanks,

MNRaghu

Re: Executing multiple queries

Anonymous — Sat, 08 May 2004 10:11:42 GMT

Repeating this question again for some help needed urgently..

Can any one help me programatically getting all the names of saved queries on the project workspace and executing them in draw mode? Any suggestions on improving the above given codes are also welcome.

Thanks for any help offered.

MNRaghu

Re: Executing multiple queries

Anonymous — Mon, 10 May 2004 14:54:32 GMT

Hello MNRaghu.

Sorry, can't help you on the lsp side, but here is a vba project with a very crude/simple function to execute all saved queries.

Hope this helps
Warren M

Re: Executing multiple queries

Anonymous — Mon, 10 May 2004 18:19:44 GMT

The only suggection I know right now is to double check the spelling of the query names. Every once in a while my keyboard would misspell a word or two. What it sounds like is, it would preform the queries up to a point and then exit on error with out a error message. Murph "RaghuMN" wrote in message news:86027.1084011136756.JavaMail.jive@jiveforum2.autodesk.com... > Repeating this question again for some help needed urgently.. > > Can any one help me programatically getting all the names of saved queries on the project workspace and executing them in draw mode? Any suggestions on improving the above given codes are also welcome. > > Thanks for any help offered. > > MNRaghu

Re: Executing multiple queries

Anonymous — Tue, 11 May 2004 10:39:33 GMT

Thanks Warren and Murph,

Warren,
Your program works, but for some queries, I get the error 'Executing data query...the index does not exist...done', and the features are not extracted from these queries.

I do not see any fault of your program, it seems to be perfect.

Do you have any idea why I get the above error.?
--------
Murph,

The program given by Warren takes the queries from the drawing. I will not supply any names, all it takes by itself from the drawing. Hence, there is no chance of misspelling the query names.

Even then, my queries are not completely executed when tried programatically.

These work fine when each individual query is clicked and executed manually.

Any further suggestions?

Thanks

Re: Executing multiple queries

Anonymous — Tue, 11 May 2004 14:12:25 GMT

RaghuMN, I ran Warren's routine with dwgs that were attached that had no indexes or bad index that I knew existed with out any problems. The queries (4 different type) ran ok. Are you attaching the dwgs manually or doing it in your program? If you are attaching them though code it may be that part of it that is causing the errors. Murph "RaghuMN" wrote in message news:27184670.1084272003452.JavaMail.jive@jiveforum1.autodesk.com... > Thanks Warren and Murph, > > Warren, > Your program works, but for some queries, I get the error 'Executing data query...the index does not exist...done', and the features are not extracted from these queries. > > I do not see any fault of your program, it seems to be perfect. > > Do you have any idea why I get the above error.? > -------- > Murph, > > The program given by Warren takes the queries from the drawing. I will not supply any names, all it takes by itself from the drawing. Hence, there is no chance of misspelling the query names. > > Even then, my queries are not completely executed when tried programatically. > > These work fine when each individual query is clicked and executed manually. > > Any further suggestions? > > Thanks

Re: Executing multiple queries

Anonymous — Wed, 12 May 2004 03:08:29 GMT

Murph,

I attach the drawings manually. The queries work fine with manual execution.

Do you have any ideas of how (what circumstances) an index can be lost in the queried drawing / how the indexes can become bad?

Thanks,

MNRaghu

Re: Executing multiple queries

Anonymous — Wed, 12 May 2004 12:50:11 GMT

A few ways that I have corrupted indexes are by creating OD tables with the same name but different field names. Doing some alter property queries and then saving those back to the original dwg. If you are using extrenal databases linked to Map and editting the records outside of Map. What you may want to try is to re-index the attached dwgs from the drawing / maintenence menu. Murph "RaghuMN" wrote in message news:27285896.1084331339869.JavaMail.javamailuser@localhost... > Murph, > > I attach the drawings manually. The queries work fine with manual execution. > > Do you have any ideas of how (what circumstances) an index can be lost in the queried drawing / how the indexes can become bad? > > Thanks, > > MNRaghu

Re: Executing multiple queries

Anonymous — Thu, 13 May 2004 03:01:34 GMT

Thanks Murph,

You may be right. I think that I might have corrupted the indexes with one of the ways that you have specified.

I will also try with the re-index the attached drawings.

Thanks for the support. I would request you to inform me if have any other thoughts on this issue.

MNRaghu