Alter Table

  • Thread starter Thread starter MDB
  • Start date Start date
M

MDB

I just upgraded my mobile DBs to 3.0 and CF 2.0 and am now having problems
altering tables. If I run the sql form Query Analyzer 3.0 or from Microsoft
SQL Server Management Studio the sqls run fine however, if I run it from
within my application it never alters the table and always returns -1 with
no error. Below is how I am running it in my code, anyone have any ideas
why it isn't working?


SqlCeCommand dc = new SqlCeCommand(sql, conn, trans);
intResult = dc.ExecuteNonQuery();
dc.Dispose();

sql = ALTER TABLE company ADD COLUMN base_latitude nvarchar(20);


TIA
 
You do have quotes around the SQL string, right?

Ginny

MDB said:
I just upgraded my mobile DBs to 3.0 and CF 2.0 and am now having problems
altering tables. If I run the sql form Query Analyzer 3.0 or from
Microsoft
SQL Server Management Studio the sqls run fine however, if I run it from
within my application it never alters the table and always returns -1 with
no error. Below is how I am running it in my code, anyone have any ideas
why it isn't working?


SqlCeCommand dc = new SqlCeCommand(sql, conn, trans);
intResult = dc.ExecuteNonQuery();
dc.Dispose();

sql = ALTER TABLE company ADD COLUMN base_latitude nvarchar(20);


TIA
Click to expand...

--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management
 
I don't know why this should fail for you. Do you only have the problem with
upgraded databases? I didn't have any problem with similar code using a new
database, although intResult returns -1 even when the new column is added.

Ginny

MDB said:
Yes
Click to expand...

--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management
 
The results didn't use to return -1 on a alter table , since it is now
returning -1 even though it was sucessful, I was rolling back the
transaction which is way it was appearing not to run. I just changed my
function to return 1 if it is an alter or create. Thanks
 
I'm glad you've got it working. Thanks for reporting back.

Ginny

MDB said:
The results didn't use to return -1 on a alter table , since it is now
returning -1 even though it was sucessful, I was rolling back the
transaction which is way it was appearing not to run. I just changed my
function to return 1 if it is an alter or create. Thanks
Click to expand...

--

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management
 
Back
Top