Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Carlos G. A. <car...@te...>]

Hello:

> I'd like to do the following using a single FbCommand object :
> 
> "CREATE TABLE Test(ID INTEGER NOT NULL,
>                    REV INTEGER NOT NULL,
>                    DATA VARCHAR(100) CHARACTER SET UNICODE_FSS);
> 
>  ALTER TABLE Test ADD CONSTRAINT PK_TEST PRIMARY KEY (ID, REV);"
> 
> Is this possible ? If so, can I do it ? I tried to define the
> command text to be exactly as above, and it executes fine. However,
> when I check with IB Expert, I don't see the PK_TEST constraint.
> 
> It is as if it had not been processed by the command.
> 
> Any ideas ?


You have two ways use the FbScript class, or use FbCommand.ExecuteReader 
and FbDataReader.NextResult.

Which version of the .NET Provider are you using ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


"Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las 
mismas cosas."

Albert Einstein.