4Eyes Posted May 25, 2009 Share Posted May 25, 2009 (edited) I've looked at the SQLite entries in the help file plus MANY threads (inc. ptrex's) and snippets here + www.sqlite.org but am still vague about how to use it. The best stuff I've found so far is the Point of Sale code posted here somewhere and AAMP looks interesting too although I can't get it to work.What I want to do (myself, I don't want to be spoonfed, just given some pointers) is to be able to interrogate a database and list all/first/last/next/previous record(s) where any nominated field is =, <>, <= or >= some specified value. Is this possible or am I asking for too much?Also, if at some time I wanted to add or remove a field can I do this with a simple command or is it a matter of reading all records 1 by 1 into variables and writing back the data with/without the extra stuff to a new db?Do I need to index anything?If the above hasn't been done (and I see that the example in this link: http://www.autoitscript.com/forum/index.ph...st&id=18082 goes somewhat toward what that but is not what I need), then I'll try to make an example and post it here if anybody is interested.Thanks,4Eyes Edited May 25, 2009 by 4Eyes Link to comment Share on other sites More sharing options...
KaFu Posted May 25, 2009 Share Posted May 25, 2009 (edited) My program SMF thoroughly utilizes all kinds of SQLite functions, check it out . Edited May 25, 2009 by KaFu OS: Win10-22H2 - 64bit - German, AutoIt Version: 3.3.16.1, AutoIt Editor: SciTE, Website: https://funk.eu AMT - Auto-Movie-Thumbnailer (2022-Nov-26) BIC - Batch-Image-Cropper (2023-Apr-01) COP - Color Picker (2009-May-21) DCS - Dynamic Cursor Selector (2024-Feb-16) HMW - Hide my Windows (2018-Sep-16) HRC - HotKey Resolution Changer (2012-May-16) ICU - Icon Configuration Utility (2018-Sep-16) SMF - Search my Files (2023-Jun-03) - THE file info and duplicates search tool SSD - Set Sound Device (2017-Sep-16) Link to comment Share on other sites More sharing options...
4Eyes Posted May 25, 2009 Author Share Posted May 25, 2009 My program SMF thoroughly utilizes all kinds of SQLite functions, check it out .Danke shoen! Thanks heaps. I've had a quick squizz at the exe file but not the source. Very impressive/ I'm sure I'll learn lots.Regards,4Eyes Link to comment Share on other sites More sharing options...
KaFu Posted May 25, 2009 Share Posted May 25, 2009 Gern geschehen... you're welcome ... OS: Win10-22H2 - 64bit - German, AutoIt Version: 3.3.16.1, AutoIt Editor: SciTE, Website: https://funk.eu AMT - Auto-Movie-Thumbnailer (2022-Nov-26) BIC - Batch-Image-Cropper (2023-Apr-01) COP - Color Picker (2009-May-21) DCS - Dynamic Cursor Selector (2024-Feb-16) HMW - Hide my Windows (2018-Sep-16) HRC - HotKey Resolution Changer (2012-May-16) ICU - Icon Configuration Utility (2018-Sep-16) SMF - Search my Files (2023-Jun-03) - THE file info and duplicates search tool SSD - Set Sound Device (2017-Sep-16) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now