[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Which entry in a df file defines the position of a field in the SQL schema or "SELECT *

[Stefan Marquardt]

Hi Steve, thank you for the fast reply. Since today i didn't care so much about df files, thought POSITION in df is r-pos and expecting a longer df load too. This means I have no possibility to define the field order for SQL :-( As we are using SQL more and more for data checks I started to defined the order by the main/foreign index. It's really useful to have the main field key values at the beginning to build WHERE statement in JDBC tools with a mouse (set the range to define where queries) to find records in related tables Now the key needed to be enhanced and I can't get it at the end of the current key fields as it is possible in MS SQL Server (of course) Means now i have to D&L the table to change the physical order, binary or text? I guess text

Continue reading...