|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Error In Alter Table Statement....
Hi, can someone with a little more experience help me with this statement:
ALTER TABLE Items (ADD COLUMN File_ID INTEGER, ADD COLUMN Retail_Price MONEY, ADD COLUMN Item_Weight INTEGER, ADD COLUMN Item_Max INTEGER, ADD COLUMN Item_Stock INTEGER, ADD COLUMN Item_Related TEXT(255)); error:Syntax error in ALTER TABLE statement. What am I doing wrong... is it not possible to add more then 1 column per query? Your help is much appreciated. -pb |
|
#2
|
|||
|
|||
|
PS I'm pretty sure I answered my own question. It semms to not be possible to add more then 1 column per query so I broke the statement up.
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Error In Alter Table Statement.... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|