Append problems

[rfha]

OK Guys...

This should be a breeze for most of you, but my head is getting bloody from repeated contact with the wall.

I am having trouble appending records from an old database application to a revised version.

The databases were not changed, same field names, number of fields etc. After building new reports, screen changes, etc., I emptied the new working database and prepared to append the records from the original database into the new one.

I used the operation genie to create the append. The master database table is "spokes.dbf" and the transaction database table is "spokes2.dbf." When running the append, the program gives an error message of @Spokes2->amountpd2 not found. However, opening the operation in design mode both field are clearly listed with identical spelling and mapped to each other. Both are numeric fields, length 8 decimals 2. I then mapped another field from the transaction database to the apountpd3 field in the master. Same error.

I then tried to delete the amountpd3 from the append operation entirely. I saved the append, ran the operation and got the same error. I deleted the append created by the genie and manually rebuilt. Same error.

There are aboud 35 fields in each database ... the amountpd3 field is about 20 in the list.

It must be something simple that I am overlooking. Any suggestions would be appreciated.

Rich

[Steve Workings]

RE: Append problems

Sometimes Alpha's error message is close, but not quite correct.

You might poke through your transaction data and see if any of it is outta whack. Or perhaps a field rule is begin violated.

- Steve

[rfha]

RE: Append problems

Steve ...

I looked at the data in the transaction file and it all seemed OK. There were no field rules on the amountpd3 fields in either database.

Any other toughts?????

[crimmelcp]

RE: Append problems

Richard:
Try 1 or 2 fields at a time
if it works then add another field until you fine the field that is causing the error.
might take a while but it should work.
Charlie Crimmel

[Tom Cone Jr]

RE: Append problems

Richard, the type of problem you describe is most often related to the values stored in the transaction table. Data within that table is corrupt, or possibly you have a mismatch in the table structures. If I were having this trouble I would double check to verify that the data types and lengths are identical. Then, if that proves true, I would divide the transaction table into smaller chunks and append one at a time until I found the chunk that would not append. Then I'd subdivide that chunk further, until I got to the troublespot. Tedious to be sure, but likely to succeed... eventually.

-- tom

[Tom Patten]

RE: Append problems

Richard,

You say, "The databases were not changed, same field names, number of fields etc". Why not just copy the *.dbf files from you original database to the new database. Include .FPT if you have memo fields.

Tom

[rfha]

RE: Append problems

In the new database/application. I did cre4ate some new global calculated fields for reports, etc.

I was not sure where they were stored and if they would be affected ifr I simply copied the table. The application does have a memo field.

I give some of these suggestions a spin in the morning. I figured 6.5 days in the office was enough.

Thanks for the input ... I'll keep you posted.

Thaks again.

Rich

[Mike Konoff]

RE: Append problems

I happen to be in the process of moving the databases that I developed in Alpha Four over to Alpha Five. Whenever I make the move I simply copy the table from the old directory from A4 to the new directory in A5, and then begin re-building my field rules, forms, reports, etc.

As suggested in a previous post, if your original table is *.dbf format, you should not have any trouble copying that to your A5 directory and start working from there.

Mike

[rfha]

RE: Append problems

Thanks for the reply. I duplicated the original A5 database, including field rules, etc.

Then ran the append operation. Things worked just fine. Not sure what the problem was ... but finally got the job done.

thanks to everyone for their suggestions and help.

Rich Hill

[Ron McCormack]

RE: Append problems

[code]
Try this.

Copy your new table to a temporary file.
then use the copy function below to copy old table to the new one.

Then manually copy your required ddd,ddm,ddx files back to get the layouts as required.

Hope this is of use to you.

Ron




'-----------------------------------------------
function copy_table as L(copy_from as C,copy_to as C, copy_data as L,copy_rules as L)
'-----------------------------------------------
on error goto error_handler
dim quit_option as C

'-----------------------------------
' validate file extensions
'-----------------------------------
if at(".dbf",copy_to)