Re: ODBC Fields Order

[Rob Berendt <rob@xxxxxxxxx>]

I saw 'SELECT * through ODBC from the copy'.  I also saw 
'SELECT * of the original'.  My question is this.  Were 
both selects done using ODBC, or just the first?  If you 
do both selects using STRSQL what field order do you get?  
What I am getting to is this, is it possible that your 
ODBC tool does something weird like put the fields in 
alphabetic order before presenting them?  Regardless of 
how the file was created:  DDS, SQL, ODBC SQL, or whatever;
CRTDUPOBJ will NOT reorder fields.




dshaw@spartan.com on 03/10/2000 11:12:29 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        ODBC Fields Order

We have a file which was created by an SQL statement sent through ODBC to the
/400.  When I create a copy of it using CRTDUPOBJ, everything looks fine from
the /400, however if I do a SELECT * through ODBC from the copy, the fields are
all out of sequence.  If I do the SELECT * of the original, the fields are in
the correct sequence, the same DSPFFD or SQL on the /400 shows them.  Maybe I'm
blind, but I can't find any documentation saying that this might occur.  I'm
told that this was first seen at V4R2, but I wasn't here then.  We're at V4R4
now.  Does anyone have any idea why this might be?  Thanks!

Dave Shaw
Spartan International, Inc.
Spartanburg, SC
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---