Questions tagged as 'pyodbc'

1
answer

Difference between NULL, empty and blank Python

I am making a Data Quality that receives a list with data from a Database and I have two rules: Null fields: Fields that are filled with the word NULL Blank / empty fields: Fields that come in blank or empty For the NULL rule I a...
asked by 15.05.2017 / 18:26
2
answers

Python code too slow ?? Access to Access database with pyodbc

I need to get some data from a huge access database (two, actually, depending on which input I have). I have a function that calls that bank by chunks (if I try a fetchall gives memory problem). This function is sometimes called by my main funct...
asked by 20.07.2018 / 18:48
1
answer

Select with pyodbc

I'm trying to use the string I get from an Entry and an OptionMenu to perform the search on SqlServer but gives the following error: TypeError: not enough arguments for format string Here is the function code that executes the call: def c...
asked by 18.04.2018 / 21:38