Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Create a view that has an IF statement


Message #1 by "Chris Hetrick" <chetrick@h...> on Mon, 29 Jan 2001 19:49:42 -0000
I have a foxpro table like 

old_position  new_postion
0                      0
1                      1
2                      2
.                       .
.                       .
100                  100

When I insert a new record at position X ( eg : 10 ) , its 
old_position is -1  however the new position will be shifted as 
new_position which is 10 to 100 become 11 to 101 .

Is there anyone know how to do this ?

Thanks .

  Return to Index