Weird 'incorrect syntax near WHERE' message from MessageBox

[Larry Woods]

I have a Messagebox that looks like:

MessageBox.Show("There are pending changes for this patient. Do you want to
continue to close?", "Pending Changes", MessageBoxButtons.YesNo,
MessageBoxIcon.Question)

When I execute the Messagebox.Show, then press either 'Yes' or 'No' I get 25
of the following Messageboxes:

"incorrect syntax near the keyword WHERE"

I am sure that this is tied to some other problem in my form but I have NO
clue where. I have put breakpoints before and after the Messagebox.Show so
I know that the problem occurs in the Messagebox execution. I am working
with a dataset in this form but the dataset table has 21 fields so I can't
see any correlation with that table.

ANY IDEAS?

??????????????????????

TIA,

Larry Woods

[CJ Taylor]

Its a SQL error... Check your SQL adapters on your updates.
"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:Ow**************@tk2msftngp13.phx.gbl...

I have a Messagebox that looks like:

MessageBox.Show("There are pending changes for this patient. Do you want
to
continue to close?", "Pending Changes", MessageBoxButtons.YesNo,
MessageBoxIcon.Question)

When I execute the Messagebox.Show, then press either 'Yes' or 'No' I get
25
of the following Messageboxes:

"incorrect syntax near the keyword WHERE"

I am sure that this is tied to some other problem in my form but I have NO
clue where. I have put breakpoints before and after the Messagebox.Show
so
I know that the problem occurs in the Messagebox execution. I am working
with a dataset in this form but the dataset table has 21 fields so I can't
see any correlation with that table.

ANY IDEAS?

??????????????????????

TIA,

Larry Woods

[Larry Woods]

Nope! Turns out that I added the two additional parameters that were part
of another cast of MessageBox and it works fine! After sending my original
email I moved the Messagebox around at different places in the program and
at one place it just kept displaying my original MessageBox message 25
times!!!! It's obvious that it is somewhere tied with what I am doing in my
program but I am surprised that Messagebox is getting so screwed
up...considering the protections that are built into the .NET framework.

Larry

"CJ Taylor" <jj******@jackson5.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

Its a SQL error... Check your SQL adapters on your updates.
"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:Ow**************@tk2msftngp13.phx.gbl...

I have a Messagebox that looks like:

MessageBox.Show("There are pending changes for this patient. Do you want
to
continue to close?", "Pending Changes", MessageBoxButtons.YesNo,
MessageBoxIcon.Question)

When I execute the Messagebox.Show, then press either 'Yes' or 'No' I get 25
of the following Messageboxes:

"incorrect syntax near the keyword WHERE"

I am sure that this is tied to some other problem in my form but I have NO clue where. I have put breakpoints before and after the Messagebox.Show
so
I know that the problem occurs in the Messagebox execution. I am working with a dataset in this form but the dataset table has 21 fields so I can't see any correlation with that table.

ANY IDEAS?

??????????????????????

TIA,

Larry Woods

[Larry Woods]

I stand corrected.

I have my initialization code in the form Activate event procedure instead
of the Load procedure...and it's reentering the procedure.

Larry

"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:Oj**************@TK2MSFTNGP11.phx.gbl...

Nope! Turns out that I added the two additional parameters that were part
of another cast of MessageBox and it works fine! After sending my original email I moved the Messagebox around at different places in the program and
at one place it just kept displaying my original MessageBox message 25
times!!!! It's obvious that it is somewhere tied with what I am doing in my program but I am surprised that Messagebox is getting so screwed
up...considering the protections that are built into the .NET framework.

Larry

"CJ Taylor" <jj******@jackson5.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

Its a SQL error... Check your SQL adapters on your updates.
"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:Ow**************@tk2msftngp13.phx.gbl...

I have a Messagebox that looks like:

MessageBox.Show("There are pending changes for this patient. Do you want to
continue to close?", "Pending Changes", MessageBoxButtons.YesNo,
MessageBoxIcon.Question)

When I execute the Messagebox.Show, then press either 'Yes' or 'No' I get 25
of the following Messageboxes:

"incorrect syntax near the keyword WHERE"

I am sure that this is tied to some other problem in my form but I have

NO

clue where. I have put breakpoints before and after the

Messagebox.Show so
I know that the problem occurs in the Messagebox execution. I am

working with a dataset in this form but the dataset table has 21 fields so I can't see any correlation with that table.

ANY IDEAS?

??????????????????????

TIA,

Larry Woods

[CJ Taylor]

=) So is the problem solved?
"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...

I stand corrected.

I have my initialization code in the form Activate event procedure instead
of the Load procedure...and it's reentering the procedure.

Larry

"Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
news:Oj**************@TK2MSFTNGP11.phx.gbl...

Nope! Turns out that I added the two additional parameters that were
part
of another cast of MessageBox and it works fine! After sending my

original

email I moved the Messagebox around at different places in the program
and
at one place it just kept displaying my original MessageBox message 25
times!!!! It's obvious that it is somewhere tied with what I am doing in

my

program but I am surprised that Messagebox is getting so screwed
up...considering the protections that are built into the .NET framework.

Larry

"CJ Taylor" <jj******@jackson5.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

> Its a SQL error... Check your SQL adapters on your updates.
>
>
> "Larry Woods" <la***@NOSPAMlwoods.com> wrote in message
> news:Ow**************@tk2msftngp13.phx.gbl...
> >I have a Messagebox that looks like:
> >
> > MessageBox.Show("There are pending changes for this patient. Do you want > > to
> > continue to close?", "Pending Changes", MessageBoxButtons.YesNo,
> > MessageBoxIcon.Question)
> >
> > When I execute the Messagebox.Show, then press either 'Yes' or 'No' I

get

> > 25
> > of the following Messageboxes:
> >
> > "incorrect syntax near the keyword WHERE"
> >
> > I am sure that this is tied to some other problem in my form but I have

NO

> > clue where. I have put breakpoints before and after the

Messagebox.Show > > so
> > I know that the problem occurs in the Messagebox execution. I am

working

> > with a dataset in this form but the dataset table has 21 fields so I

can't

> > see any correlation with that table.
> >
> > ANY IDEAS?
> >
> > ??????????????????????
> >
> > TIA,
> >
> > Larry Woods
> >
> >
>
>