Re: #sql-count

[Richard Meijn <rameijn@WXS.NL>]

If you are using this viriables insite a procedure you must beaware
that this variable is a global variable.

So if you uses this viriable insite a procudure you has to write
#_sql-count instead of #sql-count

I hope this helps

Greeting

Richard Meijn

Arthur Coniglio wrote:
>
> 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.