Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kathyc2003
Starting Member
15 Posts |
 Posted - 2007-08-28 : 18:12:28
|
| Hello,I have written the query below to add a field to my sporttable called 'list', but am getting the error outlined below.What have I done wrong?$query = "ALTER TABLE sport ADD COLUMN list TEXT(3)";$result = odbc_exec($iConnect, $query) or die('Select failed!'); Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'., SQL state 37000 in SQLExecDirect in E:\inetpub\scripts\athlete\aa_sports_table.php on line 57Select failed! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-28 : 18:34:59
|
$query = "ALTER TABLE sport ADD list VARCHAR(3)";$result = odbc_exec($iConnect, $query) or die('Select failed!');
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Alter Table error