sql_language thread: Create a view that has an IF statement
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 .
|





