<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>8 May 2015 17:57:00 Z</lastBuildDate><pubDate>8 May 2015 00:11:00 Z</pubDate><description>I am working on a WebDev 19 application that I did not originally develop, but that needs to be updated to split a single form field into two distinct fields. This form writes data back to a SQL Express 2014 database, which is connected to via the native SQL access method in WebDev.&#13;
&#13;
I'm not entirely sure of the right procedure for adding new fields. What I've tried so far is adding a field directly to the database through a SQL management application, and then going to WebDev's Analysis tab and selecting Synchronization -&gt; "Update the analysis from the external databases". This generally causes the application to crash, but when I start it back up it does appear the changes have been made.&#13;
&#13;
However, it also makes a number of other changes which I would like to avoid. All I want to do is add in two new columns to the database, but the wizard insists on updating and adding a number of new fields including a lot of "missing_index" fields. The end result is that these updates break the functionality of the form and the queries fail. Prior to making any changes the form functions as expected.&#13;
&#13;
Can anyone provide some insight or assistance in adding new fields in the simplest way possible? Any help is greatly appreciated, thanks in advance.</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev/read.awp</link><title>Adding new column to db in WebDev 19</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51995/read.awp</comments><pubDate>8 May 2015 17:57:00 Z</pubDate><description>Our approach is never sync from the db to the Analysis, you will have a lot of problems.&#13;
&#13;
We add the new column in the Analysi…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51995/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51995/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev/read.awp">Adding new column to db in WebDev 19</source><title>Re: Adding new column to db in WebDev 19</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51990/read.awp</comments><pubDate>8 May 2015 15:52:00 Z</pubDate><description>Hi Sam&#13;
&#13;
I'm not quite sure when using sql Express, but normally I just add extra fields in the analyse and let Webdev do the W…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51990/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev-51990/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51984-adding-new-column-webdev/read.awp">Adding new column to db in WebDev 19</source><title>Re: Adding new column to db in WebDev 19</title></item></channel></rss>
