Re: Strange schema behaviour

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 01/07/05 

Date: Fri, 07 Jan 2005 07:36:46 -0600

On 7 Jan 2005 04:07:24 -0800, scbate@hotmail.com wrote:

¤ I have a schema that defines some tables.
¤
¤ Table1 say, has columns A, B, C, D and E
¤
¤ I would expect that when I create Table1 that the columns would be in
¤ the order specified i.e A,B,C,D,E.
¤
¤ However, for some reason that I cannot see the columns appear mixed up.
¤ When I place a breakpoint and examine the ColumnFromName collection
¤ which is a property of the Columns property of the Table they are in a
¤ different order.
¤
¤ Can anyone explain why this is so?
¤
¤ The tables are populated from CSV files produced by an ECR and so I'm
¤ relying on the column order.
¤
¤ Does anyone know why this happens or how I can ensure the table is
¤ created with columns in the same order as they are defined in the
¤ schema?
¤

I don't recall ever seeing this happen with a CSV file. Do you have some code you can post and a few
sample lines of the CSV file?

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Strange schema behaviour
    ... I have a schema that defines some tables. ... Table1 say, has columns A, B, C, D and E ... which is a property of the Columns property of the Table they are in a ... Steve ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Importing schema properties
    ... If the users already exist in the directory you cannot use csvde to update them. ... In that case a custom script will need to be written that loops through the CSV file and updates the appropriate attributes. ... OP will confuse folks by saying schema unless they are actually modifying the schema of a domain. ... What's the best way to import schema information that we have stored in a CSV file? ...
    (microsoft.public.win2000.active_directory)
  • Re: Appending tables
    ... So I will give the schema definations of the tables here: ... CREATE TABLE TABLE1 ... CREATE TABLE TABLE2 ... CREATE TABLE TABLE3 ...
    (comp.databases.ms-sqlserver)
  • Re: Validate a CSV file
    ... a SP into a clone of the target table (just schema). ... >validate against our database.I was thinking about loading that CSV file ... >into a Typed-Dataset which has our database schema in it and then try to ... > of those refferecing tables into my dataset as well? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Validating a (wrong) message just succeeds
    ... bad csv file that reproducess the problem so that I can look into this. ... I'm running into validation problems with Biztalk 2004. ... not more than the one in the schema of course. ... the 9th field of the first record is simple ...
    (microsoft.public.biztalk.general)