Author |
Topic: Remember - It (Read 633 times) |
|
Jack Kelly
Full Member
member is offline
 
Gender: 
Posts: 106
|
 |
Remember - It
« Thread started 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.
|
| « Last Edit: Sep 27th, 2016, 06:56am by Jack Kelly » |
 Logged
|
|
|
|
joker
Global Moderator
member is offline
Gender:
Posts: 157
|
|
Re: Remember - It
« Reply #1 on: Aug 21st, 2016, 09:57am » |
|
on Aug 21st, 2016, 06:21am, Jack Kelly wrote:| ... 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.
|
| « Last Edit: Aug 21st, 2016, 10:00am by joker » |
Logged
|
|
|
|
tsh73
Full Member
member is offline
Gender:
Posts: 210
|
|
Re: Remember - It
« Reply #2 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.
|
| « Last Edit: Aug 21st, 2016, 5:11pm by tsh73 » |
Logged
|
|
|
|
Jack Kelly
Full Member
member is offline
Gender:
Posts: 106
|
|
Re: Remember - It
« Reply #3 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...
|
|
Logged
|
|
|
|
|
