Results 1 to 4 of 4

Thread: adding fields at a later time

  1. #1

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    57

    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

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: adding fields at a later time

    Are you talking about changing the fields in a backend database?

  3. #3
    Fanatic Member Dnereb's Avatar
    Join Date
    Aug 2005
    Location
    Netherlands
    Posts
    863

    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.

  4. #4

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    57

    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
  •  



Click Here to Expand Forum to Full Width