64 bit shifting

[Ruslan Zasukhin]

On 2/18/11 6:34 PM, "Chris Jones" <cjones at daz3d.com> wrote:

Hi Chris,

Yes this should works, and during last say 5-6 years I self have show this
formula to few developers and on this list also.

It should work ..


> To clarify what I am trying to do.  I have a table with 3 main columns
> ULong fldHighID;
> ULong fldLowID;
> ULongLong fldCompleteID;
> 
> fldCompleteID is defined as a calculated field with the expression
> "(highID<<32) + lowID", it is set to be indexed and unique. 

Task is clear.

> 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?

Ivan, can you check this?

INSERT INTO T (f1,f2)   VALUES (1, 2)

SELECT f3

For above example table

 
> --Christopher Jones
> 
> 
> On Thu, Feb 17, 2011 at 6:26 PM, Chris Jones <cjones at daz3d.com> wrote:
> Hi all,
> 
> 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:
> 
> "(fieldLongField1<<32) + fldLongField2"
> 
> 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?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]