Uh, triggers are not meant to be used to return values (recordsets) to
clients. If you want a recordset use a stored procedure.
Jerry
"Axel" <anonymous@discussions.microsoft.com> wrote in message
news:00D66889-F2D3-4F62-A977-F3A662367ADD@microsoft.com...
> 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
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)
command.execute ... 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, ... returns a closed recordset.... (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)
