TIBCLoader and case dependent identifiers (Dialect 3)

[petersen]

(IDBAC 5.2.6 for XE5)

hi

we use your "TIBCLoader" component to copy table contents from one database to another (with the same table-structure) using its "LoadFromDataset" method. therefor we first execute a query (TIBCQuery) like "SELECT * FROM TEST" on the source database and than use something like TIBCLoader.LoadFromDataSet(TIBCQuery) where TIBCLoader is connected to the destination database. everything works like expected!


when it comes to tables with case depending identifiers (table and field names), we run into trouble. the table name could be set with TIBCLoader.TableName := '"Test"' without a problem (all columns are created as expected).

but executing TIBCLoader.LoadFromDataSet(TIBCQuery) will throw an exeption, because it expected a field like "TESTFIELD" for instance - but the actual fieldname is "TestField".

changing the fieldname from TIBCLoader.Columns.Items[FieldIndex].Name := 'TestField' to TIBCLoader.Columns.Items[FieldIndex].Name := '"TestField"' let the TIBCLoader executes without an error -> but no data is copied?!

can you please give us a hint how to handle this situation?!

thank you

[PavloP]

To solve the problem, set the QuoteNames property of the TIBCLoader component to True:

Code: Select all

    IBCLoader1.Options.QuoteNames := True;

[petersen]

...

yep - that little "trick" solved it! thanks!!!

[PavloP]

It is good to see that the problem has been solved.