Cursor handle

Thread View: borland.public.cppbuilder.database.multi-tier

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Database Generation Ltd. Mon, 08 Mar 1999 00:00

#1820

Author: Database Generation Ltd.
Date: Mon, 08 Mar 1999 00:00

21 lines
1056 bytes

Hi friends,
Can somebody help with Query execution on the remote module?

In SQL Query I have:
insert 
      into BNF_CHANGES(RECORD_ID, AUTHOR_ID, DATE_TIME, RTEXT)
values(:RECORD_ID, :AUTHOR_ID, :DATE_TIME, :RTEXT) 

Below is what I am doing:

Variant values[4] = {NRECID, AID, TM, NewText->Text};
dmBNF->cdsIQChanges->Provider->SetParams(VarArrayOf(values, 3));
dmBNF->cdsIQChanges->Open();
dmBNF->cdsIQChanges->Close();

and what I have got:

Error creating cursor handle

Thank you very much in advance,
Eugene

Re: Cursor handle

#1821

Author: Jerry Bloomfield (TeamB)
Date: Tue, 09 Mar 1999 00:00

28 lines
1649 bytes

On Mon, 08 Mar 1999 19:10:29 +0000, "Database Generation Ltd."
<datagen@dircon.co.uk> wrote:

>In SQL Query I have:
>insert 
>      into BNF_CHANGES(RECORD_ID, AUTHOR_ID, DATE_TIME, RTEXT)
>values(:RECORD_ID, :AUTHOR_ID, :DATE_TIME, :RTEXT) 
>...
>dmBNF->cdsIQChanges->Open();
>
>and what I have got:
>Error creating cursor handle

As well you should.  This is a common problem which is actually
discussed in the manuals,  and often answered in these news groups.  So
far,  I have read 2-3 answers to this question just today.

Your INSERT statement does not return a result set back,  so the Open()
call can not open the cursor attached to said results set.  You should
use the appropriate method for executing SQL code which does not return
a result set.  ExecSQL().  A few minutes in the news groups,  or
documentation should have provided you with that solution as well...

Jerry Bloomfield (TeamB)
-- 
Jerry Bloomfield                                     JersWork@wwa.com
Proud Member of Inprise's TeamB
"We'll do anything if you don't pay us."

Re: Cursor handle

#1822

Author: Database Generation Ltd.
Date: Tue, 09 Mar 1999 00:00

34 lines
1902 bytes

Thank you very much but...
ExecSQL is not a member of Dataset...
So how I can execute SQL Query that on the RDM from application?

Jerry Bloomfield (TeamB) wrote:
> 
> On Mon, 08 Mar 1999 19:10:29 +0000, "Database Generation Ltd."
> <datagen@dircon.co.uk> wrote:
> 
> >In SQL Query I have:
> >insert
> >      into BNF_CHANGES(RECORD_ID, AUTHOR_ID, DATE_TIME, RTEXT)
> >values(:RECORD_ID, :AUTHOR_ID, :DATE_TIME, :RTEXT)
> >...
> >dmBNF->cdsIQChanges->Open();
> >
> >and what I have got:
> >Error creating cursor handle
> 
> As well you should.  This is a common problem which is actually
> discussed in the manuals,  and often answered in these news groups.  So
> far,  I have read 2-3 answers to this question just today.
> 
> Your INSERT statement does not return a result set back,  so the Open()
> call can not open the cursor attached to said results set.  You should
> use the appropriate method for executing SQL code which does not return
> a result set.  ExecSQL().  A few minutes in the news groups,  or
> documentation should have provided you with that solution as well...
> 
> Jerry Bloomfield (TeamB)
> --
> Jerry Bloomfield                                     JersWork@wwa.com
> Proud Member of Inprise's TeamB
> "We'll do anything if you don't pay us."

Re: Cursor handle

#1823

Author: Jerry Bloomfield (TeamB)
Date: Tue, 09 Mar 1999 00:00

15 lines
1195 bytes

On Tue, 09 Mar 1999 18:52:48 +0000, "Database Generation Ltd."
<datagen@dircon.co.uk> wrote:

>Thank you very much but...
>ExecSQL is not a member of Dataset...
>So how I can execute SQL Query that on the RDM from application?

Please refer tot he posting guidelines for these groups.  I have already
replied to your post in another news group on this exact topic...

Jerry Bloomfield (TeamB)
-- 
Jerry Bloomfield                                     JersWork@wwa.com
Proud Member of Inprise's TeamB
"We'll do anything if you don't pay us."

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads