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: MOD Implementation
 DBS File Problem....		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  17:30:20  Show Profile  Visit crash's Homepage
hi! i want to add a table to my DB called PM_IGNORE and i wrote a DBS for it:
Adding Table PM_IGNORE
[CREATE]
PM_IGNORE
PM_ID
MEMBER_ID#INT##0
IGNORE#VARCHAR(50)#NULL#
[END]

no matter how or what i try, the DBS setup always tells me that the table already exists, while it does not.

i tried various kinds of moving around the PM_ID and adding #INT#NULL# behind it, but all to no avail.

i am desparate here... can anybody please help me?



Crash's Site | Crash is from

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  17:32:53  Show Profile  Visit crash's Homepage
maybe a stupid question, but isn't the file actually ignoring it because of the table title?



Crash's Site | Crash is from
Go to Top of Page

karyna
Starting Member

France
10 Posts
Posted - 30 April 2002 :  17:50:25  Show Profile  Visit karyna's Homepage
j'ai déjà eu le problème le seul moyen c'est de la créer dans access directement !
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  17:55:34  Show Profile  Visit crash's Homepage
excuse me?



Crash's Site | Crash is from
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  17:56:30  Show Profile  Visit crash's Homepage
talk english please... i don't speak dutch to you either.

Creating table(s)...
CREATE TABLE FORUM_PM_IGNORE( PM_ID int IDENTITY (1, 1) NOT NULL , MEMBER_ID int NULL DEFAULT 0, IGNORE varchar(50) NULL )
Table already exists





Crash's Site | Crash is from
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 30 April 2002 :  18:00:07  Show Profile
what database are you using?

Also, read this:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26081

Try using the updated MOD Setup that I have a link to in that topic.
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  18:03:03  Show Profile  Visit crash's Homepage
i use an Access 2000 DB for the test



Crash's Site | Crash is from
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts
Posted - 30 April 2002 :  18:05:23  Show Profile  Visit crash's Homepage
Richard, the new version of the MOD setup did the trick! thanks!



Crash's Site | Crash is from
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.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07