General information
Category:
Coding, syntax & commands
I'm sure you remembered bubble sort from school.
suppose your field names: aa,bb,cc
your new field : dd
you want to insert dd after bb
alter table mytab add column dd c(10)
alter table mytab add temp i
use mytab
repl temp with cc all
use
alter table mytab drop column cc
alter table mytab add column cc
use mytab
repl cc with temp all
use
alter table mytab drop column temp
I just write that. I didn't try. Maybe some syntax mistakes.
-------------------------
this the basic. You need them for automation that:
-for/next
-fcount()
-field()
-and use bubble sort :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only