Comments by asaad kittaneh (Top 18 by date)

@Richard MacCutchan thank you very much, I am appreciated your help, finally its worked :)

@Richard MacCutchan I have tried everything and it doesn't work at all, and comparing date=date = datetime.now() with the dates on the database will never work because when printing(date) it shows the date and the time 2022-05-03 16:04:03.135530 and its doesn't work to compare date only with date and time that's why I convert date=datetime.now to date.strftime('%d-%m-%Y')

@Richard MacCutchan iam using now self.dateinfo = self.cursorObj.execute(
'SELECT registration_check_date, car_type FROM buying_rigistration_date WHERE registration_check_date=?', (date,))
but it didn't work too, and to clarify more when I print the date from the Database I got this date pattern ['03-05-2022', 'Alfa Romeo'], is there any solution to comparing the current date with this type date that I fetched from the database

@Richard MacCutchan thank you for your reply, I tried it before and it didn't work, to clarify the situation more, I have used DateEntry from tkcalendar to insert and store dates on the DB using date_pattern='dd-mm-yyyy' , I edited the question to be more clear for you, if you could take another look at it, I hope the situation will be clearer now.

I am trying to insert specific events in the calendar and these events will be selected from the database table and every row
including an event and date I succeed with inserting dates into the calendar but my goal is to insert the date and the event, not just the date, so when the user clicked on the colored calendar date cell, the GUI displays the date and event that is fetched from the DB row that including the specific date.
my problem: is that I don't know how to display the event and the date in the self.event label, it only shows the selected date.

can you help?

Thank you for alerting me, now it's better

@Andre Oosthuizen thank you very much

@Richard MacCutchan, thanks for your reply it's in another button, my goal is to insert items into Treeview using a button and save them into Database with another

@Richard MacCutchan Thank you, man, I tried to spell it with capital C, but Unfortunately, it's not doesn't work, thanks to you again man, God bless you, I will try to install it on python site-packages.

@Richard MacCutchan Thanks for the reply, I appreciate your help, I installed it, what is the next step, where do I put that library, I want to inform you that I am using pycharm, thanks in advance.

Richard, it's a stand-alone Windows, thank you for your response I solve it.

thank you for your response, I am trying to create functions that allow the user to upload a picture and then save it in the sqlite3 database, so first in the def filedialogs function: the user will load an image, and in def convert_image_into_binary: it will convert the image to blob so I can add it in the database, but there is a problem with my method, so is there another method that will help me achieve this. thanks in advance