Res: Question on NpgsqlParameter object

Hi Oliveiros!

Unfortunately it is not possible with current state to get this text.

You will have to enable either Npgsql Log or postgresql log.

Just add those lines:

// Enable logging.
NpgsqlEventLog.Level = LogLevel.Debug;
NpgsqlEventLog.LogName = "NpgsqlTests.LogFile";
It will show you all the commands sent to server.

You can also get support from Npgsql mail list and forum. Check out Npgsql project page:

http://npgsql.projects.postgresql.org

I hope it helps.

--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com

Npgsql Lead Developer
http://npgsql.projects.postgresql.org

MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org


"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

----- Mensagem original ----
De: Oliveiros Cristina <oliveiros(dot)cristina(at)gmail(dot)com>
Para: pgsql-interfaces(at)postgresql(dot)org
Enviadas: Segunda-feira, 28 de Maio de 2007 14:36:52
Assunto: [INTERFACES] Question on NpgsqlParameter object

Hi, List.

I am not 100% sure if this is the right list, if it isnt please kindly re-direct me to the proper list.

I would like to see NpgsqlCommand.CommandText value after parameter substitution. I have a query that is not behaving correctly and I suspect strongly that it has to do with parameters getting instantiated in unexpected ways.

How can I have access to query SQL text after parameter substitution ?

I try to look at CommandText Property immediately before calling ExecuteReader() method, but I get the text with all parameters unsubstituted.

Any Help/Comments/Advices deeply appreciated

Thanks in advance

Cheers,
Oliveiros

__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/