GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Posts: 43
Registered: ‎02-24-2016

Full Text Search on a view



Has anybody ever created a search for Smart Client Public Maps based on a view which has a Blob?


The issue I have is that I need to have an index on the view and I cannot create this because the view is not Schema Bound.

Trying to recreate my view (with schemabinding) causes me another issue because the view is looking at a linked databse.

This linked database is invalid for binding, and I cannot alter this database.


Is there a workaround for this? Maybe sombody has come across this issue before!

Posts: 269
Registered: ‎02-08-2016

Re: Full Text Search on a view

[ Edited ]



Sorry, I am not sure what the question really is.

I missed the link between a view with a blob and indexes that are not schema bound because of a linked database.

What is in the blob?


What is it that you are trying to accomplish?



Posts: 43
Registered: ‎02-24-2016

Re: Full Text Search on a view

Hi Marc,


I am trying to create a search for Public Maps.

The search is based on a view.

The view is a combination of a geometry table and some attribute data.

The attribute data is taken from a linked database.


In order to have the search in public maps - a Full text index must be applied to the table/view.

I am not going to be allowed to do this.


I was just wondering did anyone ever come across a similar situation before.

Posts: 43
Registered: ‎02-24-2016

Re: Full Text Search on a view

Hi Marc,


Blob is the geometry.

Posts: 1,054
Registered: ‎10-18-2015

Re: Full Text Search on a view



which type database are you using? Can you please explain better what you mean by "linked"?




Stefano Turcato
Presale Engineer
Hexagon Geospatial