git-goblin / SRDB-Desktop-MySQL-Version

New SRDB System using MySQL Connection instead of Windows SQL Server Express
0 stars 0 forks source link

Amend ComboBox #4

Closed git-goblin closed 10 years ago

git-goblin commented 10 years ago

When attempting to add value for the ComboBox DB system it returns with error:

amendcombobox

Likely to be caused by the INSERT INTO statement possibly due to the prepared statements.

git-goblin commented 10 years ago

Currently an issue with the ComboBox ammend page with both logic and design. Certain columns will have more values than others and since 1 values is being inserted per row, it will makes things very messy. To counter this, a separate table will be created for each ComboBox and the code segment will be added to addRecord.cs and editForm.cs

git-goblin commented 10 years ago

Attempting to resolve the issue with a new form, has returned this error:

ammendcb

git-goblin commented 10 years ago

Although pulling records from a different DB with multiple tables, it is now displaying all the values together for each table in each DVG:

ammendcb2