Relational Database Question .....

[Kurt Wall]

On Tue, Dec 28, 2004 at 11:55:57AM -0600, Ben Duncan took 46 lines to write:
> On my SLAG project (The OSS AppGen replacement based in S-Lang I am 
> writing),
> in order to emulate on of the aspects of Appgen, which is:
> 
> When in a screen and you are on the "record key" prompt, which is usually 
> prompt
> number 1, after entering the data, the runtime does a read to the primary 
> file.
> If it gets a hit, it automagically puts you in "Change" mode and populates 
> the
> data portion of that screen, if it does not get a hit, the runtime then 
> asks if
> you wish to "add" the record as new (using the just entered key value).
> 
> I just figured to do a "READ" using the key to do the same for SLAG.
> 
> Suggestions, criticism, alternate solutions?

SQL is the standard language for data manipulation. It should be easy
enough to create a SQL statement that implements "READ" and "CHANGE".
I wouldn't want to reinvent this particular wheel, though.

> FWIW: IANASE (I am not a SQL expert)

Nor am I, I just use it a lot.

Kurt
-- 
If God had meant for us to be naked, we would have been born that way.