This problem has been solved, by the use of sequences. If you can't
use them as a default, you can use them instead of
MAX(clipid)
You would use
NEXTVAL(clipid_seq)
assuming you had first done
CREATE SEQUENCE clipid_seq;
SELECT SETVAL('clipid_seq', (select MAX(clipid) from whatevertable));
T
On Mon, Apr 10, 2006 at 10:43:16PM -0700, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solv
On mán, 2006-04-10 at 22:43 -0700, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the p
On Tue, 2006-04-11 at 00:43, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the problem
On Tue, 2006-04-11 at 00:43, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the problem
Hi
Now we cannot change the field type. Because already our application
is running and thousands of records are already entered. we are getting
same no for clipid when 2 users are entering data at a time. so how to
solve the problem
---(end of broadcast)
On Mon, 2006-04-10 at 07:02, [EMAIL PROTECTED] wrote:
> Hi All,
>
> I am having the clipid field in my table.In my application i am taking
> Max(clipid) and inserting it into the table by incrementing that max
> value. so there is a problem when 2 users click sumbit button at a
> time. we r getii
Hi All,
I am having the clipid field in my table.In my application i am taking
Max(clipid) and inserting it into the table by incrementing that max
value. so there is a problem when 2 users click sumbit button at a
time. we r getiing same value . so hoe to solve the problem
---
