LB Booster
General >> Showcase >> Remember - It http://lbb.conforums.com/index.cgi?board=showcase&action=display&num=1471760485 Remember - It
Post by Jack Kelly on Aug 21st, 2016, 06:21am
Here's a useful flat-file database application. I designed it many years ago and have been running it every day since. I have now completely rewritten it using the Cheetah 2 Database System. The program uses 30 different Cheetah functions and two system variables. Cheetah 2 doesn't seem to be able to do wildcard queries on a date field, only on a character field. If I find out otherwise, I'll update the Search section. And I haven't figured out how to trap Cheetah errors. When I do I'll consider implementing a unique name index.
Click the following link to download it from my homepage-- Get it here.
This is a link to the .zip file, which contains the .bas file, a .txt help file, ding.wav, the compiled .exe file, and the two cheetah .dll files. When you run the program it automatically creates a database file with a few sample records. If you encounter any problems please let me know in this thread.
Re: Remember - It
Post by joker on Aug 21st, 2016, 09:57am
... I have now completely rewritten it using the Cheetah 2 Database System.... I'm not a very patient and methodical tester....
Not exactly an awe-inspiring introduction!
The LBPE entry for CHEETAH (http://lbpe.wikispaces.com/A+Kit+for+Using+Cheetah) was made in 2010, and at that time it was said, "... The author, Paul Squires, has removed it from his website ..." and "Walt Decker has released his wrapper dll package that allows Liberty Basic to use the Cheetah database dll. He gave it a public domain license!"
Can't this CHEETAH DLL be incorporated more completely into the BASIC dialects now that it's public domain?
Database functionality is what I sorely missed when going back to programming in BASIC.
Re: Remember - It
Post by tsh73 on Aug 21st, 2016, 4:48pm
I'm deeply impressed by amount of subroutines/functions in code. Are they actually used or it's just part of a Cheetah kit? EDIT after some playing, is there idea of "current" line in a big table which supposed to be opened on pressing EDIT? It really looks somewhat random for me (no selection - "Constitution Day (Norway)" record edited selection by double click Mette-Cathrine - "Mette-Cathrine & Jack" record edited selection by double click Kelly - empty record edited (?) selection by double click Jack - " Jack Kelly" this record edited ) (EDIT2 actually it's explained in a helpfile. I got it after third read I think But thing that you should select exactly first word not very obvious for me) If main big table would be a listbox, you would have current record instantly visible.
Re: Remember - It
Post by Jack Kelly on Aug 21st, 2016, 9:30pm
Thank you, tsh73, for trying Remember - It, and for the good feedback. In the Cheetah Database System section of the source code there are 48 functions and subroutines. The program only uses 30 of them. The rest are there for completeness, and for those who want to experiment with Cheetah. There are more Cheetah functions that I haven't yet made subs or function defs for.
I did find a bug in my code when looking into the edit selection of other than the first word. The edit screen reports 'Not Found' but <Exit> thinks the blank record is a change. I have fixed this bug and uploaded a revised ZIP file. It can be downloaded using the same link.
Sorry for the bother, but thanks again for your effort. Jack
P.S. -- I'll have to think about using a listbox rather than a texteditor for the reports. Good suggestion, though...
But thing that you should select exactly first word not very obvious for me)