problem with stored procedure

[Guillermo]

When i try to save the stored procedure sql says: the prefix of 'nros_internos'
column don't match with table name or alias used in query, but the columns
names are those, somebody can help me, please?

Create Procedure SP_BorradocCh
@soc_codigo int
As
DECLARE @che_nroint int,@che_escliente bit
DECLARE nros_internos CURSOR FOR SELECT che_nroint,che_escliente FROM
cheque WHERE che_codsoc = @soc_codigo
OPEN nros_internos
FETCH NEXT FROM nros_internos
WHILE @@fetch_status = 0
BEGIN
IF nros_internos.che_escliente = 1
DELETE FROM chequecliente WHERE chc_nroint = nros_internos.che_nroint
ELSE
DELETE FROM chequenocliente WHERE chn_nroint = nros_internos.che_nroint
DELETE FROM cheque WHERE che_nroint = nros_internos.che_nroint
FETCH NEXT FROM nros_internos
END
CLOSE nros_internos
DEALLOCATE nros_internos

[Santveer]

Guillermo,

You need to fetch values into variable from cursor.
Fetch from ... Into ...,...
These variable you can use in your
condition instead of using as cursorname.column name.

santveer


"Guillermo" <polonskyg@yahoo.com> wrote:
>
>When i try to save the stored procedure sql says: the prefix of 'nros_internos'
>column don't match with table name or alias used in query, but the columns
>names are those, somebody can help me, please?
>
>Create Procedure SP_BorradocCh
> @soc_codigo int
> As
> DECLARE @che_nroint int,@che_escliente bit
> DECLARE nros_internos CURSOR FOR SELECT che_nroint,che_escliente FROM
>cheque WHERE che_codsoc = @soc_codigo
> OPEN nros_internos
> FETCH NEXT FROM nros_internos
> WHILE @@fetch_status = 0
> BEGIN
> IF nros_internos.che_escliente = 1
> DELETE FROM chequecliente WHERE chc_nroint = nros_internos.che_nroint
> ELSE
> DELETE FROM chequenocliente WHERE chn_nroint = nros_internos.che_nroint
> DELETE FROM cheque WHERE che_nroint = nros_internos.che_nroint
> FETCH NEXT FROM nros_internos
> END
> CLOSE nros_internos
> DEALLOCATE nros_internos
>

[kowe4ka]

Try to modify the sproc this way:
Create Procedure SP_BorradocCh
@soc_codigo int
As
DECLARE @che_nroint int,@che_escliente bit
DECLARE nros_internos CURSOR
FOR SELECT che_nroint,che_escliente
FROM cheque
WHERE che_codsoc = @soc_codigo
OPEN nros_internos
FETCH NEXT FROM nros_internos INTO @che_nroint ,@che_escliente
WHILE @@fetch_status = 0
BEGIN
IF @che_escliente = 1
DELETE FROM chequecliente
WHERE chc_nroint = @che_nroint
ELSE
DELETE FROM chequenocliente
WHERE chn_nroint = @che_nroint
DELETE FROM cheque
WHERE che_nroint = @che_nroint
FETCH NEXT FROM nros_internos INTO che_nroint ,@che_escliente

END
CLOSE nros_internos
DEALLOCATE nros_internos