Strange schema behaviour

  • Thread starter Thread starter scbate
  • Start date Start date
S

scbate

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?

Many thanks

Steve
 
On 7 Jan 2005 04:07:24 -0800, (e-mail address removed) 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top