Hi Cetin,

>Why are you inventing newid when SQL server has one NewID() or IDENTITY or Timestamp.

You raise a good point. A VFP/SQL application I took-over about 3 years ago has all its tables with integer pk fields, but the pk values are allocated via. a single 'control' table (called UniqueID), with one record for each table. Unfortunately none of the PK fields are auto-incremented identity fields.

I have only just discovered that SQL also has a NewId function (otherwise I might have called my VFP function something else!), but this produces a very complicated unique-identifer - my application only requires integer values.

Regards,
Alan