<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 2/18/2011 6:34 PM, Chris Jones wrote:
<blockquote
cite="mid:AANLkTik_EHxuU=F_JRkfPgQgytgJWkY7+NhMc2vf8oAR@mail.gmail.com"
type="cite">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 moz-do-not-send="true"
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>
</blockquote>
</div>
</blockquote>
<br>
Fixed.<br>
<a href="http://www.valentina-db.com/bt/view.php?id=5439">http://www.valentina-db.com/bt/view.php?id=5439</a><br>
<br>
<pre class="moz-signature" cols="72">--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a class="moz-txt-link-freetext" href="http://www.valentina-db.com">http://www.valentina-db.com</a></pre>
</body>
</html>