[RESOLVED] Database Not Refreshing after structural change

[John_SC]

I am experiencing very odd behavior.
1) I created and attached a database to my VB application.
2) I edited the Dataset within the Designer to add a new Insert query to one table. Everything worked great.
3) Externally I modified the structure of the database, changing one field from date to string. Went back to the application and everything was fine. It seemed to update and be aware of the change.
4) Again externally I added a new field to the table. I went back to VB and adjusted the query to include the new variable.
5) Now, VB keeps telling me the first variable I changed is a Date variable and not a string, and I can't seem to convince it otherwise.

My changes should have been refreshed and changed automatically by VB. I did a lot of similar changes and additions earlier, and they all worked. Is there any way of forcing a refresh, or rebuilding the definitions. I did try to go into the designer.vb file and manually change the "date" to "string" in the references to my field (I adjusted all the fields so they matched other string variables).

Any help. I don't want to have to rebuild the whole application from the ground up again. (this is the third time something like this has happened to me).

[BackWoodsCoder]

did you add the dataset through the designer? If so, open up the dataset designer by right clicking the dataset and choosing "edit in dataset designer". Then go through the list of your columns and look at the DataType property and make sure they're set correctly there.

[John_SC]

That did the trick. The one field that was causing me grief was still a Date field. I switched it to a string, and the error went away. Thanks!