To clarify what I am trying to do. I have a table with 3 main columns<br>ULong fldHighID;<br>ULong fldLowID;<br>ULongLong fldCompleteID;<br><br>fldCompleteID is defined as a calculated field with the expression "(highID<<32) + lowID", it is set to be indexed and unique. However, when I do the select "Select fldCompleteID FROM tblSample", I get a result that is equal to "Select fldLowID FROM tblSample". The fldHighID shift in the expression for fldCompleteID seems to be done as if it were 32 bit. Is there a way to force a 64 bit calculation?<br>
<br>--Christopher Jones<br><br><br><div class="gmail_quote">On Thu, Feb 17, 2011 at 6:26 PM, Chris Jones <span dir="ltr"><<a href="mailto:cjones@daz3d.com">cjones@daz3d.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi all,<br><br>Is there a way to make a valentina method field do its bit shifting in 64 bit, I would like to do the following in a method field:<br><br>"(fieldLongField1<<32) + fldLongField2"<br><br>When I attempt this the first field becomes zero which indicates to me that it is being done with 32 bit integers. Is there a way to change this?<br>
<br>--Christopher Jones<br><br><br>
</blockquote></div><br>