Re: #sql-count

[SEMECH <jstein@MAIL.NETVISION.NET.IL>]

Arthur,

It always happen if you in LOCAL procedure.
(begin-procedure with parameters or local keyword)

Since all SQR reserved variables are GLOBAL,
try  #_sql-count, #_sql-status and $_sql-error.

Arnon
-------------------------------------------------------------------
SEMECH SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 - 5333132
Email: <semech@pobox.com>
------------------------------------------------------------------
-----Original Message-----
From: Arthur Coniglio <Arthur.CONIGLIO@EDDEPT.WA.EDU.AU>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: 06/08/98 12:33
Subject: #sql-count


>People....
>
>I have a colleague who is inserting into a table, then immediately after
>is checking the
>sqr system variable #sql-count.  This is returning a value of zero even
>though the
>insert was successful.
>
>He is also displaying #sql-status and $sql-error, these are also showing
>0 and blank respectively.
>
>I myself have used the #sql-count successfully before.
>Has anyone ever experienced this before.
>
>We are using sqr version 3 with oracle 7.
>
>TIA.
>
>
>Arthur C.
>