|
Home > Archive > FoxPro database connector > November 2005 > Moving records
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jjoseph 2005-11-14, 1:24 pm |
| 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 2005-11-14, 8:25 pm |
| 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.
On 14 Nov 2005 09:27:39 -0800, "jjoseph" <jjoseph@irsdd.com> wrote:
>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 2005-11-14, 8:25 pm |
| 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
"jjoseph" <jjoseph@irsdd.com> skrev i meddelandet
news:1131989259.183278.45480@g43g2000cwa.googlegroups.com...
> 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
>
|
|
|
|
|