Ignored RESULT(...) section in procedure

#1

Hi,all!
I have this procedure:

ALTER PROCEDURE "DBA"."___any_test"()
result(var_one integer,var_two integer)
begin
select 5 as fieldone,3 as fieldtwo
end

how discribed in this document (http://dcx.sybase.com/html/dbugen10/ug-
ptrrmr.html) call of my procedure had to return this result:
[var_one] => 5
[var_two] => 3

But it returns this:
[fieldone] => 5
[fieldtwo] => 3

It ignore Result section at all!
Why?

phpinfo:
Apache Version Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13

sqlanywhere
SQLAnywhere support enabled
Allow Persistent Connections Yes
Persistent Connections 0/unlimited
Total Connections 0/unlimited
PHP SQLAnywhere driver version 2.0.4.0
SQLAnywhere client version 11.0.0.1264

--
Thanks and sorry for my english-)

#2

Please don't crosspost. See my response in the
sybase.public.sqlanywhere.general forum.

elias wrote:

Quote:

Hi,all!
I have this procedure:

ALTER PROCEDURE "DBA"."___any_test"()
result(var_one integer,var_two integer)
begin
select 5 as fieldone,3 as fieldtwo
end

how discribed in this document (http://dcx.sybase.com/html/dbugen10/ug-
ptrrmr.html) call of my procedure had to return this result:
[var_one] => 5
[var_two] => 3

But it returns this:
[fieldone] => 5
[fieldtwo] => 3

It ignore Result section at all!
Why?

phpinfo:
Apache Version Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13

sqlanywhere
SQLAnywhere support enabled
Allow Persistent Connections Yes
Persistent Connections 0/unlimited
Total Connections 0/unlimited
PHP SQLAnywhere driver version 2.0.4.0
SQLAnywhere client version 11.0.0.1264

--
Thanks and sorry for my english-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Ignored RESULT(...) section in procedure

sybase.public.sqlanywhere.linux sybase.public.sqlanywhere.linux

Ignored RESULT(...) section in procedure - 02-09-2009 , 08:07 AM

Re: Ignored RESULT(...) section in procedure - 02-09-2009 , 09:12 AM