following is only program fragment, original program structure is from sample
named Duwamish in ms vs.net 2002.
/
private const String ID_PARM= "@id";
private const String NAME_PARM = "@name";
public UserData GetUserById(int id)
{
if ( dataAdapter ==
Hello, Francisco Figueiredo Jr.
yes, I'd like to. Thank you for talking with you. ^_^
>H, could you add a feature request in Npgsql project?
>
>This feature may be helpful for other users who are porting their apps
>to postgresql :)
>
>Also, if possible, please add a simple test case with th
Hello, Francisco Figueiredo Jr.
plpgsql did not support @id as parameter(need double-quote), somebody suggest
me to use vid
for parameter. When use vid as parameter for plpgsql, in C# program we use
@vid, Npgql
will delete @, then pass vid to plpgsql. So I want to change Npgsql not to
delete @
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arnold.Zhu wrote:
| I want to use @id, @name as plpgsql's parameter, then I've no need to
change C# source,
| only change Npgsql driver not to trim "@" and stored procedure to plpgsql.
|
Hi Arnold,
Npgsql already supports parameter names starting with @
Hello, Michael Fuhr
I've changed my clock. Back to future now. ^_^
Thanks & Regards!
Arnold.Zhu
2004-11-24
=== 2004-11-24 13:52:05 You wrote: ===
>On Tue, Nov 23, 2004 at 10:46:54PM -0700, Michael Fuhr wrote:
>
>> On Thu, Nov 23, 2000 at 11:59:58AM +0800, Ar
Hello, Michael Fuhr
Thank you very much for your reply, I'm looking for a method to port our
application
with .Net and Sql Server 2000 to linux and mono.
Sql server 2000's stored procedure take parameter like @Id, @Name etc. Then in
our C#
programs, use @Id, @Name as Select, Insert, Delete, Upd
On Tue, Nov 23, 2004 at 10:46:54PM -0700, Michael Fuhr wrote:
> On Thu, Nov 23, 2000 at 11:59:58AM +0800, Arnold.Zhu wrote:
Ummm...did you know your clock was four years behind?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)-
On Thu, Nov 23, 2000 at 11:59:58AM +0800, Arnold.Zhu wrote:
> Can I change postgresql's source to make the following plpgsql works ?
> If could, would you please tell me where can i change the source?
> I want to try it.
No need -- PostgreSQL 8.0 (currently in beta) already supports
argument name
