Here's another solution I've discovered if the FORCE option doesn't suit your needs.
ODBC CONNECT TO {connection}; //or oledb
SQLTableColumns:
load *;
SQLCOLUMNS; //returns info on all poss tables and columns via the connection
//Build SQL Commands
//This effectively concatenates a list of all the fields in that table and builds a dynamic select string (limited only to the tables you need by the MATCH command)
SQLSelectCommands:
LOAD
TABLE_NAME,
'Select ' & concat(lower(COLUMN_NAME),',') & ' from ' & TABLE_NAME AS ColList
resident SQLTableColumns
where Match(TABLE_NAME,'{table1}','{table2}','{table3}' ...) > 0
Group By TABLE_NAME;
DROP TABLE SQLTableColumns; //don't need this anymore
//when you are ready to do the select * command, replace as follows for each table
LET cmdSQL = Lookup('ColList', 'TABLE_NAME', '{table}'); // where {table} is your source SQL table
Order1:
LOAD {QV LOGIC as previous}
SQL $(cmdSQL) where clause ...;
I have only tested this briefly, but seems to work. Hope it helps.
flipside
EDIT: This works with some drivers and not others. My Informix driver can return either all UPPERCASE or all LOWERCASE by using the FORCE CASE command, but default is lowercase - not mixed - and cannot FORCE mixed, even if ColList above uses column name aliasing. With Microsoft Excel driver though, mixed cases are possible and this works.
