Strange Problem

[ksedran]

Hi All,

I am seeing a very strange issue with a winform I have.

There are a few statements in the code, that at one point were working just
fine.
I had compiled the code a few days ago and everything was working as desired.

Now all of a sudden I am getting errors in some places, and some statements
no longer no longer work the way they did.

For instance, the following data conversion has been working for weeks.
Nothing has changed, no DB changes, no code changes, nothing. Now it spits
out an error.
TID_FILTER_TABLE.Columns("MCC").DataType =
System.Type.GetType("System.String")

Error = Cannot change datatype of a column once it has data.

Also, I have several rowfilter statements that no longer do anything...For
instance:
If CARD_SCHEMEselection <> "%" Then
DV_TW_VIEW_TXN_ALL.RowFilter = "CARD_SCHEME LIKE '" &
CARD_SCHEMEselection & "'"
End If

At one point I switched the LIKE to = and that worked, then switched it back
to LIKE and it worked again. Then a few minutes later it no longer worked
again.

Very strange problems....Anyone seen anything like this before?

Any suggestions?

--
Kevin

[Cor Ligthert]

Ksedran,

Weird problem, however did you know that there is a newsgroup

microsoft.public.dotnet.languages.vb

Mybe someone there had the same problem (curiously I saw somebody now
however I have not the answer, maybe somebody else have or can you by mixing
the problems come to a solution)

Just an idea

Cor

"ksedran" <ks*****@discussions.microsoft.com>

Hi All,

I am seeing a very strange issue with a winform I have.

There are a few statements in the code, that at one point were working
just
fine.
I had compiled the code a few days ago and everything was working as
desired.

Now all of a sudden I am getting errors in some places, and some
statements
no longer no longer work the way they did.

For instance, the following data conversion has been working for weeks.
Nothing has changed, no DB changes, no code changes, nothing. Now it spits
out an error.
TID_FILTER_TABLE.Columns("MCC").DataType =
System.Type.GetType("System.String")

Error = Cannot change datatype of a column once it has data.

Also, I have several rowfilter statements that no longer do anything...For
instance:
If CARD_SCHEMEselection <> "%" Then
DV_TW_VIEW_TXN_ALL.RowFilter = "CARD_SCHEME LIKE '" &
CARD_SCHEMEselection & "'"
End If

At one point I switched the LIKE to = and that worked, then switched it
back
to LIKE and it worked again. Then a few minutes later it no longer worked
again.

Very strange problems....Anyone seen anything like this before?

Any suggestions?

--
Kevin