|
-
May 15th, 2010, 06:14 AM
#1
Thread Starter
Member
adding fields at a later time
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
-
May 15th, 2010, 07:58 AM
#2
Re: adding fields at a later time
Are you talking about changing the fields in a backend database?
-
May 15th, 2010, 09:31 AM
#3
Re: adding fields at a later time
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
 why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
for every question you ask provide an answer on another thread.
-
May 15th, 2010, 06:46 PM
#4
Thread Starter
Member
Re: adding fields at a later time
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|