doesn’t really work as I want it to. Can you please give me some hints as to
how to get the loops to work as I explained or, if there is another better way
to do it, what would that look like?
Thanks a lot for your guidance.
Kaun
KUAN LU, CPA, CGA | FINANCE TEAM LEAD
rsor.execute("SELECT * FROM Visa.CreditCardStatement WHERE
TransDate=(SELECT MAX(TransDate) FROM Visa.CreditCardStatement)")
#gather the column name info for the dictionary
columns = [column[0] for column in Loaded_Trans.description]
#create the empty dictionary to hold the loaded transacti
