[Gvsig_english] gvSIG, Oracle Spatial and Views

Juan Lucas Dominguez Rubio jldominguez at prodevelop.es
Tue Feb 23 14:09:46 CET 2010


Hello, Wolfgang:
 
I believe the view you sent in the other email contained a join in the WHERE clause, that's one of the cases where views cannot be loaded in gvSIG. The simplest views are table filters that show you only some fields of a table. Can you test that type of views? That should work.
 
You can try to execute SELECT ROWID FOR ... with all your vies to see which have ROWID values.
 
You will only be able to open a view in gvSIG if it is a "key-preserved" case:
 
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:548422757486
 
Even in this case, you must check that the ROWID is not null in those views.
 
By a 'temporary table' I mean a table that lets you browse its content, and afterwards you can delete it because it was only a copy of the original tables. If you create a temporary table instead of a view, you will be able to open it from gvSIG, because it will necessarily have ROWIDs for all its rows. But then again, updates in that table will not affect original tables, of course.
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Wolfgang Qual
Enviado el: mar 23/02/2010 9:15
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] gvSIG, Oracle Spatial and Views




Good morning Juan Lucas (and all the others)
thank you very much for your reply. In this case, views seem not to work,
but do you know examples for views that can be loaded into gvSIG? What are
the differences to ours? And sorry to ask this question: what do you mean
with "temporary table"?

Best,
Wolfgang
--
View this message in context: http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4617585.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100223/1e3a5b0d/attachment.htm 


More information about the Gvsig_internacional mailing list