🚀 go-pugleaf

On Mon, 15 Feb 1999 12:01:31 -0500, "Richard Muzerolle" <muzzy@muznet.net>
wrote:

[...]

>My first problem is that I can not edit the table created??

This is true. All multi-table join result sets will be read-only. It is up
to the application front-end to accommodate such read-only result sets and
provide a means for updating the data in the separate base tables.
Different front-end software packages handle this differently. Gary pointed
out how you might go about handling this in Visual dBASE. In C++Builder and
Delphi, it is handled different from that (using cached updates). And in
other software packages still differently.

>My second problem is that only one of the hyd_flow.FLOW_AVAIL shows up when
>I need all three in the three last lines to show??

Can you elaborate on exactly what you meant by the above? In your original
SQL statement, the column hyd_flow.FLOW_AVAIL appeared only one time. So I
do not understand what you meant by not showing three times.

Did you mean in three records the hyd_flow.FLOW_AVAIL column was blank
(when you expected a non-NULL value)? Could this be a result of the query's
OUTER JOIN and non-matching records?

//////////////////////////////////////////////////////////////////////////
Steve Koterski                       "For people who like peace and quiet:
Technical Publications               a phoneless cord."
INPRISE Corporation                                             -- Unknown
http://www.inprise.com/delphi