about insert,can you help me?

hi all:
use on access(xp+sp3) + SQL SERVER (MS SQL 2000 sp3)

many users

ID ID_s Fa Fb Fc Fd Fe
(auto int)(prgset int)
1 10 abc bcd cde def efg
3 30 abc1 bcd2 cde5 def8 efg1
2 50 abc2 bcd3 cde6 def9 efg2
4 80 abc3 bcd4 cde7 def0 efg3
....

order by ID_s

i do that ,bc i want to insert a new record and then thought the ID_s can
sort the table
but at many users this way was wrong, bc, the ID_s value at sometime will
same as other user do,can you help me how to do the insert? thanks!

howel
2005/01/07

Howel, it's not 100% clear on what tyou want to sort on. It sounds like you
want it sorted on the ID_s column. This is ok, but what determines the value
of the field? It looks like you really want to sort on Fa.




wrote in message
...
hi all:
use on access(xp+sp3) + SQL SERVER (MS SQL 2000 sp3)

many users

ID ID_s Fa Fb Fc Fd Fe
(auto int)(prgset int)
1 10 abc bcd cde def efg
3 30 abc1 bcd2 cde5 def8 efg1
2 50 abc2 bcd3 cde6 def9 efg2
4 80 abc3 bcd4 cde7 def0 efg3
...

order by ID_s

i do that ,bc i want to insert a new record and then thought the ID_s can
sort the table
but at many users this way was wrong, bc, the ID_s value at sometime will
same as other user do,can you help me how to do the insert? thanks!

howel
2005/01/07

o!sorry JohnFol,

ID ID_s Fa Fb Fc Fd Fe
(auto int)(prgset int)
1 10 abc bcd cde def efg
3 30 abc1 bcd2 cde5 def8 efg1

i want insert record in here
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2 50 abc2 bcd3 cde6 def9 efg2
4 80 abc3 bcd4 cde7 def0 efg3

------------------------------------------------------------
ID ID_s Fa Fb Fc Fd Fe
(auto int)(prgset int)
1 10 abc bcd cde def efg
3 30-p abc1 bcd2 cde5 def8 efg1
5 40 abc4 bcd5 cde3 def7 efg4
2 50-n abc2 bcd3 cde6 def9 efg2
4 80 abc3 bcd4 cde7 def0 efg3

ID_s number :
(50-30)/2+30=40

if int((n-p)/2)1 then
must reset the ID_s value as 10,30,50,80,110...for all record
hehe,if have so many insert,the value can set big for then ie: 100000
300000 500000....
but if have many user use this table when update ID_s value for all
record will so bad
and if add a move record program,this way wrong
end


my english so bad, sorry
"JohnFol" дÈëÓʼþ
...
Howel, it's not 100% clear on what tyou want to sort on. It sounds like
you
want it sorted on the ID_s column. This is ok, but what determines the
value
of the field? It looks like you really want to sort on Fa.




wrote in message
...
hi all:
use on access(xp+sp3) + SQL SERVER (MS SQL 2000 sp3)

many users

ID ID_s Fa Fb Fc Fd Fe
(auto int)(prgset int)
1 10 abc bcd cde def efg
3 30 abc1 bcd2 cde5 def8 efg1
2 50 abc2 bcd3 cde6 def9 efg2
4 80 abc3 bcd4 cde7 def0 efg3
...

order by ID_s

i do that ,bc i want to insert a new record and then thought the ID_s
can
sort the table
but at many users this way was wrong, bc, the ID_s value at sometime
will
same as other user do,can you help me how to do the insert? thanks!

howel
2005/01/07