Excellent Tutorial, Thank you very much for making this video, Sir I have a query, I am trying to highlight a row by double clicking on it in treeview, it should keep highlighted and add additional fields if I add any. I have seen your video on Treeview highlight but thats on condition based, based on marks acquired by the students, can you please send the link if you have already made any video as per my request.
www.plus2net.com/python/tkinter-mysql-update.php Using Product table www.plus2net.com/python/tkinter-restaurant-update.php You can select any record by clicking on it, then details can be edited and updated.
Based on the number of rows , pages can be added. This program will add additional pages, headers footers can be created which will be integrated to each page. Check here. www.plus2net.com/python/pdf-table.php
@@plus2net1 Thank you for kind answer. Sqlite3 connecting string in our case is: 'C:\Users\Public\DesktopD:\Python\sqlite3_projects\Std_info\std.db' Follow it, but python throw error: "Could not parse rfc1738 URL from string '%s'" % name sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string 'C:\Users\Public\DesktopD:\Python\sqlite3_projects\Std_info\std.db' It is interesting to see how looks connecting string (path) in case presented on video. Regards Slobodan
@@slobodanmilic1331 I think you are passing some parameter in your query ? Then in place of %s use ? . For checking the connection string , stop using any parameter in query and run one simple select query. If it works then there is no issue with your connection string. How you have D drive after your Desktop ? Just check your connection string.
Thank you very much for making this video on our request. before trying the code I wanted to thank you. It's so kind of you.
You're welcome!
Excellent Tutorial, Thank you very much for making this video, Sir I have a query, I am trying to highlight a row by double clicking on it in treeview, it should keep highlighted and add additional fields if I add any. I have seen your video on Treeview highlight but thats on condition based, based on marks acquired by the students, can you please send the link if you have already made any video as per my request.
www.plus2net.com/python/tkinter-mysql-update.php
Using Product table
www.plus2net.com/python/tkinter-restaurant-update.php
You can select any record by clicking on it, then details can be edited and updated.
Hello sir, how to add one more page in the pdf file.
Based on the number of rows , pages can be added. This program will add additional pages, headers footers can be created which will be integrated to each page. Check here.
www.plus2net.com/python/pdf-table.php
Thanks! Bro create table on this pdf page from database.
thanks for the idea, we will add that after invoice generation.
More details for 'sqlite: ///'
That is used for creating SQLite connection string, As it is a file based database so file location - address is required to connect.
@@plus2net1
Thank you for kind answer.
Sqlite3 connecting string in our case is: 'C:\Users\Public\DesktopD:\Python\sqlite3_projects\Std_info\std.db'
Follow it, but python throw error: "Could not parse rfc1738 URL from string '%s'" % name
sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string 'C:\Users\Public\DesktopD:\Python\sqlite3_projects\Std_info\std.db'
It is interesting to see how looks connecting string (path) in case presented on video.
Regards
Slobodan
@@slobodanmilic1331 I think you are passing some parameter in your query ? Then in place of %s use ? .
For checking the connection string , stop using any parameter in query and run one simple select query. If it works then there is no issue with your connection string.
How you have D drive after your Desktop ? Just check your connection string.