Adding fields from another database without creating a new table

3 posts / 0 new
Log in or register to post comments
Last post
Sat, 01/06/2018 - 04:46
#1
padmathiagarajan
Offline
Joined: 07/02/2016 - 06:26
Adding fields from another database without creating a new table

Hi Brian,
While doing a Join to get a field from another database, a new database gets created. So there are multiple steps invovled in scripting due to this since i have to then delete the original database and then rename etc.
Is there a way to add a field to the existing database itself without creating a new database? Can i do this through script or custom function?
 
Regards
Padma

Top
Sat, 01/06/2018 - 08:41
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Padma,

Yes you can do this through a script but it can become quite complicated when compared with the deletion and renaming of the other databases.  If you are trying to avoid the join you would have to create the coding for the join in IDEAScript which would be much slower than having IDEA do it and very complicated.  So short answer is yes you could do it but I wouldn't recommend it, it is always best to use the functions available in IDEA as they will work faster and be more reliable.

Hopefully that answers your question.

Brian

Top
Sun, 01/07/2018 - 04:28
(Reply to #2)
padmathiagarajan
Offline
Joined: 07/02/2016 - 06:26

Thanks Brian. As you said i wanted to know if this is the best way of doing it. 

Top