<HTML><HEAD><TITLE>Re: [Gvsig_english] gvSIG, Oracle Spatial and Views</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText36883>
<DIV><FONT face="Times New Roman" color=#000000 size=3>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang:</FONT></DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>You can try to execute SELECT ROWID FOR ... with all your vies to see which have ROWID values.</DIV>
<DIV> </DIV>
<DIV>You will only be able to open a view in gvSIG if it is a "key-preserved" case:</DIV>
<DIV> </DIV>
<DIV><A href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:548422757486">http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:548422757486</A></DIV></FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV>Even in this case, you must check that the ROWID is not null in those views.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV></DIV>
<DIV id=idSignature49672>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Wolfgang Qual<BR><B>Enviado el:</B> mar 23/02/2010 9:15<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] gvSIG, Oracle Spatial and Views<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>Good morning Juan Lucas (and all the others)<BR>thank you very much for your reply. In this case, views seem not to work,<BR>but do you know examples for views that can be loaded into gvSIG? What are<BR>the differences to ours? And sorry to ask this question: what do you mean<BR>with "temporary table"?<BR><BR>Best,<BR>Wolfgang<BR>--<BR>View this message in context: <A href="http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4617585.html">http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4617585.html</A><BR>Sent from the gvSIG international mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>