Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What means "Invalid statement handle"?

192 views
Skip to first unread message

Tiberiu Stoicescu

unread,
May 3, 2004, 10:22:09 AM5/3/04
to
Hello,

I have SQLDataSet -> DataSetProvider -> ClientDataset
with DBExpress and Interbase 6.0.20, Delphi 7.0

I add data to dadabase. Sometime I recieve "Invalid statement handle" when
applyupdates.
If cancel updates and reinser recod all is fine.

What means "Invalid statement handle"?


Thanks,

Tiberiu Stoicescu

Craig Stuntz [TeamB]

unread,
May 3, 2004, 10:53:28 AM5/3/04
to
Tiberiu Stoicescu wrote:

> What means "Invalid statement handle"?

It's an InterBase error indicating that the dataset components have
tried to perform an operation (such as closing the statement, etc.) on
a statement which is either closed or never existed in the first place.

I'd recommend building your project with Debug DCUs and looking at the
call stack when the exception is raised to try and figure out which
statement is causing the error. That might give you a clue as to what
is causing the problem.

-Craig

--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
Please read and follow Borland's rules for the user of their
news server: http://info.borland.com/newsgroups/guide.html

0 new messages