Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread Extracting data from multiple tables
Tue, Sep 26 2006 12:55 PMPermanent Link

Jerry Blumenthal
Thanks, Charles, I've already discussed that with the people involved.
They assure me that that can NOT happen, because they would then open up
a separate patient account for that person!!!

That is not how I designed the software to work, but if they have been
happy doing that, that's ok with me.

Still, I do think you are correct that I should have some kind of check
for it, and I will try to make sure.

Jerry


Charles Tyson wrote:
> Jerry,
>
> Be sure you understand the situation before you delete any "obsolete" records from the
> patient database.  Suppose patient X has Doctor A as her PCP (primary care provider).  One
> day she asks for an appointment, and the receptionist tells her "Doctor A is on vacation,
> do you want to see Doctor B instead?"  X says yes, that's fine.  Now Doctor B has billing
> records linked to patient X, even though B isn't X's "provider".  Doctor A is leaving the
> practice.  If you delete X from the database (because she "is A's patient"), you'll orphan
> some records that B needs to keep.
>
>

Tue, Sep 26 2006 1:05 PMPermanent Link

Jerry Blumenthal
Manfredt-

What kind of feedback do you mean?

I actually wrote this app in 1977 (!) on an Apple//, in Applesoft.  I
changed it rather dramatically when I purchased an IBM PC a few years
later, and bought a copy of a program named "Turbo Pascal", the manual
for which I have sitting in my library, staring at me.  I have very warm
feelings for TP.

Initially, I devised my own methods of storing records on the Apple.
When I went to the PC, I used Btrieve for my first iteration of the
program; I actually used variant records at that time, since that
mimicked how I had stored records in the Applesoft program.  When I
moved to using TP, I also moved to Paradox and had to learn about how a
database worked.  Much later in the game, well after using Paradox with
Delphi, I switched to dbIsam.

I dont know if this is what you were interested in, or if it was some
other aspect.  Let me know.

Regards,
Jerry



Manfredt Kavetu wrote:
> Jerry,
>
>> In a medical office
>
> Are you designing a medical application using DBISAM? If yes could you provide
> more feedback?
>
> Manfredt Kavetu
>
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image