Article View: borland.public.cppbuilder.database.multi-tier
Article #1822Re: Cursor handle
From: Database Generation Ltd.
Date: Tue, 09 Mar 1999 00:00
Date: Tue, 09 Mar 1999 00:00
34 lines
1902 bytes
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-mailReferences:
<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