Greg, Actually this code is part of a MapBasic program. Kristof Vydt "Driver, Greg 9434" <[EMAIL PROTECTED]> wrote: Kristof, Are you defining the variable clipregion via the mapbasic window? If so then it will not be saved into the workspace, which is why the SQL query isn't being saved as well. You'll have to enter the code below into the workspace yourself along with the SQL query for it all to work. Greg
-----Original Message----- From: Kristof Vydt [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 14:20 To: [email protected] Subject: RE: MI-L Store query with "Within" in workspace Greg, The object is created with ... Dim ClipRegion As Object Select * From SomeBigTable Where obj Intersects ( Select obj From SomeBigTable Where SomeFieldName = SomeFieldValue ) Into SmallTable Create Object As Union From SmallTable Into Variable ClipRegion The idea behind the above code, is that I need to define a clipping area consisting of 1 region and it's surrounding (adjecant) regions from the original SomeBigTable. Again I'm asking myself: (1) Will my problem be solved if I can use "Run Command" ? (For the "Create Object" of my original "Select".) ( --> I still doubt it.) (2) How can I use "Run Command" when ther is an object involved ? Thanks for your replies. If you still have an idea how ... Kristof Vydt "Driver, Greg 9434" <[EMAIL PROTECTED]> wrote: Kristof, In your SQL select statement you have the object 'clipregion', where does that come from? If this isn't set up via a query then it won't save the SQL statement. Greg -----Original Message----- From: Kristof Vydt [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 13:36 To: Driver, Greg 9434 Subject: RE: MI-L Store query with "Within" in workspace Greg, This option is enabled. Kristof Vydt "Driver, Greg 9434" <[EMAIL PROTECTED]> wrote: Kristof, Have you checked that the 'Save Queries in Workspaces' option is enabled? You can check this under the Options > Preferences > Startup dialog and see if it's enabled. Greg. -----Original Message----- From: Kristof Vydt [mailto:[EMAIL PROTECTED] Sent: 04 April 2005 12:11 To: [email protected] Subject: MI-L Store query with "Within" in workspace I read that queries are only stored correctly in a workspace, when using "Run Command" instead of using SQL directly. Currently, I use ... Select * From BaseLayer Where obj Within ClipRegion Into ResultSet ... as some kind of clipping my BaseLayer. But this query is not correctly saved to the workspace. Any idea how to rewrite this query using "Run Command" ? Kristof Vydt Send instant messages to your online friends http://uk.messenger.yahoo.com Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. Send instant messages to your online friends http://uk.messenger.yahoo.com Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. Send instant messages to your online friends http://uk.messenger.yahoo.com Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. Send instant messages to your online friends http://uk.messenger.yahoo.com
