ALTER statements bug

PowlinPowlin Posts: 42 Bronze 3
edited August 18, 2009 11:16AM in SQL Prompt Previous Versions
I'm not sure if it's a bug, but it don't seem very usefull them.

When using the ALTER statements features I could write

ALTER PROC getEmploye <then press my completion key>

and the whole getEmploye proc get detailed like this

ALTER PROC getEmploye(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe

But If I'm modified another proc for example getEmployeDossier here's is the code

ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe

And I want to add a call to the getEmploye
I add this :
EXEC getEmploye<then press my completion key>

normally it would complete the getEmploye name, but when the ALTER statements is enabled the whole code from getEmploye is added
like this :

ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 -- int
(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe

The result I wanted was this :

ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 --int

Thanks

Comments

  • Thanks for your post and detail explanation.

    I was able to reproduce the issue very easily.

    I have logged this issue in our internal tracking system so that it can be fixed in our next release.Sorry for any inconvenience caused by this issue.

    For your reference unique Id for the bug is SP-2767.

    Kindly let me know if you have any other issues regarding SQL Prompt, I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.