Can you clarify what you mean by "pre-set"? What are you trying to do?

 

Sorry, now more verbose:

1. Open Sybase 15 DB tree (with v. 16.0.8)

2. Right click on procedure that has [n][var]char() variables declared and select "Debug in Procedure Debugger"

3. Click Start, the "Execute" window opens but does not display  [n][var]char() variables to edit (thats what I meant with pre-set)

* Tried workaround with loading debug file, but here also no [n][var]char() variables are displayed.

* In v.15.0.13 everything works fine.

 

 

 

 

Under Sybase ASE v16 in AWS 1.69 I created a procedure under the pubs3 database named p13769. It has 3 arguments passed nchar(5), varchar(5) and char(5). When the debugging starts in ADS v16.0.8 the parameter for nchar() is missing in the parameters window.

In ADS v15 this works fine.

Works in ADS v16-0-3-4 and not in ADS 16.0.3-5 [2015-Apr-03 10:59:22 AM and Build #: 43326]

Verified in ADS v16.0.9

We have released the 16.0.9 patch which addresses a critical fix for Oracle Procedure Debugger and a few other defects in Aqua Data Studio.  We have fixed the Sybase ASE Procedure Debugger, which was not displaying all the declared parameters in the Debugger window.

Patch: http://www.aquafold.com/download/v16.0.0/ads-16.0.9-patch.zip
Update Instructions: http://www.aquafold.com/support-update.html#v16

Changelog: http://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/changelog/page/Version-16.0/Version-16-0

Regression testing on Stored procedure

A)Right click on below created procedure and select debug in procedure debugger option.
click on start icon in debugger window.
Stored procedure debug successfully

 

B)Right click on all data types procedure and select edit in procedure editor option
Procedure  window window opens.
Click on Execute procedure icon.
You will observed that,All data types are displayed in execute edit window.
 

Execute above steps(A,B) for below mentioned scripts:

Scenario-01

 

Create table:

 

CREATE TABLE "dbo"."test_company"  (

"empid"     bigint DEFAULT     20 NOT NULL,

"c_name"    varchar(100) DEFAULT     'dimentrix1' NOT NULL,

"c_address" varchar(25) DEFAULT     'dimentrix' NOT NULL,

CONSTRAINT "c_name" PRIMARY KEY CLUSTERED("c_name")

WITH max_rows_per_page = 0, reservepagegap = 0

)

GO

CREATE TABLE "dbo"."test_employee"  (

"id"     bigint NOT NULL,

"f_name" varchar(25) NOT NULL,

"salary" int NOT NULL,

CONSTRAINT "id" PRIMARY KEY CLUSTERED("id")

WITH max_rows_per_page = 0, reservepagegap = 0

)

GO

 

CREATE PROCEDURE "dbo"."Test_emp_SP"

as

    begin

         select empid,c_name

         from test_company where c_name="aquafold"

         select id, salary

         from test_employee where salary > 1000

         return 0

    end

GO

sp_procxmode '"dbo"."Test_emp_SP"', 'Unchained'

GO

 

CREATE PROCEDURE "dbo"."test_numeric_"

         ( @myparam1  money,

           @myoutparam int output )

    as

         select @myoutparam=count(*)

         from dbo.test_company

         where empid=@myparam1

GO

sp_procxmode '"dbo"."dbo"."test_numeric_”'

GO

 

Scenario-02:

Extra Test:

A)Right click on "dbo"."test_numeric_" and select debug in procedure debugger option.
click on start icon in debugger window.
Execute window opens
add parameters and click on execute button.
store procedure debug successfully
Added values are reflected successfully in table.

 

B)Right click on created procedure and select edit in procedure editor option
Procedure  window window opens.
Click on Execute procedure icon.
Execute window opens
add parameters and click on execute button.
store procedure debug successfully
Added values are reflected successfully in table.

 

CREATE TABLE dbo.address_book  (

id          int NOT NULL,

f_name      nchar(5) NOT NULL,

L_name      unichar(25) NOT NULL,

state1      nvarchar(25) NOT NULL,

maildomain money NOT NULL,

mailserver float(8) NOT NULL,

MailAddress float(8) NOT NULL,

CompanyName char(5) NOT NULL,

Ldate       date NOT NULL

)

LOCK ALLPAGES

GO

 

CREATE PROCEDURE dbo.QEUpdateaddrbook(@id int,@FirstName nchar(20),@LastName unichar(20),@MailDomain Money,

@MailServer float,@MailAddress float,@CompanyName char(20),

@State nvarchar(20),

@date date)

as

UPDATE dbo.address_book1 SET

id=@id,L_name=@LastName,state1=@State,maildomain=@MailDomain,

mailserver=@MailServer,MailAddress=@MailAddress,CompanyName=@CompanyName,Ldate=@date

WHERE

f_name=@FirstName

GO

 

Scenario-03:

Extra test:

 

A)Right click on "dbo"."QEUpdateaddrbook" and select debug in procedure debugger option.
click on start icon in debugger window.
Click on Toggle  breakpoint icon

Break-point apply on procedure body.
click on start icon in debugger window.
Execute window opens
add parameters and click on execute button.
Go to console pane
Switch to break-point tab:Displayed applied breakpoint line number.

Switch to Variable tab:Displayed variables with  values and respective data types.
Right click on any variable and select Add watch option
Selected variable is added in watch tab.
Switch to stack frames,displayed procedure name and breakpoint line number in stack fames.
Switch to profile,Displayed time duration of procedure execution(Module,Time.Start line,End line,Elapse(Ms),Source).

 

B)A)Right click on "dbo"."test_SP" and select debug in procedure debugger option.
click on start icon in debugger window.
Click on Toggle  breakpoint icon

Breakpoint apply on procedure body.
click on start over(F8) icon.
source body is debugging successfully.
 

SQL Script:

 

CREATE PROCEDURE dbo.QEUpdateaddrbook(@id int,@FirstName nchar(20),@LastName unichar(20),@MailDomain Money,

@MailServer float,@MailAddress float,@CompanyName char(20),

@State nvarchar(20),

@date date)

as

UPDATE dbo.address_book1 SET

id=@id,L_name=@LastName,state1=@State,maildomain=@MailDomain,

mailserver=@MailServer,MailAddress=@MailAddress,CompanyName=@CompanyName,Ldate=@date

WHERE

f_name=@FirstName

GO

 

CREATE PROCEDURE dbo.test_SP

as

if (select max (empid1) from test_project) <2

   print "No user-created objects in this database" else

   print "These are the user-created objects"

   select *

   from test_project where empid1>1

Go