Question: While loop problem 
Author Message
 Question: While loop problem

Hi,

Does any one know what's wrong with this piece of sp_procedure?

        while <Test condition>
        begin
                {other statements}
                alter table mytable add newcolumn int null
                {other statements}
        end

I got the error message:
        >Msg 2716, Level 16, State 1:
        >Procedure 'xxxxxx', Line 27:
        >Column or parameter #1: -- can't specify a column width on type  
        'int'.

Thanks in advance,

==================
Wei T. Shao



Mon, 07 Aug 1995 08:41:59 GMT
 Question: While loop problem

Would it be possible to post the whole sp?

Mark



Mon, 07 Aug 1995 23:35:06 GMT
 Question: While loop problem

|>Path: pnl-oracle!ogicse!emory!gatech!usenet.ins.cwru.edu!howland.reston.ans.net!wupost!csus.edu!netcom.com!netcomsv!oceania!wei

|>Newsgroups: comp.databases.sybase
|>Subject: Question: While loop problem

|>Date: Wed, 17 Feb 93 16:41:59 PST
|>Article-I.D.: oceania.C2MCM5.EIs


|>Distribution: na
|>Organization: Oceania Health Care Systems
|>Lines: 25
|>
|>Hi,
|>
|>Does any one know what's wrong with this piece of sp_procedure?
|>
|>   while <Test condition>
|>   begin
|>           {other statements}
|>           alter table mytable add newcolumn int null
|>           {other statements}
|>   end
|>
|>I got the error message:
|>   >Msg 2716, Level 16, State 1:
|>   >Procedure 'xxxxxx', Line 27:
|>   >Column or parameter #1: -- can't specify a column width on type  
|>   'int'.
|>
|>
|>
|>
|>Thanks in advance,
|>
|>==================
|>Wei T. Shao

|>
        "You must use fully qualified table names when using 'Utility'
        commands..."

        try:
                alter table mine.mytable add newcolumn int null
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        To Thyne Own Self be true...
                                     myne opinions are.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Tue, 08 Aug 1995 01:16:30 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Looping within a Loop

2. Loops will not loop any more

3. Help Help For Loops and incrementing fields each loop

4. Need help with a loop script (won't loop)

5. HELP (VFP3) My Loop Doesn't Loop?

6. Question: WHILE loop nesting in stored procedures

7. While loop curosr question...

8. while loop question...

9. Stored procedure looping question

10. Question about manipulating WHILE loop condition

11. Query / Loop Question

12. a loop question


 
Powered by phpBB® Forum Software