We have a routine that allows for table records to be exported to a .d file and then Imported into tables in a different DB, all very simple I hear you say! Well it's never that straightforward is it...
We have a table called order and a table called orderh when orders reach a certain status they are copied to orderh and order deleted, they are supposed to identical but it turns out that orderh has an additional field.
My export of orderh excludes the additional field so in theory its the same as order. When we import into the new DB we put orderh records into order. This has happily chugged along for a while but I've now noticed a record where data is ending up in the wrong fields on the order table.
I have noticed that the order# and position values of the fields in the two tables do not match up for some of the fields does anyone know if this or anything else would cause this type of problem when exporting and importing data?
TIA
We have a table called order and a table called orderh when orders reach a certain status they are copied to orderh and order deleted, they are supposed to identical but it turns out that orderh has an additional field.
My export of orderh excludes the additional field so in theory its the same as order. When we import into the new DB we put orderh records into order. This has happily chugged along for a while but I've now noticed a record where data is ending up in the wrong fields on the order table.
I have noticed that the order# and position values of the fields in the two tables do not match up for some of the fields does anyone know if this or anything else would cause this type of problem when exporting and importing data?
TIA