command.execute

From: Axel (anonymous_at_discussions.microsoft.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 01:56:05 -0800

Hi,
I called the execute method of the command object with an insert sql-statement. The SQL-Server fires then
a trigger and the trigger returns with a recordset (a select statement within the trigger), but the execute method
returns a closed recordset.

What can I do to get an open recordset ?

Best regards

Axel

Relevant Pages

  • Re: It just dont work: Insert last ID into related table (trigger)
    ... Yes if you are using your own SP or making your own recordset but no if you ... are using a bound form with ADP as ADP will look for @@identity. ... there is a problem with using a trigger if the second ...
    (microsoft.public.access.adp.sqlserver)
  • How to Update from Single Row/Many columns to Single Column/Many Rows
    ... I want to try to create a trigger or at least a stored ... pulls all the column names from a single row in a ... To create a Recordset and then Join those records to rows ... them into a corresponding field eValue in B. ...
    (microsoft.public.sqlserver.programming)
  • Re: implement Save button
    ... When using disconnected recordset, ... BatchUpdate makes a copy of whatever back to the database ... Without Trigger: ... > and it will do creation of the set of inital data in some other database ...
    (microsoft.public.vb.enterprise)
  • Re: command.execute
    ... If you want a recordset use a stored procedure. ... Jerry ... > I called the execute method of the command object with an insert ... > a trigger and the trigger returns with a recordset (a select statement ...
    (microsoft.public.data.ado)
  • Re: Parameterized queries
    ... newly constructed Recordset set to read-only/forward-only. ... settings you make in the Command object before the Open. ... > parameters only in the Execute method of the Command, ... > specify the cursor and lock types via the Open method of the ...
    (microsoft.public.data.ado)