firebird-net-provider Mailing List for Firebird

hello there

i am hitting an SP which contains 20 return parameters. for this particular
routine i only need to return data from 3 of the 20 return parameters. i can
achieve this by manually constructing an sql like this: "SELECT ColumnA,
ColumnB, ColumnC FROM sp_1(?)".

however i would much prefer to use the FbParameter objects instead. yet when
I use CommandType.StoredProcedure and only declare the 3 output parameters
that I want, the SP still returns a dataTable containing all 20 columns.

in Firebird 1.5 how is it possible for me to only return certain columns
from the SP using parameter objects and not a dynamic SQL?

thanks
-- 
View this message in context: http://www.nabble.com/FbParameters-tf3151544.html#a8738512
Sent from the firebird-net-provider mailing list archive at Nabble.com.

	It seems I'm not a member because they haven't posted any of my
questions so far. =20

from Robert Meek dba Tangentals Design  CCopyright 2006
Proud to be a moderator of "The Delphi Lists" at elists.org

(["An unused program is the consequence of a higher logic!", nil])  As
written in The Compendium of Accepted Robotic and Surrlogic Theorems =
Used in
the Self Analysis of Elemental Positronic Pathways...1st Edition Revised


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf =
Of
Jiri Cincura
Sent: Tuesday, January 30, 2007 1:42 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] What's the diff?

Robert Meek wrote:
> give me a concise idea of what the differences are between Interbase =
and=20
> FireBird.  And of course I mean for both the local and embedded, and
server=20

IMHO better ask in fb-support list.

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

-------------------------------------------------------------------------=

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share =
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

>> If you don't mind me adding my 2 cents in to the discussion, I think
>> including the '@' symbol should be used just for readability sakes.
When
>> I am writing dynamic SQl the '@' symbol is a context clue for a
>> parameter. Just seems like less room for confusion, but of course it
is
>> just a preference.
>
>But we're talking about the internal representation. Of non-'@'-sign=20
>params and '@'-sign params.
>
>Maybe the best is to leave this as is ('cause it's good, clean,=20
>deterministic, ...) and only work for some changes in DDEX, where this=20
>"hack" VS uses. I've sent to Carlos some tests for this and then we'll=20
>make some changes, I think ha add his 0.02$ too. ;)

Guess I should have read the thread more closely. This teaches me when
not to add my 2 cents :).=20

Thanks for not torching me,

Steven

Carlos Guzm=E1n =C1lvarez wrote:
> I will do a change in FbCommand to allow that this weekend.

OK. I've done some changes in my local copy, but it's not done. :)

I'll revert it to your changes. :P

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Robert Meek wrote:
> give me a concise idea of what the differences are between Interbase and 
> FireBird.  And of course I mean for both the local and embedded, and server 

IMHO better ask in fb-support list.

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Hello:
> But we're talking about the internal representation. Of non-'@'-sign 
> params and '@'-sign params.
I will do a change in FbCommand to allow that this weekend.



-- 
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

    As I'm just getting started in NET and also am having to select a new dB 
to work with NET and ADO as well, I was just wondering if anyone here could 
give me a concise idea of what the differences are between Interbase and 
FireBird.  And of course I mean for both the local and embedded, and server 
based products.  Any and all info would be helpful.

-- 
from Robert Meek dba Tangentals Design
me...@co... 

> > But what is being done by SqlParameter when you create a parameter
> > without @ ?? it left the name as is or appends the @ at the =
beginning ??
>=20
> That is the question. I've opened for this new thread.

Looking at the Reflector for SqlParameter, it's got two properties: the
public ParameterName, which just has whatever you constructed it with, =
or
whatever you assigned to it (with or without an '@'). So if you search =
for a
parameter, you search for the name you set it to.

Then it has a private ParameterNameFixed property, which prepends with =
an
'@' if required. This property is used wherever the '@' is actually
required.

Dean.


> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...] On Behalf =
Of
> Jiri Cincura
> Sent: Tuesday, 30 January 2007 6:26 am
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] Param symbol
>=20
> Carlos Guzm=E1n =C1lvarez wrote:
> > But what is being done by SqlParameter when you create a parameter
> > without @ ?? it left the name as is or appends the @ at the =
beginning ??
>=20
> That is the question. I've opened for this new thread.
>=20
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>=20
> =
-------------------------------------------------------------------------=

> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =
share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> =
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Steve Ramacher wrote:
> If you don't mind me adding my 2 cents in to the discussion, I think
> including the '@' symbol should be used just for readability sakes. When
> I am writing dynamic SQl the '@' symbol is a context clue for a
> parameter. Just seems like less room for confusion, but of course it is
> just a preference.

But we're talking about the internal representation. Of non-'@'-sign 
params and '@'-sign params.

Maybe the best is to leave this as is ('cause it's good, clean, 
deterministic, ...) and only work for some changes in DDEX, where this 
"hack" VS uses. I've sent to Carlos some tests for this and then we'll 
make some changes, I think ha add his 0.02$ too. ;)

-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

>Pham Huu Le Quoc Phuc wrote:
>> Hi all!
>>=20
>> In SqlClient, I can add a parameter without '@', but FbClient not.
>> I think must repair this.
>
>
>Yes, the SqlCommand can do this.
>
>BTW Carlos. In FbCommand class we can also try to accept parametrs
without '@'. What do you think?
>
>--
>Jiri {x2} Cincura
>http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

If you don't mind me adding my 2 cents in to the discussion, I think
including the '@' symbol should be used just for readability sakes. When
I am writing dynamic SQl the '@' symbol is a context clue for a
parameter. Just seems like less room for confusion, but of course it is
just a preference.

Thanks,

Steven Ramacher

Carlos Guzm=E1n =C1lvarez wrote:
> I will see if there are some way of fix that in the ddex provider

I've sent to you small example for this problem.

Do you wanna to create tracker ticket (to Pavel be happy ;)).

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Carlos Guzm=E1n =C1lvarez wrote:
> But what is being done by SqlParameter when you create a parameter=20
> without @ ?? it left the name as is or appends the @ at the beginning ?=
?

That is the question. I've opened for this new thread.

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Carlos Guzm=E1n =C1lvarez wrote:
> Why do you need that feature ??

I don't need it. But somebody asked this in lists today, and as he said,=20
the MS SQL provider does this.

In fact I'm not happy with this.

> I will see if there are some way of fix that in the ddex provider

OK. Nice.

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Hello:
> Yes, the SqlCommand can do this.
>   
But what is being done by SqlParameter when you create a parameter 
without @ ?? it left the name as is or appends the @ at the beginning ??



-- 
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

Hello:
> Interesting. Thi solution seems to be not so good for me. :)
I told that to try to avoid problems with actual working applications 
using the provider( there should be none but ... )
> Can you describe some of them?
I haven't a special problem in mind, i'm thnking only that that is 
something that is working pretty fine now ( or it looks like ) and
i want to avoid more problems with it ( it was having some in the past 
when it was using regex hehe )

Why do you need that feature ??

> Yep, I have some problems with DDEX and ASP.NET solutions, but the 
> solution was easy - interating thru parameters before postback and 
> adding '@'. :D
I will see if there are some way of fix that in the ddex provider


-- 
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

This isn't supported.


-- 
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Using VB.NET 2005 with FB 1.5.3

 

I am trying to execute two Selects in a single FbCommand.

 

I just wanted a confirmation that this does not work:

 

Dim cmd as new FbCommand("Select * from TableA;Select * from TableB", conn)

Dim reader as FbDataReader = cmd.ExecuteReader

 

Here it fails not recognizing the second "Select".  From what I have read
this is valid for SQLServer, but not in FB?

 

Rick

Carlos Guzm=E1n =C1lvarez wrote:
>> * First is adding small piece of code info FbParameter's ctor, that wi=
ll=20
>> prepend the parameterName with '@' if there isn't '@' (of course we ha=
ve=20
>> to discuss some cases, like parameters with generated names, etc.)
>>    - This maybe bring some problems, when you create parameter "test"=20
>> and in fact, it will be saved like "@test" so later, if you'll try to=20
>> find them you will get some surprise. ;)
> This could be done, but it should be conifigurable from connection=20
> string ( or any other place )

Interesting. Thi solution seems to be not so good for me. :)

>> * In FbCommand class add some code that will match to parameters witho=
ut=20
>> '@'. This needs probably more work, but it's IMHO more robust.
> This is not going to happen as it could give more problems than solutio=
ns ;)

Can you describe some of them?

> Right now there are two ways to define the parameters now, named and wi=
th
> place holder and i think there are 0 problem with the actual way they w=
ork
> ( the only problem could be with the ddex provider at design time )

