RE: Help me about execute procedure in 4gl using 4Js

You probably need to use a prepared statement to execute it.
 
For example:
Define dy char(500)
 
Let dy="execute procedure pname(..)"
Prepare dy_ptr from dy
Declare dy_cur cursor for dy_ptr
Open dy_cur
  Fetch dy_cur into r1, r2,..
Close dy_cur
 
If your stored procedure does not return any values, you can just execute
dy_ptr and then free dy_ptr.
 
Hope this helps.
Jose F. Osorio 
Astra Information Systems, Inc. 
1920 North Commerce Parkway, Suite 2. 
Weston, FL 33326 
Ph: 954.233.5500 Ext: 108 
Fax: 954.233.5501 
mailto:[email protected] 
www.astrainfo.com 
 
  _____  

From: [email protected] [mailto:[email protected]] On
Behalf Of Jupiracy Da Silva Costa
Sent: Thursday, October 06, 2005 12:39 PM
To: [email protected]
Subject: [fourjs-users] Help me about execute procedure in 4gl using 4Js
 
I am trying compile a program 4GL that use un statement execute procedure,
and I receiving the folling error:
 
| A grammatical error has been found at 'sp_glidepar' expecting: ACCEPT
ALTER BEGIN BREAKPOINT CANCEL CALL CASE CLEAR CLOSE COMMIT CONNECT ...
| See error number -6609.
 
The Store Procedure receives two parameters and return two parameters.