Re: [Firebird-net-provider] Derive parameters for SQL command

2009-10-09 Thread Le Phuc
I know DeriveParameters only for SPs, I want FbCommand can parse SQL text
before exec and make FbParameter into FbCommand.Parameters. I try to call
Prepare but it not work.
Thanks

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Friday, October 09, 2009 14:29 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Derive parameters for SQL command

2009/10/9 Cty TNHH T.O.N.Y cont...@tonyvn.com:
 I want to execute a SQL command, please tell me how to 'DeriveParameters
 before exec as when execute a procedure?

DeriveParameters works only for SPs.

BTW is the HTML garbage really neccessary?

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


Re: [Firebird-net-provider] Derive parameters for SQL command

2009-10-09 Thread Jiri Cincura
On Fri, Oct 9, 2009 at 09:41, Le Phuc lep...@tonyvn.com wrote:
 I know DeriveParameters only for SPs, I want FbCommand can parse SQL text
 before exec and make FbParameter into FbCommand.Parameters. I try to call
 Prepare but it not work.

This isn't possible.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


[Firebird-net-provider] [FB-Tracker] Created: (DNET-278) FbCommand can parse SQL text and make parameter list in Parameters before exec

2009-10-09 Thread Pham Huu Le Quoc Phuc (JIRA)
FbCommand can parse SQL text and make parameter list in Parameters before exec
--

 Key: DNET-278
 URL: http://tracker.firebirdsql.org/browse/DNET-278
 Project: .NET Data provider
  Issue Type: New Feature
  Components: ADO.NET Provider
Reporter: Pham Huu Le Quoc Phuc
Assignee: Jiri Cincura


I have a SQL text, I want to use FbCommand(or others) to create parameters in 
SQL text before FbCommand exec.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider