<br><br><div class="gmail_quote">2011/3/18 Roger Bedell <span dir="ltr"><<a href="mailto:sylvanascent@gmail.com">sylvanascent@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I found this:<div><br></div><div><div>SELECT (select count(*) from QQHeader where PKey<=a.PKey) AS RowNo, a.*</div><div>FROM QQHeader AS a</div><div><br></div><div></div></div></blockquote><div><br><br>The problem with this (and with the ROW_NUMBER option as well) is that
the order of the rows may be undeterministic unless an orderby clause is used. I would rather suggest to
use a function (either an UDF or the checksum) to create and integer is
from guid.<br>
<br>
BTW: In the development version having an oid should not necessarily be a
requirment in order to have the query option to work. So you may
probably omit the using unique section in the layer definition (not
tested by me).<br>
<br>
Best regards,<br>
<br>
Tamas<br>
<br>
<br><br></div></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>