Got2BeFree wrote: ↑Friday 9th August 2024 9:31pmGlad that was of some help. I usually have 'db.Debug = True' at the beginning of a block I need to watch and 'db.Debug = False' at the end and I'll usually just comment 'db.Debug = True' out when not needed. Most of my projects have it buried somewhere in at least a few different places.AndyGable wrote: ↑Friday 9th August 2024 3:15pmA couple of updates that I though you all would like to knowGot2BeFree wrote: ↑Friday 9th August 2024 3:11pm Anytime I'm dealing with database issues, I use 'db.Debug = True' to watch any database query.
Fist off @Gpt2BeFree I did not know that db.debug option that is a much quicker way to view the SQL Commands I am send then saving them to a text file and reading it in latter
I found that I was using Integer in the database recall function so I changed that to float and now as you can see from the image below i have it working using columns
...
[snipped]
...
Also does anyone know how I can get the values along the side to show up? (example my biggest value at the moment is £1447.98 and I would like to show that on the side)
Can't help out on the chart problem since I've never had an occasion to use it.
You can be sure I will be using that more often now so I can make sure my SQL Commands are correct