Subject Re: [Firebird-Architect] Applications of Encoded Data Streams
Author Helen Borrie
At 10:50 AM 2/05/2005 -0400, Jim Starkey wrote:
>The self-describing, platform independent data stream encoding schemes
>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.

Would another natural use be in DSQL, for tuple subquery expressions?

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