SQL help

[Ruslan Zasukhin]

HAPPY NEW YEAR! :-)



Hi William,

> How do I request a field data from a RecID one less than the current
> RecID that I know the record ID for?

You should NOT use RecID in any calculations

Records can be added into wholes from deleted records!




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