Welcome to python-forum.io

Ok, I figured the only way I could possibly get help is if i provide the code. URL is a zip file of the db, py and image. http://www.filedropper.com/whacky7devbuild01adctool The edit/update functions...

whacky7

General Coding Help

4,966

Jan-21-2020, 02:46 AM

Thread: printing selected item with Sqlite data
Post: RE: printing selected item with Sqlite data

Hi Guys, Larz60+ Ok, this is what I can get so far. image URL: https://ibb.co/MpNdfTk What I need is to split the data queried from SQLite > I guess it needs to be set as a tuple and return the f...

whacky7

General Coding Help

4,966

Jan-20-2020, 06:32 AM

Thread: printing selected item with Sqlite data
Post: RE: printing selected item with Sqlite data

Yeah, sorry it is only a snippet of my code as it's approximately 1000+ lines. The button function on save changes I've removed temporarily. Only kept the minimum to figure out the reason the form is...

whacky7

General Coding Help

4,966

Jan-19-2020, 01:42 AM

Thread: printing selected item with Sqlite data
Post: RE: printing selected item with Sqlite data

here is what my line of code when I click the Edit button. I know that I will need to insert the SQL data into the text box. For the time being I am even having trouble getting the window to display ...

whacky7

General Coding Help

4,966

Jan-19-2020, 12:09 AM

Thread: printing selected item with Sqlite data
Post: RE: printing selected item with Sqlite data

Yep Sorry Larz60+, I realised that after and hence posted it here also.

whacky7

General Coding Help

4,966

Jan-17-2020, 09:08 AM

Thread: printing selected item with Sqlite data
Post: RE: printing selected item with Sqlite data

Hi Larz60+ Thanks for your message. I have pm'd you but thought I would reply here also for others to possibly help out. I have uploaded 3 images: (3rd link is my intention) https://ibb.co/L0R5mrQ h...

whacky7

General Coding Help

4,966

Jan-17-2020, 02:39 AM

Thread: printing selected item with Sqlite data
Post: printing selected item with Sqlite data

Hi All, It has been some time since I have finished writing my program. I have run into a problem where I am trying to print and export data from sqlite3 db to a form so I can modify/edit the data an...

whacky7

General Coding Help

4,966

Jan-16-2020, 02:06 AM

Thread: SQLite Query multiple column search
Post: RE: SQLite Query multiple column search

Ichabod801, Thanks so much mate. That worked! I was making errors on the following line of code: ('%'+str(SEARCH2.get())+'%',))

whacky7

General Coding Help

8,414

Apr-01-2019, 09:29 PM

Thread: SQLite Query multiple column search
Post: RE: SQLite Query multiple column search

Oh, I See. I am getting stuck with syntax errors and not quite sure how to include the operator twice within the statement (cursor.execute)

whacky7

General Coding Help

8,414

Mar-29-2019, 05:29 AM

Thread: SQLite Query multiple column search
Post: RE: SQLite Query multiple column search

Hi ichabod801, Thanks for your reply. I am not sure on which other operator I can use in order to search across all columns within assets2? or as you mentioned, fine to search across both columns 'as...

whacky7

General Coding Help

8,414

Mar-29-2019, 03:35 AM

Thread: SQLite Query multiple column search
Post: SQLite Query multiple column search

Hi Guys, As per my previous post, I am new to Python (Gui) and in the process of learning. I am having a particular issue with a search query against SQLite Db. What am I trying to achieve? I have ...

whacky7

General Coding Help

8,414

Mar-28-2019, 11:08 PM

Thread: Text Entry and Querying CSV
Post: RE: Text Entry and Querying CSV

Thanks Larz60+ Your script has helped me a lot. I will be setting this post as resolved. I will be making another post regarding SQLite select query that I'm having issues with - hoping you can hel...

whacky7

General Coding Help

3,042

Mar-28-2019, 11:19 AM

Thread: Text Entry and Querying CSV
Post: RE: Text Entry and Querying CSV

Thanks Larz60+, I have had a read and tried a few functions and still not able to get the results I'm after. It prints every row to the command window. Simply, I need to search a CSV column for the ...

whacky7

General Coding Help

3,042

Mar-25-2019, 12:32 AM

Thread: Text Entry and Querying CSV
Post: Text Entry and Querying CSV

Hi Guys, First off, I am new to Python and coding. I do apologise if this question has already been asked. I have searched the forum board and was unable to find a thread that gave me the answer I'm ...

whacky7

General Coding Help

3,042

Mar-24-2019, 09:53 AM

Results

User Panel Messages

Announcements