If i change any table definition after using the
fields on a form VS stalls and doesnt allow to
load the form
How can it be done?
thanks
Printable View
If i change any table definition after using the
fields on a form VS stalls and doesnt allow to
load the form
How can it be done?
thanks
Are you talking about changing the fields in a backend database?
If your talking about a sql server (express)
you can add a column with:
ALTER TABLE
dbo.yourTable ADD New_Column VARCHAR(20) NULL ;
on your database. this won't mees up your original code
but the added column won't be used either.
To use it you can create a new dataset for the table
but it would be better to use a sql.command calling a stored procedure.
The main advantage is exactly to avoid your problem..
Add a column to the dataset and add selecting it in the stored procedure...
for the complete syntax:
http://msdn.microsoft.com/en-us/library/ms190273.aspx
What i mean is:
I have a table from an access database
I generate a dataset that contains the table
an fill a form with the fields
Then i add another field to the database table
When i try to use the modified table
VS STALLS