Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [webmaster33] Problem creating table

Quote Reply
Re: [webmaster33] Problem creating table In reply to
OK, so if I hit Submit It says

All Authentication options have been updated successfully.

The same page loads again...still no EXTRA field

Then I choose the table I just made from the pulldown and hit properties

Then I choose Add Column

The Add Column page loads without the EXTRA field.

If I try to add a Primary Key it says:

You can not add a primary key to an existing table.

And if I try to add the column as a regular column it says

Unable to add column 'test'. Reason: Failed to execute query: 'ALTER TABLE fdhgfdhg ADD test INT NOT NULL' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'tablename because this table does not exist in database 'hrapplications'. (SQL-42S02) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)
Subject Author Views Date
Thread Problem creating table afail77 7403 May 6, 2005, 10:38 AM
Thread Re: [afail77] Problem creating table
webmaster33 7294 May 6, 2005, 5:36 PM
Thread Re: [webmaster33] Problem creating table
afail77 7256 May 9, 2005, 5:21 AM
Thread Re: [afail77] Problem creating table
webmaster33 7253 May 9, 2005, 5:47 AM
Thread Re: [webmaster33] Problem creating table
afail77 7269 May 9, 2005, 5:51 AM
Post Re: [afail77] Problem creating table
webmaster33 7265 May 9, 2005, 6:38 AM
Thread Re: [webmaster33] Problem creating table
afail77 7243 May 9, 2005, 6:26 AM
Thread Re: [afail77] Problem creating table
604 7224 May 9, 2005, 3:43 PM
Post Re: [TheStone] Problem creating table
afail77 7249 May 10, 2005, 5:17 AM