Adding fields from another database without creating a new table
padmathiagarajan
Forums
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
Hi Padma,
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