Re: Cursor handle

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

Article #1821

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1821

From: 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."

Technical Details

Message-ID: <36e84982.571587289@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <36E420A5.4905@dircon.co.uk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,5babf5cc7b7a28c2
X-Google-Attributes: gidfcd2b,public
From: JersWork@wwa.com (Jerry Bloomfield (TeamB))
Subject: Re: Cursor handle
Date: 1999/03/09
Message-ID: <36e84982.571587289@forums.inprise.com>
X-Deja-AN: 453029956
Content-Transfer-Encoding: 7bit
References: <36E420A5.4905@dircon.co.uk>
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Reply-To: JersWork@wwa.com
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message