If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|