Postive AutoNumber?

[TheCandyman]

Is it possible to make a positive only autonumber? I don't see a way to do it in the DB, so i may have to make a random number in the code, and then assign it into the DB. Just wondering if anyone has needed this and worked on it before i start.

 

[PHV]

Provided you're not playing with Replica, an access AutoNumber is positive.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheCandyman]

Nope, not doing Replication.

The options are 'Replication ID', or 'Long Integer' for the auto number. Then you can pick 'Increment' or 'Random'

I need to have random numbers, which means the number is between -2147483648 to 2147483647. But i don't see a way to make it only positive.

 

[PHV]

OOps, missed the Random option :~/

 

[TheCandyman]

That's okay, just hoped there was a DB solution. Otherwise i might have to do a ASP method

<% 
  Randomize() 
  MyLuckyCharms = INT(Rnd ()*1000000000) 
%>

 

[PHV]

Why not using the Abs function in your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[adalger]

That wouldn't distinguish between a and -a in the key field.

TMTOWDI - it's not just for Perl any more