Solved

Creating New Column within Contact 2 Table

Posted on 2011-03-15
5
710 Views
Last Modified: 2013-11-15
Hi Guys,

I have a requirement to create a new column in the Contact 2 table and usually I do this in goldmine. By doing this process in Goldmine, Im required to get everyone out of Goldmine which is not doable during office hours.

Ive read I can create the column via the SQL manager but Im just wondering when doing it this way, is the process any different from doing within goldmine apart from everyone logging out of goldmine.

Also, when creating the table via the SQL manager and not via goldmine, will this make any differences to the way reports find data in my various tables/columns etc?

And finally, will these cause any problems on the live environment - last thing I want is when I create the table - everyone gets booted out of goldmimne.

Thanks
0
Comment
Question by:daiwhyte
  • 2
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
GMGenius earned 250 total points
ID: 35137096
You can add the new field as follows:-

Create the field in GoldMine but "DO NOT REBUILD" - when prompted select No

Add field via SQL Managment studio - make sure you select to correct field type

Log out of GoldMine then log back in
0
 
LVL 11

Assisted Solution

by:stevengraff
stevengraff earned 250 total points
ID: 35137098
Dave, you can do it this way, but you MUST be very careful!!! I have seen systems where otherwise, and it's not pretty, nor easy to fix!

1. Start the field creation process in GoldMine, taking note EXACTLY of field name, type, and size, i.e. UNEWFIELD, Character, 9. Do everything you normally would, up to the point of doing the rebuild. When GoldMine prompts you to rebuild, say No.

2. Next, in SQL, insert the field into your Contact2 table, exactly as you defined it in GoldMine. Then save the table.

3. Log out of GoldMine, the re-log in.

4. You should now be able to place the field on your screen; and no one has had to get out of GoldMine.

The tricky part is probably the data type to use in SQL. When you create a character field in GoldMine, SQL calls it "varchar." The default in SQL is 50, but you must change this to match the size you chose in GoldMine.
0
 

Author Comment

by:daiwhyte
ID: 35137176
Thank you both for coming back so quickly - looks like you are both offering to do the same solution here.

Just to recap,

Im creating a column called timeod as a varchar with 20 characters.

In goldmine, go to custom fields and create a new field
Field name: UTIMEOD
Description: TimeOD
Field Type is: Character
Len is set to 20

Got into SQL manager
Drill down to dbo.Contact2
Right click on columns and select new column
Tyoe into the blank field at the bottom of the Column Name Column UTIMEOD
In data type column, locate the Varchar 50 and select that, then edit the 50 value to 20.
Close the screen and accept the option to save changes.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 35137250
Yes.

Then you can place the field onto the GoldMine screen.

If you place the field onto the GoldMine screen it may say n/a. No problem, just get out and log back in.
0
 

Author Closing Comment

by:daiwhyte
ID: 35149955
Thank to the both of you, worked a charm.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help with a query 6 74
MS SQLK Server multi-part identifier cannot be bound 5 36
How can i use WITH CTE for checking exist value? 3 34
Help Required 2 33
Read about achieving the basic levels of HRIS security in the workplace.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question