Wht's wrong with this sql statement. Does not run

• pmanisekaran

  SSC-Addicted

  Points: 401

  More actions

  May 1, 2003 at 5:50 pm

  #80709

  Hi

  Wht's wrong with this sql statement. Does not run on sql server 7.

  if not exists(SELECT * FROM [HISPos].[dbo].[syscolumns]

  where name='RecordVoidSale')

  begin

  alter table HISPOSControl add RecordVoidSale bit default 0

  update hisposcontrol set RecordVoidSale=0

  end

  Error says no column named RecordVoidSale

  Can you help me out?

  Regards

  Mani

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  May 1, 2003 at 7:44 pm

  #455963

  SQL Server is looking for the recordvoidsale column before it is added. Instead, try ....

  if not exists(SELECT * FROM [HISPos].[dbo].[syscolumns]

  where name='RecordVoidSale')

  begin

  alter table HISPOSControl add RecordVoidSale bit default 0

  exec ('update hisposcontrol set RecordVoidSale=0')

  end

  HTH

  Billy