I'm trying to add a column to a table that has a blob field in it. But when I copy the old table to the new one, it doesn't bring over the blob field. I use the following commands to do this:
tsql "create table newtable (field1 counter,field2 blob, newfield varchar(20))"
tsql "insert into newtable select field1,field2,'newfield' from sites"
tsql "drop table sites"
rename newtable.tbl sites.tbl
addtable sites.tbl
tsql "drop table newtable"
Do I need to add some commands to save the old blob file?
tsql "create table newtable (field1 counter,field2 blob, newfield varchar(20))"
tsql "insert into newtable select field1,field2,'newfield' from sites"
tsql "drop table sites"
rename newtable.tbl sites.tbl
addtable sites.tbl
tsql "drop table newtable"
Do I need to add some commands to save the old blob file?
