Re: UPDATE problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sergey;

It already runs in Debug Mode when display a messagebox sayig [@nombre], it
doesn't display any exception.

Thanks

--
David Funez
Tegucigalpa, Honduras


"Sergey Bogdanov" <sergey.bogdanov@xxxxxxxxx> wrote in message
news:OnmDgkyUFHA.628@xxxxxxxxxxxxxxxxxxxxxxx
> What exception do you have? Try to run it in debug mode and see what is
> going on there.
>
> Best regards,
> Sergey Bogdanov
> http://www.sergeybogdanov.com
>
>
> David Funez wrote:
>> Sergey;
>>
>> Thanks a lot, but this code just display the next message [@nombre] and
>> doesn't update:
>>
>> cmd.CommandText = _
>> "UPDATE clientes SET nombre=?, contacto=? WHERE id_cliente=?"
>>
>> cmd.Parameters.Add(New SqlCeParameter("@nombre", SqlDbType.NChar, 30,
>> "value"))
>> cmd.Parameters.Add(New SqlCeParameter("@contacto", SqlDbType.NChar, 30,
>> "value"))
>> cmd.Parameters.Add(New SqlCeParameter("@id_cliente", SqlDbType.NChar, 5,
>> "value"))
>>
>> cmd.Prepare()
>> cmd.ExecuteNonQuery(
>>
>> messagebox.show("record updated") <=== This message is not displayed
>>
>> ?am i doing something wrong?
>>
>> Thanks again.
>>


.

Relevant Pages

  • Re: UPDATE problem
    ... What exception do you have? ... Try to run it in debug mode and see what is going on there. ... Best regards, ... David Funez wrote: ...
    (microsoft.public.dotnet.framework.compactframework)
  • Release versus Debug exception problem
    ... wanted to trap the bubbled up exception in my main function and display a ... It works fine in debug mode but in release mode it pops up a ... windows error dialog with a stack trace. ... catch (Exception ex) ...
    (microsoft.public.dotnet.framework.clr)
  • Release versus Debug exception problem
    ... wanted to trap the bubbled up exception in my main function and display a ... It works fine in debug mode but in release mode it pops up a ... windows error dialog with a stack trace. ... catch (Exception ex) ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Release versus Debug exception problem
    ... wanted to trap the bubbled up exception in my main function and display a ... It works fine in debug mode but in release mode it pops up a ... windows error dialog with a stack trace. ... catch (Exception ex) ...
    (microsoft.public.dotnet.framework)
  • HELP: Release versus Debug exception problem
    ... wanted to trap the bubbled up exception in my main function and display a ... It works fine in debug mode but in release mode it pops up a ... windows error dialog with a stack trace. ... catch (Exception ex) ...
    (microsoft.public.dotnet.framework)