Re: [Firebird-net-provider] Execute block...

2011-01-27 Thread Matthew Parslow
27;d clean it up and make it more generic again, but it works fine for what I need to do Cheers, Matt -Original Message- From: Danny Gorton [mailto:da...@absolutepowerandcontrol.com] Sent: Friday, 28 January 2011 5:42 AM To: For users and developers of the Firebird .NET providers Cc: Mat

Re: [Firebird-net-provider] Execute block...

2011-01-27 Thread Danny Gorton
me VARCHAR(32) = ?) RETURNS (id BIGINT) AS BEGIN id = GEN_ID(ECOPCONFIGURATIONID, 1); INSERT INTO ECOPCONFIGURATION (ID,NAME,ISACTIVE) VALUES (:id,:name,0); SUSPEND; END"; //'SUSPEND' is required for return values/output params. This causes the server to wait for the client to reques

Re: [Firebird-net-provider] Execute block...

2011-01-26 Thread Matthew Parslow
out 5 Cheers, Matt -Original Message- From: da...@absolutepowerandcontrol.com [mailto:da...@absolutepowerandcontrol.com] Sent: Sunday, 23 January 2011 3:09 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Execute block... Here is a sni

Re: [Firebird-net-provider] Execute block...

2011-01-22 Thread danny
lues/output params. This causes the server to wait for the client to request the next line addParam(cmd,":name", DbType.AnsiString, name); return cmd; HTH, Danny Original Message ---- Subject: [Firebird-net-provider] Execute block... From: Adrián_Avila_Mtz. Date: Sat,

[Firebird-net-provider] Execute block...

2011-01-22 Thread Adrián Avila Mtz .
Is there a way to execute a block with FB data provider. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using