queries not saved in workspace

[alfie]

Hi all,

I have a MB tool which runs a number of menu-driven queries to select
subsets of a Table (eg. select all points which fall within a given
suburb polygon) and then adds the query results to a map window.

However, when I save the session as a workspace, the query is not
saved in the workspaces.

Any idea why this might be?

Thanks. A

[Peter Horsbøll Møller]

A,

 

A preference controls whether queries are save to the workspace or not.

Goto Options > Preferences > Startup and check the Save queries in workspaces option.

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

 

2009/11/13 alfie <alfred.w...@gmail.com>

[alfie]

Thanks Peter, but this option is already selected.

The problem seems to be that some queries are saved and some are not.
The queries which are not saved appear to be queries that are
generated by a number MapBasic utilities we use for selecting data and
displaying data.

I also note, that when I go to "Save Query..." under the "File" menu,
some queries are listed (usually any manually created ones) however
some queries created by MB tools do not appear.

Thanks, A

On Nov 13, 6:12 pm, Peter Horsbøll Møller <mapinf...@horsboll-

moller.dk> wrote:
> A,
>
> A preference controls whether queries are save to the workspace or not.

> Goto *Options > Preferences > Startup* and check the *Save queries in
> workspaces* option.

>
> Peter Horsbøll Møller
> Pitney Bowes Business Insight - MapInfo
>

> 2009/11/13 alfie <alfred.warring...@gmail.com>

>
>
>
>
>
> > Hi all,
>
> > I have a MB tool which runs a number of menu-driven queries to select
> > subsets of a Table (eg. select all points which fall within a given
> > suburb polygon) and then adds the query results to a map window.
>
> > However, when I save the session as a workspace, the query is not
> > saved in the workspaces.
>
> > Any idea why this might be?
>

> > Thanks. A- Hide quoted text -
>
> - Show quoted text -

[Mats Elfström]

That is true.

The workspace saver knows only queries created through the interactive interface. It is probably assumed that programmatically created queries are taken care of by the program, either saved as new tables, or that they can be discarded as temporary.

 

HTH Mats.E

2009/11/16 alfie <alfred.w...@gmail.com>

[alfie]

This seems like a shortcoming in MapInfo. We have a tool which allows
users to create a map showing only bus routes within a selected
geography. it would be great if they could then save the results in a
workspaces.

I hope MapInfo would like at changing the way this works, or at least
having a setting to allow users to save all query results in the
workspace.

A

On Nov 16, 6:56 pm, Mats Elfström <mats.elfst...@gmail.com> wrote:
> That is true.
> The workspace saver knows only queries created through the interactive
> interface. It is probably assumed that programmatically created queries are
> taken care of by the program, either saved as new tables, or that they can
> be discarded as temporary.
>
> HTH Mats.E
>

> 2009/11/16 alfie <alfred.warring...@gmail.com>

> > > - Show quoted text -- Hide quoted text -

[Peter Horsbøll Møller]

A,

 

If you want the query result to be "visible" to MapInfo Pro, you can run it thru the Run Command statement.

 

This query can not be saved as a query table:

 

Select * From ButikkerOdenseDriveDistance
  Where ID = 1000
  Into ButikkerOdense_1000 NoSelect

But this one can:

 

 Run Command "Select * From ButikkerOdenseDriveDistance"
               + " Where ID = 1000"
               + " Into ButikkerOdense_1000 NoSelect"

 

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

2009/11/16 alfie <alfred.w...@gmail.com>