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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (General)
 How do I create a dbs file for my MOD?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

madfiddler
Starting Member

United Kingdom
33 Posts
Posted - 21 November 2003 :  05:21:51  Show Profile

How can I add a numeric field to an existing table that has 2 decimal places using a dbs file?

I did find some documentation for the format of a dbs file but it seemed rather minimal to me.

thanks
mf

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 21 November 2003 :  07:12:41  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message 
[ALTER]
TABLENAME
ADD#FIELDNAME#int#NULL#0#
[END]


The code above would add the field FIELDNAME to the table TABLENAME. The field is integer, does allow NULL (if you don't want allow the field to be NULL replace NULL by NOT NULL) and the default value is set to 0.

Hope that helps.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

Cliff
Average Member

United States
501 Posts
Posted - 21 November 2003 :  07:43:36  Show Profile  Visit Cliff's Homepage
Here's another page that might help too.
link changed by admin
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=18522
Go to Top of Page

madfiddler
Starting Member

United Kingdom
33 Posts
Posted - 21 November 2003 :  09:19:52  Show Profile
Sorry OneWayMule, I don';t think you read me e-mail correctly. I don't want an integer field. I want a data type that supports decimla places, eg in Access a "Single"

cheers
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 21 November 2003 :  10:53:06  Show Profile  Visit HuwR's Homepage
well, then just write single instaed of int, however the dbs file my not work on all database if you do, because it will not translate the datatype.

It is very minimal as it is designed for the forum which does not use floating point numbers
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.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07