| Subject | DSQL Result: "attempt to fetch past the last record in a record stream" |
|---|---|
| Author | Ed Dressel |
| Post date | 2011-12-29T18:34:20Z |
In talking with Jason, I thought he indicated that I could use a DSQL object if a result set only contains one record--maybe there is more to it?
I tried the following SQL:
select First 1 Client_ID
from ClientInfo
where Upper_First_Name = :FirstName
The record does not exist, and I am getting the following exception when I call .ExecSQL:
attempt to fetch past the last record in a record stream
When I changed it to a cursor, and use .First, it worked fine.
Am I doing something wrong?
Thanks,
Ed Dressel
I tried the following SQL:
select First 1 Client_ID
from ClientInfo
where Upper_First_Name = :FirstName
The record does not exist, and I am getting the following exception when I call .ExecSQL:
attempt to fetch past the last record in a record stream
When I changed it to a cursor, and use .First, it worked fine.
Am I doing something wrong?
Thanks,
Ed Dressel