Jul-24-2023, 03:00 PM
Thank you for your swift reply.
Actually what I need most help with is finding out what the first dictionary in the list is called so I can use your formluae.
It may be that someone has deleted ford or added audi. Which is acceptable if their follow the structure. So the problem starts with getting the name of the first dictionary in the database, so ford.keys() may not work if ford is not in the list.
So can I access the first dictionary using a numerical value like [0] or ["0"]
I could possibly create a dummy car called AAAA with dummy values but correct keys, but that seems a bit self defeating.
Why make life easier for the computer when it should provide what I want???
If sqllitedict is a wrapper could I just use sqlite to find the first rows dictionary name and the using that revert to sqlitedict to retrieve the dictionary associated with it. Probably over kill, I suspect.
Thanks again,
Actually what I need most help with is finding out what the first dictionary in the list is called so I can use your formluae.
It may be that someone has deleted ford or added audi. Which is acceptable if their follow the structure. So the problem starts with getting the name of the first dictionary in the database, so ford.keys() may not work if ford is not in the list.
So can I access the first dictionary using a numerical value like [0] or ["0"]
I could possibly create a dummy car called AAAA with dummy values but correct keys, but that seems a bit self defeating.
Why make life easier for the computer when it should provide what I want???
![Big Grin Big Grin](https://python-forum.io/images/smilies/biggrin.png)
![Big Grin Big Grin](https://python-forum.io/images/smilies/biggrin.png)
![Big Grin Big Grin](https://python-forum.io/images/smilies/biggrin.png)
If sqllitedict is a wrapper could I just use sqlite to find the first rows dictionary name and the using that revert to sqlitedict to retrieve the dictionary associated with it. Probably over kill, I suspect.
Thanks again,
![LOL LOL](https://python-forum.io/images/smilies/icon_lol.gif)