Re: executenonquery - insert works only in debug mode
> Magazzini is an array of strings. If I execute this code in run mode
> insert fails and table Magazzini_Selezionati is empty. Code does not
> return any error but insert not works. If I execute this code step by
> step in debug mode it works right and rows have been inserted into the
> table.
>
> Could you tell me why???
>
> I'm working with VS2003, .NET 1.1 SP1 and SQL SERVER 2K SP4.
no matter what the real cause is, in such cases you should always use Sql
Profiler's trace ability to see what query is actually sent to the server.
you will find the Sql Profiler among other tools shipped with SQLServer.
Wiktor Zychla
.
Relevant Pages
- Re-post: Yet another problem with "no current record"
... I have a form with 4 unbound text boxes and a button. ... My problem happens after I set one of the values to -999 and execute another ... to empty out the form of rows so the user can start over. ... Else 'Either description entered, or first time entry ...
(microsoft.public.access.formscoding) - Re: Re-post: Yet another problem with "no current record"
... I have a form with 4 unbound text boxes and a button. ... My problem happens after I set one of the values to -999 and execute ... to empty out the form of rows so the user can start over. ... Else 'Either description entered, or first time entry ...
(microsoft.public.access.formscoding) - Re: Add "File Roller"/"Archive Manager" to right-click on Desktop
... In the nautilus-scripts folder right click> create document> empty ... exec file-roller <and exit selecting save. ... properties> permissions and check the execute box, ... the reload button and close nautilus. ...
(Ubuntu) - Re: Do I need a RTOS?
... place, everything is empty ... ... the queue and requesting that I always keep some task in the queue. ... It is there that I call the execute function, over and over, pumping ... timer event, of course. ...
(comp.arch.embedded) - Re: Do I need a RTOS?
... place, everything is empty ... ... the queue and requesting that I always keep some task in the queue. ... It is there that I call the execute function, over and over, pumping ... with executeand call executeas your basic busy loop in main. ...
(comp.arch.embedded) |
|
