Hi Jason,

I set KeyLinks blank and KeyLinksAutoDefine to False per your
suggestion and I still get the same error.

Steve

--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
wrote:

> It probably has to do with the join.
> You might try setting KeyLinks blank and KeyLinksAutoDefine to

false.

> When using a query like this it may be best not to try and have

the nice

> functionalities that IBO provides for buffered datasets.
>
> Jason Wharton
>
> -----Original Message-----
> From: sgharp [mailto:steve@h...]
> Sent: Friday, September 10, 2004 1:57 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Problem in binding cursor?
>
>
>
> Hi All,
>
> I'm using a TIBOQuery's DeleteSQL property to delete a record and
> getting the error "Problem in BindingCursor". The systax of the
> DeleteSQL is
>
> execute procedure spUpdateMajorSetup
> (:MajorID, :MajorName, :GroupID, 'Y');
>
> where it's calling a stored procedure. The stored procedure works
> fine in IBExpert.
>
> The SQL statement for the query is
>
> select ma.MajorID, ma.MajorName, ma.GroupID, gr.GroupName
> from xMajor ma
> join xGroup gr on gr.GroupID = ma.GroupID
> where ma.MajorID = :MajorID
>
> My KeyLinks is set to xMajor.MajorID which is the primary key of

the

> xMajor table.
>
> The strange thing is that I'm using essentially the same type of
> process with another query object and a different (but similar)
> stored procedure in another part of the program and it works fine.
>
> What am I missing?
> Thanks,
> Steve