[Qgis-user] Query Builder error (MS SQL 2008 table)
Hello Qgis-users, I am trying to make very simple query in Query Builder on layer 'point' which is opened from MS SQL 2008 R2 server ID = 6 but this error always appear: [Microsoft][SQL Server Native Client 10.0][SQL Server] Invalid object name 'point'. QODBC3: Unable to execute statement What could be wrong ? It seems that I cannot use this builder at all with my SQL 2008 tables. Win 7 32bit QGIS 1.8.0 standalone MS SQL Server 2008 R2 SQL Server Native Client 10.0 -- Nesh P. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query Builder
On 01/07/2012 05:44 PM, ALT SHN wrote: Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns "The where clause returned 0 entities" "Freguesia" = 'ESPIRITO SANTO' This never happened to me before. I attach the file in case someone volunteers to try replicate the problem. Any suggestions? Maybe encoding issues? I also noticed that Query Builder doesn't seem to work with non-ascii text. I have an attrib table (shapefile) with a text column containing Hebrew strings (UTF-8 encoded). Query builder always finds 0 rows, no matter what I put in. If I duplicate the column with English strings, the query works as expected. Could that be your problem? Anyone else noticed this? I see this in version 1.7.3. Thanks, Micha Thanks in advance, Andr Mano -- --- Associao Leonel Trindade SOCIEDADE DE HISTRIA NATURAL Apartado 25 2564-909 Torres Vedras Portugal Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras Laboratrio de Paleontologia e Paleoecologia: Polgono Industrial do Alto do Ameal 2565-641 Ramalhal http://alt-shn.blogspot.com www.alt-shn.org This mail was received via Mail-SeCure System. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This mail was received via Mail-SeCure System. -- Micha Silver GIS Consultant, Arava Development Co. http://www.surfaces.co.il ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query Builder
I did a query on your file and got the same result (QGIS 1.7.3, Windows version). If I remove one of the values en enter it again, the query returns the modified record. This only works if I don't use special characters. Sake Wagenaar Op 7-1-2012 16:44, ALT SHN schreef: Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns The where clause returned 0 entities Freguesia = 'ESPIRITO SANTO' This never happened to me before. I attach the file in case someone volunteers to try replicate the problem. Any suggestions? Maybe encoding issues? Thanks in advance, André Mano -- --- Associação Leonel Trindade SOCIEDADE DE HISTÓRIA NATURAL Apartado 25 2564-909 Torres Vedras Portugal Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras Laboratório de Paleontologia e Paleoecologia: Polígono Industrial do Alto do Ameal 2565-641 Ramalhal http://alt-shn.blogspot.com www.alt-shn.org http://www.alt-shn.org ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query Builder
I noted something else, by opening the attribute table in LibreOffice Calc or Excel. Several names in the second column contain strange characters, which are invisible in QGIS (e.g.: MExRTOLA en ESPIxRITO SANTO; strange characters have been replaced by 'x') . That's why your query returns no records. Sake Wagenaar Op 7-1-2012 16:44, ALT SHN schreef: Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns The where clause returned 0 entities Freguesia = 'ESPIRITO SANTO' This never happened to me before. I attach the file in case someone volunteers to try replicate the problem. Any suggestions? Maybe encoding issues? Thanks in advance, André Mano -- --- Associação Leonel Trindade SOCIEDADE DE HISTÓRIA NATURAL Apartado 25 2564-909 Torres Vedras Portugal Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras Laboratório de Paleontologia e Paleoecologia: Polígono Industrial do Alto do Ameal 2565-641 Ramalhal http://alt-shn.blogspot.com www.alt-shn.org http://www.alt-shn.org ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query Builder
Thank you for your feedback. I followed your suggestions and everything went fine! I Changed the encoding to UTF-8 and the problem is gone! BTW using 1.7.3 Best Regards, André Mano 2012/1/7 Sake Wagenaar sw1...@planet.nl I noted something else, by opening the attribute table in LibreOffice Calc or Excel. Several names in the second column contain strange characters, which are invisible in QGIS (e.g.: MExRTOLA en ESPIxRITO SANTO; strange characters have been replaced by 'x') . That's why your query returns no records. Sake Wagenaar Op 7-1-2012 16:44, ALT SHN schreef: Hello, I'm having a hard time using query builder with a point vector layer. Somehow it doens't seem to recognize all the entities, and as such a simple query as the one below returns The where clause returned 0 entities Freguesia = 'ESPIRITO SANTO' This never happened to me before. I attach the file in case someone volunteers to try replicate the problem. Any suggestions? Maybe encoding issues? Thanks in advance, André Mano -- --- Associação Leonel Trindade SOCIEDADE DE HISTÓRIA NATURAL Apartado 25 2564-909 Torres Vedras Portugal Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras Laboratório de Paleontologia e Paleoecologia: Polígono Industrial do Alto do Ameal 2565-641 Ramalhal http://alt-shn.blogspot.com www.alt-shn.org ___ Qgis-user mailing listQgis-user@lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- --- Associação Leonel Trindade SOCIEDADE DE HISTÓRIA NATURAL Apartado 25 2564-909 Torres Vedras Portugal Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras Laboratório de Paleontologia e Paleoecologia: Polígono Industrial do Alto do Ameal 2565-641 Ramalhal http://alt-shn.blogspot.com www.alt-shn.org ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Query builder tool
Hello everyone, Is there a tool such as Query builder? in Qgis? Thanks ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
RE: [Qgis-user] Query builder tool
If you open the attribute table for a shapefile, there is a button to the lower right of the attribute table labeled Advanced. This opens the query builder tool. Zach From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of legio nostra Sent: Friday, December 18, 2009 12:29 PM To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Query builder tool Hello everyone, Is there a tool such as Query builder? in Qgis? Thanks ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query builder tool
Dnia piątek, 18 grudnia 2009 o 19:26:31 Woolard, Zachary S. napisał(a): If you open the attribute table for a shapefile, there is a button to the lower right of the attribute table labeled Advanced. This opens the query builder tool. If you have your data in PostGIS, you will also find more powerful query builders among plugins. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user