SQLNROWs = -11 ????

[kaul125]

I'm executing an embedded sql statement within my PB6.5 code and the transaction object returns the following:

sqlca.sqlnrows = -11

sqlcode and sqldbcode both = 0 and sqlerrtext = ""(empty string)

I'm using Sybase Adaptive Server Anywhere Database Engine Version 8.0.1.2600 as my database(previous version was sybase sqlanywhere 5.0)

What does this negative # mean for sqlnrows? Since there is no othere error code/error text how can I correct this problem?

My embedded SQL looks like:

Select col_one into :li_value
from table_name
where key_one = :ii_key_one
using sqlca;

Keith