🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Cursor handle

#1822
From: 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."
Technical Details
Message-ID: <36E56E00.1456@dircon.co.uk>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <36E420A5.4905@dircon.co.uk> <36e84982.571587289@forums.inprise.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,5babf5cc7b7a28c2
X-Google-Attributes: gidfcd2b,public
From: "Database Generation Ltd." <datagen@dircon.co.uk>
Subject: Re: Cursor handle
Date: 1999/03/09
Message-ID: <36E56E00.1456@dircon.co.uk>
X-Deja-AN: 453071788
Content-Transfer-Encoding: 7bit
References: <36E420A5.4905@dircon.co.uk> <36e84982.571587289@forums.inprise.com>
Content-Type: text/plain; charset=iso-8859-2
Organization: Database Generation Ltd.
Mime-Version: 1.0
Reply-To: datagen@dircon.co.uk
Newsgroups: borland.public.cppbuilder.database.multi-tier