Hi, I'm newbie with Gupta and SAL, and I need to create some stored
procedures.
Perhaps some one can help me with this issue.
The objectives of my procedures are:
- return a set of multi-fields records
- create data inside the procedure, not exactly from the tables.

I need some tips to use SQL Console and SQL Talk ( I already
downloaded WinSQL

I' trying with this procedure

/*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
PREPARE
PROCEDURE: PART_INPROC
Parameters
String: sName
Receive Number: nStock
Local Variables
Sql Handle: hSqlCur1
String: sSelect
Number: nInd
Actions
On Procedure Startup
Call SqlConnect(hSqlCur1)
Set sSelect = 'Select QTY_ON_HAND from PART \
where DESCRIPTION = :sName into :nStock'
Call SqlPrepare(hSqlCur1, sSelect)
On Procedure Execute
Call SqlExecute(hSqlCur1)
On Procedure Fetch
If NOT SqlFetchNext(hSqlCur1, nInd)
Return 1
Else
Return 0
On Procedure Close
Call SqlDisconnect(hSqlCur1)
;

if I call the
perform PART_INPROC;
the SQLTalk gives me the form to enter the parameters. and after put
the parameter, It gives me no result

if I use
perform PART_INPROC
\
'STAINLESS STEEL',0,
/;
or
perform PART_INPROC
\
STAINLESS STEEL,,
/;
or
perform PART_INPROC
\
STAINLESS STEEL,0,
/;


it Gives me the same message
Data not specified for all columns in the last row.


thanks in advance for any help

Augusto