The option (Copy Proc Exec) does not work when there are output parameters.

richardcrossley / aseisql

Automatically exported from code.google.com/p/aseisql

0 stars 0 forks source link

The option (Copy Proc Exec) does not work when there are output parameters. #40

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

What steps will reproduce the problem?

The option "context menu -> SQL -> Copy proc exec" fails when the stored
procedure has output parameters.

What is the expected output? What do you see instead?

Output:
"Ase isql-Error"
"Syntaxis error: waiting for keyword OUT[PUT], received: INT"

What version of the product are you using? On what operating system?

Trunk 132

Original issue reported on code.google.com by zluis0@gmail.com on 8 Oct 2009 at 10:09

Attachments:

[Copy Proc Exec.JPG](https://storage.googleapis.com/google-code-attachments/aseisql/issue-40/comment-0/Copy Proc Exec.JPG)
Error.JPG

GoogleCodeExporter commented 8 years ago

Could you also attach the text of the stored procedure? or just a header...

Original comment by daggett....@gmail.com on 9 Oct 2009 at 5:39

Changed state: Feedback

GoogleCodeExporter commented 8 years ago

CREATE PROCEDURE USP_EXAMPLE
@PARAM UNSIGNED INT = 1
AS
SELECT @PARAM

The problem is not with the output parameters.

It is with the composite data types. (UNSIGNED INT)

Sorry for my mistake.

Original comment by zluis0@gmail.com on 9 Oct 2009 at 1:25

GoogleCodeExporter commented 8 years ago

I only found four data types composed of two words.

(unsigned smallint, unsigned int, unsigned bigint, unsigned tinyint)

Original comment by zluis0@gmail.com on 9 Oct 2009 at 3:13

GoogleCodeExporter commented 8 years ago

Original comment by daggett....@gmail.com on 10 Oct 2009 at 6:45

Changed state: Accepted

GoogleCodeExporter commented 8 years ago

fixed in revision #134

Original comment by daggett....@gmail.com on 10 Oct 2009 at 2:59

Changed state: Fixed