[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQL Error - Data Type Has Changed?

> In the snips, I observed one typo. Could it be the
> reason?
>
> In select statement,
> where invoicenum = &invoicenum
> In error_proc,
> display 'Invoice = ' noline
> display &_invoicnum
> Are &invoicenum and &_invoicenum same?-Raju

Yes, &invoicenum and &_invoicenum are the same thing.  &_invoicenum is
used in the error_proc to denote that it is a global variable and not
a variable local to the procedure.  That aside, by the time I reach
the error_proc procedure the SQL error has already occured.

Dunc




_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com