Posted by: augustose <Augu...@gmail.com> 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