Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Column Order wrong using ODBC and MS JetEngine

Column Order wrong using ODBC and MS JetEngine

From: Sven Kunze <svenkunze_at_aol.com>
Date: 1998/03/09
Message-ID: <19980309232800.SAA07051@ladder03.news.aol.com>#1/1

Urgend and important - please help !

I migrate a Visual Basic 4.0 program (16-bit) from MS Access Database to Oracle via ODBC.

If I ask Oracle via Oracle SQLPlus or Oracle SQL Worksheet "Select * From xxx" the column order
 of the result is ok (like on the server), but if I do so in Access 2.0, Access 97
or Visual Basic 4.0 (16-Bit) it isn´t.

I recognized that this problem occurs if there are more than 36 columns. The wrong order occurs
always in blocks of 36 columns, e.g.:

Table with 76 columns Col1-Col76

Select * from x

->>

Normal: Col1, Col2, ....Col76

I get: Col73, .., Col76, Col37,.., Col72, Col1,.., Col36

My old and big program (former with MS Access database) should have the right order,
because it´s logic works with the column position, not with the name.

I don´t like to put the column names instead of "*" in the select-statement.

What is the problem ?

***
*I use ORACLE 8.0.3.0.0 on NT Server 4.0 (SP3), TCP/IP, and Client NT 4.0 (SP3) with Access 2.0 / 97 / Visual Basic 4.0 *(16-Bit) with ODBC 8.0.3.0.0 32-Bit.

*
* ->>>Answer please to SvenKunze_at_AOL.com<<<- 
***
Received on Mon Mar 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US