Results 1 to 3 of 3

Thread: Dataset index vs tablename - weird

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Dataset index vs tablename - weird

    I have a dataset that gets filled with one table, although it can be a different table depending on the user selection.
    I've been using ds.Tables(0).Rows.Whatever just fine. But after a few days off, I came back and most of those references (but not all!) now only work when I use the tablename, e.g. ds.Tables("SomeTable").Rows, etc. ds.Clear is always called before da.Fill. What's going on, any clues? Thanks.

  2. #2
    PowerPoster
    Join Date
    Dec 2003
    Location
    Bristol, England (but heart is in Virginia)
    Posts
    2,949
    Hi,

    The chances are that during your absence someone has messed aroung with the source in the Database. If you have used a query rather than a simple table, that is even more likely. (I assume that no one else could have messed up your programme). Check the spellings (including case) of your field names etc.
    Taxes
    The more I learn about VB.NET the more I like dBaseIII Plus

    The foregoing, whilst believed to be correct, is given without guarantee as to it's accuracy and entirely without recourse. You are required to decide for yourself whether or not it is suitable for your purposes and no liability for loss of any nature can be entertained.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950
    I suppose they could've, but I'm the only one who works on this, and I use a test db (named Test) on the server. These are untyped datasets, because the user can select from about 60 db's to connect to. Well, when all else fails, reboot! Thanks.

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