Yep, I have some problems with DDEX and ASP.NET solutions, but the=20
solution was easy - interating thru parameters before postback and=20
adding '@'. :D

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Hello:
> I've looked (a little bit for now) into code and trying to find some 
> clean solution.
>
> Now I have in my mind 2 ideas.
>
> * First is adding small piece of code info FbParameter's ctor, that will 
> prepend the parameterName with '@' if there isn't '@' (of course we have 
> to discuss some cases, like parameters with generated names, etc.)
>    - This maybe bring some problems, when you create parameter "test" 
> and in fact, it will be saved like "@test" so later, if you'll try to 
> find them you will get some surprise. ;)
This could be done, but it should be conifigurable from connection 
string ( or any other place )
> * In FbCommand class add some code that will match to parameters without 
> '@'. This needs probably more work, but it's IMHO more robust.
This is not going to happen as it could give more problems than solutions ;)

Right now there are two ways to define the parameters now, named and with
place holder and i think there are 0 problem with the actual way they work
( the only problem could be with the ddex provider at design time )


-- 
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.wordpress.com

Connection string should looks like:
connectionString=3D"data source=3Dserver_name_or_ip;initial
catalog=3Ddatabase_name;user id=3DSYSDBA;password=3Dmasterkey"
            providerName=3D"FirebirdSql.Data.FirebirdClient"

Regards,
Paul
> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...] On Behalf
> Of Jiri Cincura
> Sent: Monday, January 29, 2007 2:04 PM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] Design Time - Invalid connection
> string
>=20
> Ji=F8=ED Neu=BEil wrote:
> > this.fbConnection =3D new
> > FirebirdSql.Data.FirebirdClient.FbConnection("C:\ageu\ageu.fdb");
>=20
> Are you sure, that this is valid connection string?
>=20
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>=20
> =
-----------------------------------------------------------------------
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =
share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> =
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVD
> EV
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Ji=F8=ED Neu=BEil wrote:
> this.fbConnection =3D new=20
> FirebirdSql.Data.FirebirdClient.FbConnection("C:\ageu\ageu.fdb");

Are you sure, that this is valid connection string?

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

So I hardcode connection string to master form ctor:
this.fbConnection = new 
FirebirdSql.Data.FirebirdClient.FbConnection("C:\ageu\ageu.fdb");

this.fbCommand = new FirebirdSql.Data.FirebirdClient.FbCommand("Select * 
from podnik", this.fbConnection);

but, it doesn't help.

Thanks


"Jiri Cincura" <di...@ci...> pí¹e v diskusním pøíspìvku 
news:45B...@ci......
> Jir=ED Neuzil wrote:
>> Yes, it's hardcoded:
>> from master form ctor.:
>> this.fbConnection =3D new =
>
>> FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionString=
> ());
>> =
>
>> this.fbCommand =3D new FirebirdSql.Data.FirebirdClient.FbCommand("Select 
>> =
> * =
>
>> from podnik", this.fbConnection);
>
> This isn't harcoded. :)
>
> Just guessing, try to put the string *directly* into ctor. Maybe this 
> helps.
>
> -- =
>
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDE=
> VDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 

:) I have read "Is select command hardcoded", sorry :)


"Jiri Cincura" <di...@ci...> pí¹e v diskusním pøíspìvku 
news:45B...@ci......
> Jir=ED Neuzil wrote:
>> Yes, it's hardcoded:
>> from master form ctor.:
>> this.fbConnection =3D new =
>
>> FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionString=
> ());
>> =
>
>> this.fbCommand =3D new FirebirdSql.Data.FirebirdClient.FbCommand("Select 
>> =
> * =
>
>> from podnik", this.fbConnection);
>
> This isn't harcoded. :)
>
> Just guessing, try to put the string *directly* into ctor. Maybe this 
> helps.
>
> -- =
>
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3DDE=
> VDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 

Jir=ED Neuzil wrote:
> Yes, it's hardcoded:
> from master form ctor.:
> this.fbConnection =3D new=20
> FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionStri=
ng());
>=20
> this.fbCommand =3D new FirebirdSql.Data.FirebirdClient.FbCommand("Selec=
t *=20
> from podnik", this.fbConnection);

This isn't harcoded. :)

Just guessing, try to put the string *directly* into ctor. Maybe this hel=
ps.

--=20
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Yes, it's hardcoded:
from master form ctor.:
this.fbConnection = new 
FirebirdSql.Data.FirebirdClient.FbConnection(ini_load.GetConnectionString());

this.fbCommand = new FirebirdSql.Data.FirebirdClient.FbCommand("Select * 
from podnik", this.fbConnection);

"Jiri Cincura" <di...@ci...> píse v diskusním príspevku 
news:45B...@ci......
> Is the connection string hardcoded in master form?
>
>
> -- 
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>