[Python] Get SQL Select result in a variable
Posted: Mon May 17, 2021 1:39 pm
Hello,
How do you place in a variable, the result of a Select query contained in a Python script?
In traditional python, fetchall () does the birch well but in libre office, its not working!
In this case, a message box returns true
Each row in the table should normally be represented by a tuple in result.
So the problem I want to solve is to work on these tuples.
cordially
How do you place in a variable, the result of a Select query contained in a Python script?
In traditional python, fetchall () does the birch well but in libre office, its not working!
Code: Select all
rqt = "SELECT * FROM Table1"
rslt = statement.excute(rqt)
Each row in the table should normally be represented by a tuple in result.
So the problem I want to solve is to work on these tuples.
cordially