Moving records

[jjoseph]

Hi,
I am using VFP 7.0. I would like to reorganize tables used in
point-of-sale database. I want to simply move a record with all its
data within the same table. ie move record 3 to record 2. I am sure at
this point I am doing the hard way be coping the dbf 3 time deleting
records and appending dbf together. This a task that i will perform
often. Command line is fine.
TIA

[Josh Assing]

WHY on earth would you want to do this? This is totally in-effecient. You
should reconsider your application design if this is what you have to do....
You may want to use indexes or views instead.

Post by jjoseph
Hi,
I am using VFP 7.0. I would like to reorganize tables used in
point-of-sale database. I want to simply move a record with all its
data within the same table. ie move record 3 to record 2. I am sure at
this point I am doing the hard way be coping the dbf 3 time deleting
records and appending dbf together. This a task that i will perform
often. Command line is fine.
TIA

--- AntiSpam/harvest ---
Remove X's to send email to me.

[Anders]

What can I say? You are going down the wrong path. One does not solve
whatever problems or specifications there may be in that way. There used to
be, ages ago, a command to insert records in a selected position in a table.
It's been dropped from the Help file except for a line
INSERT: "Included for backward compatibility. Use APPEND or INSERT - SQL
instead."
-Anders

Post by jjoseph
Hi,
I am using VFP 7.0. I would like to reorganize tables used in
point-of-sale database. I want to simply move a record with all its
data within the same table. ie move record 3 to record 2. I am sure at
this point I am doing the hard way be coping the dbf 3 time deleting
records and appending dbf together. This a task that i will perform
often. Command line is fine.
TIA