|
Re: I don't need Windows much at all anymore
|
Alexander Caldwell
|
Oct 21, 2007 17:46 PDT
|
Jerry,
The choice for the drugstore or other recipient you want to send a fax to could be made from a tablelist box widget just as easily, or perhaps more easily, just by calling up the "Pharmacies" table from the Sqlite database in a tablelist widget as you say, rather than using the cascading menu thing it has now. The end result of your choice is just selecting the unique fax name by which the outgoing fax files are named , once the fax files are created and stored in the outgoing fax directory, then test3.tcl will have to still look up the phone number that goes with that unique fax file name before it calls up efax and sends it out over the fax modem. What I will do is keep the old flat file system and then just add an entirely new option of using the new system until I get it working well, then eventually probably remove the old system. On my setup, the first thing I may have to do is get sqlite working on my old 486, so I can store the numbers and such in there for
test3.tcl to access.
Alex
Jerry Park <park.-@gmail.com> wrote:
Alex,
I'm wrapping my mind around using the tablelist instead of the
"tear-off" cascading menu to send or at least store the data for a
prescription fax and maybe still use the tear-off cascading menus.
Retrieving the data from a tablelist to populate TFP_drugrefill.tcl
variables is no problem, of course.
I wouldn't mind using a tablelist to select a row for the drugstore as
opposed to using tear-off menus. I think it would be pretty similar
for speed of use either way. Then you wouldn't have to query the
entire database to populate a tear-off menu.
I assume you are heading for a more "unified structure", using a
tablelist widget/and table storage for the drugstores rather than the
current "drugstorelist" flat file. A table would also allow for
storing the pharmacy's regular telephone number and any other optional
information which could be viewed from the tablelist widget. That
would be very handy so that if a fax wasn't received or any number of
other problems come up you've got fast access to the telephone number
(and maybe the pharmacist name, or whatever). The extra information
would probably be more important for, say, Express Scripts or a send
off pharmacy.
I downloaded tkfp_tablelist2_network.tcl and tried it - worked fine
here at work today.
Jerry
| | Jerry,
That's right, but the starkit Tcl/Tk file that has all the Tcl/Tk
interpreter files and needed extensions remains compressed on the disk, so
it not taking up anywhere near as much disk space as when you have it
installed it in a regular installation, such as you would do with the
ActiveTcl, I'm pretty sure that is right. Plus with the starkit version, you
could make up a custom package that only has the extensions needed to run
the app, and eliminates uneeded ones, so that could keep it a bit smaller as
well.
I think I will experiment with using the SQL statements to get data for
Tkfp, instead of just grabbing the row from the tkfp_tablelist2_network.tcl
gui. It was just convenient to do it that way for the situation I had. Of
course, whatever way I get the data from the sqlite database, it will still
need to be put into some type of Tcl data structure, like a variable, list
or array. Now they have a new structure called a "dict". I need to learn
more about it as apparantly it is useful for some things.
But I was thinking the next thing I use the Rolodex for would be to make a
new way to select the current "drugstore" for sending the faxes to. The
current method uses a simple file with a unique fax name and a phone number,
each on one line. But I could make a method that would query the database
for all the names, put those in a pop up cascading menu like it has, then
when you select one of those, use another SQL query to get the fax number
for that drugstore, etc. I would also have to change the way the test3.tcl
program that does all the work of sending out the faxes works, so it would
get the list along with the fax numbers from the SQLite rolodex as well.
That would be a bit more challenging than the current method from the simple
file. I would also need to get sqlite working on my old 486 on the older
version of Linux it is using, since it is where the faxes are actually sent
from in my situation. I will have to check into whether the current version
of Sqlite will run on that old thing.
Alex
|
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
|
 |
|
