Stored Procedure creation

[dgillz]

I am trying to create an SP using Pervasive SQL v8.5. I cannot figure out what I am doing wrong. Here is my code:

CREATE PROCEDURE UpdatePoStatus() 
returns(select ord_no char(8) from POORDHDR_SQL)

I am getting this error:
"ODBC Error: SQLSTATE = S1000, Native error code = -5099
2: 'select': Syntax error"

Any ideas?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[mirtheil]

Can't do that. It would need to be:

CREATE PROCEDURE UpdatePoStatus()
returns(ord_no char(8))
as 
begin
select ord_no char(8) from POORDHDR_SQL;
end;

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[dgillz]

I am now getting the following error:

ODBC Error: SQLSTATE = S1000, Native error code = -5099
Syntax Error: SELECT ord_no char<< ??? >>( 8) from POORDHDR_SQL

I cut and paste your code exactly. Any ideas what is wrong?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[zemp]

Try removing the 'char(8)' from your select statment.

zemp

 

[mirtheil]

Yep.. Sorry about that.. Zemp's right. It should be:

CREATE PROCEDURE UpdatePoStatus()
returns(ord_no char(8))
as
begin
select ord_no from POORDHDR_SQL;
end;

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[dgillz]

How do I create a simple procedure that not only returns a value, but updates a value?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[mirtheil]

WHat do you mean by update a value? Are you talking about what's sent back to the application or updating a value in the database?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[dgillz]

In MS SQL, I can do this easily:

Update POORDHDR_SQL
Set Status='P'
Where Status='R'

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[zemp]

The syntax for an update SQL statement in MS SQL Server and Pervasive are virtually the same.



zemp