View Single Post
  #2 (permalink)  
Old May 15th, 2006, 03:53 PM
BigOcean BigOcean is offline
Authorized User
 
Join Date: Nov 2003
Location: Ellicott City, Maryland, USA.
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi davwein,

The code statements of Using Views on Page 41 do not work in my Windows XP Pro PC that is on Microsoft Windows NT 4 LAN Syste. I got the following error messages in Parse or Execute without Results:

Msg 156, Level 15, State 1, Procedure InventoryPublisherView, Line 3

Incorrect syntax near the keyword 'SELECT'.

Msg 111, Level 15, State 1, Procedure InventoryPublisherView, Line 6

'ALTER VIEW' must be the first statement in a query batch.

I want to try your modified code statements (that worked in your PC/system - what kind of your PC and LAN System did yopu use?)in my PC. Please post your complete modified code statements on this Forum.
Thanks,
Scott Chang



Scott Chang
Reply With Quote