V4RB RecID and String Method problems

[Mike Albert]

Thanks Ruslan,

Actually, in my implementation I do not delete any records (these are sales transactions that would never change once they are inducted into the Valentina DB) but I do understand the danger.

I have been using RecID as the unique key to each record.  Being able to determine the maximum and minimum aggregate functions on RecID would be most useful.  Strangely, Count(RecID) is working for me so I am guessing some of the functions are working.

regards
Mike

On Tuesday, June 24, 2003 2:50 PM, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>on 6/24/03 5:55, Mike Albert at malbert at asia.apple.com wrote:
>
>>> 1) RecID seems to be not working with aggregate methods.
>>> What sense to use it here?
>> 
>> When I have two records with the same order date I can determine which one was
>> placed later by the order that it was imported into the DB.  The one that has
>> the larger RecID would be the last record with that date that was imported /
>> transacted.  Without a time timestamp this is the only way to
>determine this.
>
>Mike, 
>
>But this is danger assumption!
>
>If you have delete some record, then your new record will go into that
>deleted space, so its RecID will be LESS then RecID of already existed
>record.
>
>You see?
>
>-- 
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]
>-------------------------------------------------------------
>e-mail: ruslan at paradigmasoft.com
>web: http://www.paradigmasoft.com
>
>To subscribe to the Valentina mail list go to:
>http://lists.macserve.net/mailman/listinfo/valentina
>-------------------------------------------------------------
>