Hello,
Hope you can help me.
I have the next update string:
"UPDATE domicilio SET [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
,[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] WHERE [EMAIL PROTECTED]"
and I create every parameter doing this:
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@IDDOMICILIO",DbType.Int32,this.IdDomicilio));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@CALLE",DbType.String,this.Calle));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@NUMEROEXTERIOR",DbType.String,this.NumeroExterior));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@NUMEROINTERIOR",DbType.String,this.NumeroInterior));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@COLONIA",DbType.String,this.Colonia));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@CP",DbType.String,this.CP));
comDomicilio.Parameters.Add(FabricaConexion.CrearParametro(comDomicilio,"@IDCIUDAD",DbType.Int16,this.Ciudad));
FabricaConexion.CrearParametro returns a FbParameter object (it's a parameters
factory in order to support several databases).
When I executed it I got this error: "Must declare the variable @CALLE".
But if I remove the '@' character from the comDomicilio.Parameters.Add method,
the query is succesfully executed .
¿Why this happens?
Thanks in advance.
___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes.
http://net.yahoo.com.mx
-------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
