Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Column Order wrong using ODBC and MS JetEngine
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