Subject | Re: [Firebird-Architect] Applications of Encoded Data Streams |
---|---|
Author | Helen Borrie |
Post date | 2005-05-03T11:58:37Z |
At 10:50 AM 2/05/2005 -0400, Jim Starkey wrote:
select a.blah,
(select b.a, b.b, b.c from tableb b
where b.id = a.id) as (aa, bb, cc),
a.p, a.q, a.r from tablea a
Helen
>The self-describing, platform independent data stream encoding schemesWould another natural use be in DSQL, for tuple subquery expressions?
>that we've been discussing have at least three interesting potential
>applications within future versions of Firebird.
>
>...
>The second application would be to support "getRecord" and "setRecord"
>methods in the higher layers of the new API. The basic idea is that an
>application could do a single getRecord all to get a complete row from a
>ResultSet that could later be used to "setRecord" to a prepared insert
>statement with the same field list. This mechanism is ideal for a
>future version on gbak or similar backup/restore utility. Another
>natural use is in replication.
select a.blah,
(select b.a, b.b, b.c from tableb b
where b.id = a.id) as (aa, bb, cc),
a.p, a.q, a.r from tablea a
Helen