Subject RE: TIB_Query with InsertSQL problem (SQLDA missing -804) - SOLVED
Author radevojvodic
Hi Helen,

IBO 4.3, Interbase 7, Delphi7.

I have found solution on news section of IBObjects site (The Famous
SQLDA Bug). I have a select procedure that was executed after every
insert. I found out that in this situation i have to set
HasForSelect property of stored procedure to True and that realy
solved my problem. According to Jason's explanation this is a
Interbase bug.

Thanks anyway.
Rade.


--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> Hello Rade,
>
> At 07:35 AM 16/03/2005 +0000, you wrote:
>
>
> >Hi All,
> >
> >I have TIB_Query with RequestLive=False and InsertSQL and
UpdateSQL
> >defined to use StoredProcedure to insert and update records. The
> >problem is that first insert works OK, but when i insert a record
> >second time i got an error
> >
> >ISC ERROR CODE:335544569
> >ISC ERROR MESSAGE:
> >Dynamic SQL Error
> >SQL error code = -804
> >SQLDA missing or incorrect version, or incorrect number/type of
> >variables
> >
> >Does anyone have a solution for this problem?
>
> We need the following *exact* details:
>
> 1. What version of IBO?
> 2. What version and model of database server?
> 3. What version of client library?
>
>
> >P.S.
> >This problem ocures only when accessing database through network,
if
> >database is accessed as local database, there is no problem.
>
> Note: answer questions 1 and 3 for the remote client machine(s),
as well.
>
> Helen