Bug #51558 new field add error
Submitted: 26 Feb 2010 16:49 Modified: 22 Mar 2010 11:59
Reporter: alex kapmar Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:6.x OS:Windows (visual .net studio)
Assigned to: CPU Architecture:Any
Tags: add field, add new field, Connector/Net, visual net, wizerd

[26 Feb 2010 16:49] alex kapmar
Description:
add new field from visual studio wizerd error
after i add it my mysql query

this is my config;
mysql server 5.5 . mysql connector 6.2.1 , 6.2.2 , windows 7
visual stosio 2008 .net

How to repeat:
i make new project on .net studio
i add datasource by wizerd from visual studio
i add table and fileds by wizerd

until this all ok

then i want to add new field to the table after i add it by mysql query brwser
i  want to add it with the visual studio wizerd then i get the error :
mysql syntex Error neer .client (this is my table)

SELECT `Index`, ClientNumber, Name FROM def.mydatbase.clients
[26 Feb 2010 16:54] alex kapmar
Mysql.sql and visual studio test project .net

Attachment: test-mysql.rar (application/octet-stream, text), 38.25 KiB.

[22 Mar 2010 11:59] Tonci Grgin
Hi Alex and thanks for your report.

It is not clear to me what you did so here's what I did (can't repeat your problem):
  o Create new table: create table bug51558 (Id INT NOT NULL PRIMARY KEY, FrstVChar VARCHAR(50));
  o OpenWinForms project in VS, add DataSet, Drag table bug51558 from server explorer. DataSet shows only two fields.
  o Alter table outside VS:  alter table bug51558 add column ScndVChar VARCHAR(40);
  o Right-click table in DataSet Designer and choose "Configure". Go to "Query Builder", notice new field (ScndVChar) is not checked. Check it and click Finish.

New field appears as expected... I do not think we have any synchronization facilities that can be used to automate this. If you wish, you can file new feature request (S4) for something like that.