Using an underscore in the company id

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have a customer that used an underscore in their company id when they setup a new company. Is this going to cause any issues down the road when updating GP?

*This post is locked for comments

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Using an underscore in the company id

Thanks to all that replyed.

I tested this by creating a company with an id of w_r in my GP2013 test install. I then upgraded my GP2013 install to GP2015 with no problems.

Bill
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Using an underscore in the company id

I concur with Ian. You shouldn't have an issue with any character that is not a SQL Reserved or Special character. See these links for a list of each - technet.microsoft.com/.../aa274626%28v=sql.80%29.aspx; technet.microsoft.com/.../aa226544%28v=sql.80%29.aspx
Suggested answer

Ian Grieve 22,782 on at

Like (0)

Report

RE: Using an underscore in the company id

No, you should not have problems with an underscore.
Suggested answer

Bill Campbell 22,647 on at

Like (0)

Report

RE: Using an underscore in the company id

That is an interesting question, but we would have to believe that "if the application allowed it at the time of creating the database ID" then it should not be an issue into the future.

Having said that - note the quotes - we have never used anything but proper characters in the name of the database - that has been our company practice over the past 20 plus years. However, for the sake of interest and testing I did create a company and did not get any errors.

We have avoided the use of anything but characters and therefore have not experienced any issues - sorry if this is not what you needed, but more a comment on our practice.

If this helps you please mark as answer.