[SQL] Re: Using Random Sequence as Key

2001-04-16 Thread Bernardo de Barros Franco
on't want the user to let's say type his ordercode and by mistake type the last char say 1 less then his own and access someone else form and be completely lost. With random that still can happen but it is so less likely that will do. Thank you Quoting: > Bernardo de Barros Franco wr

[SQL] Re: Using Random Sequence as Key

2001-04-16 Thread Bernardo de Barros Franco
Thanks in advance for any help. Quoting: > On Sun, Apr 15, 2001 at 10:58:40PM -0300, Bernardo de Barros Franco wrote: > > > I wanted to index a table by a random key. Exemplifying, when a insert is > > made, the id value is automatically filled with a random number between > &g

Re: [SQL] Using Random Sequence as Key

2001-04-16 Thread Bernardo de Barros Franco
have 2 different indexes, the table index and the sale code that would be used for all queries. But my only question would be, in the example quoted would id be really the table index and is it unique? Thank you Quoting: >Bernardo de Barros Franco writes: > > > I wanted to index

[SQL] Using Random Sequence as Key

2001-04-16 Thread Bernardo de Barros Franco
Hello, I was wondering if noone can help me maybe someone could at least give me some directions where to look for info or where to ask: I wanted to index a table by a random key. Exemplifying, when a insert is made, the id value is automatically filled with a random number between 1 and 9