I have a solution, I build a list of fields instead of the ' * ', using the following SQL....

SELECT rdb$Field_Name AS FieldsName

FROM rdb$Relation_Fields

WHERE RDB$Relation_Name = :aTableName AND Rdb$Update_Flag > 0

ORDER BY Rdb$Field_ID;


It seems that the Rdb$Update_Flag field is 1 for read / write fields and 0 for read only fields. This seems a good solution except... 'The Firebird Book' states this field is 'Not used in Firebird'. Am I going to have problems or is this a error in the book?

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd

----- Original Message -----
From: Robert martin
To: IBObjects@yahoogroups.com
Sent: Monday, November 15, 2004 2:13 PM
Subject: [IBO] IB_Pump


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




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]