Subject | IB_Pump |
---|---|
Author | Robert martin |
Post date | 2004-11-15T01:13:56Z |
Hi All
I am using the IB_Pump to pump data from one table to another. I do this in
a loop for a number of tables using the following SQL as the source cursors
sql.
SELECT * FROM ' + FieldByName('TableName').AsString
Problems occur when the source table contains COMPUTED fields, the pump
crashes. Given that the table structures will change over time, how do I
avoid this problem?
I had thought of Joining RDB$Relation_Fields but dont see any field that
identifies this as a COMPUTED Field.
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd
I am using the IB_Pump to pump data from one table to another. I do this in
a loop for a number of tables using the following SQL as the source cursors
sql.
SELECT * FROM ' + FieldByName('TableName').AsString
Problems occur when the source table contains COMPUTED fields, the pump
crashes. Given that the table structures will change over time, how do I
avoid this problem?
I had thought of Joining RDB$Relation_Fields but dont see any field that
identifies this as a COMPUTED Field.
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd