Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Help adding fields in MS SQL		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

texanman
Junior Member

United States
410 Posts
Posted - 18 June 2008 :  08:36:57  Show Profile
I would like add reference name (refname), phone (refphone), & e-mail (refemail) in two Tables: Members and Members_pending.

Can anyone help?

Thanks<

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 18 June 2008 :  08:57:44  Show Profile  Send ruirib a Yahoo! Message
Just run this from the alternate mod setup window, in Admin Options:

[ALTER]
MEMBERS
ADD#refname#varchar(100)#NULL#
ADD#refphone#varchar(15)#NULL#
ADD#refemail#varchar(50)#NULL#
[END]

[ALTER]
MEMBERS_PENDING
ADD#refname#varchar(100)#NULL#
ADD#refphone#varchar(15)#NULL#
ADD#refemail#varchar(50)#NULL#
[END]

Feel free to change field sizes, if that suits you better.
<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 18 June 2008 :  09:03:19  Show Profile
Thanks ruirib.
You are great.<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 18 June 2008 :  09:34:30  Show Profile  Send ruirib a Yahoo! Message
You're welcome.<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 18 June 2008 :  10:53:51  Show Profile
Ruirib
To be consistent with the other names, do I need to add the prefix M_ before each name?<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 18 June 2008 :  10:58:25  Show Profile  Send ruirib a Yahoo! Message
If you want to, you can, just change the name in the script. I like consistency.<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 18 June 2008 :  11:03:09  Show Profile
cool. just like m_refname. Does case matter? M_REFNAME?<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 18 June 2008 :  11:06:53  Show Profile  Send ruirib a Yahoo! Message
No, case does not matter, unless you're using MySQL in a Linux server.<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 18 June 2008 :  11:07:49  Show Profile
Thanks again.
I am using MSSQL.
<
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07