On 9/9/04 4:52 pm, "bugant" <bugant(at)opinioni(dot)net> wrote:
>> There shouldn't be any gaps in the sequence jobno sequence either. Is there
>> an easy way to do this?
>>
>> I thought of doing:
>>
>> SELECT max(jobno) from jobs where companyid=1;
> you could do something like this or using a lot of different sequence
> ... but I don't know if it's a clever idea ;)
I don't want lots of sequences, but how best would I go about locking the
table?
Thanks
Jake
>
> ciao,
> bugant.
>