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

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 SQL syntax		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

laser
Advanced Member

Australia
3859 Posts
Posted - 10 February 2004 :  20:00:03  Show Profile
I'm trying to use TableEditor to alter my database online. I'm using Access, but this statement won't work :

ALTER TABLE t_category ADD COLUMN alive boolean;

I keep getting the error :

Syntax error in field definition. records affected.

Any ideas ?? .. I need a boolean field called "alive" or anything similar, added to the t_category table.

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 10 February 2004 :  20:44:46  Show Profile
instead of boolean try using yesno
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 11 February 2004 :  03:44:23  Show Profile
Thanks Nikkol [:)} I was guessing it was something stupid like that
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.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07