Page 1 of 1
How to work different table and field names
Posted: Sat 02 Jan 2016 10:21
by cointec
Hello, I'm in process of migrating one database from Firebird to Oracle in order to work with the two engines from my application.
Firebird has a limit of 31 char for tables and field names, and Oracle has a limit of 30 char for the same.
I have some tables and some fields in firebird of 31 char, and in the migration process to Oracle I'm truncating them.
How is the best way to work with tables/fields from UniDac?
Re: How to work different table and field names
Posted: Sun 10 Jan 2016 22:38
by cointec
No comments?
Is not posible through macros?
Re: How to work different table and field names
Posted: Mon 11 Jan 2016 06:49
by AlexP
Hello,
Please describe in more details the behavior you want to implement - and we will try to help you resolve the issue.
Re: How to work different table and field names
Posted: Mon 11 Jan 2016 18:51
by cointec
I have a table in a firebird database whose length is 31 characters. For Example
TABLE_XXXXXXXXXXXXXXXXXXXXXXXXY
I have migrated the table to Oracle, but Oracle only admit 30 char for objects. Then the migrated table in Oracle is
TABLE_XXXXXXXXXXXXXXXXXXXXXXXX
I have a form that select, insert, Update and delete from that table. With UniQuery, I want to know if there is one option, that depending on the engine, I can change the part from SQL, SQLInsert, ... where appears the table name via macros.
It also happen with some table fields that are 31 char long.
Thank you.
Re: How to work different table and field names
Posted: Tue 12 Jan 2016 12:49
by AlexP
If you want to use both databases simultaneously without modifying queries, you can use macros
https://www.devart.com/unidac/docs/?unisql.htm .