Re: XmlQuery and GOB

[rodrigo linuxave net]

Gerhard Dieringer wrote:

> >>> Vivien Malerba <malerba gears linuxave net> 11.10.2000  10.59 Uhr >>>
> > >
> > > The API has four groups of methods:
> > > 1.) create from DOM-tree (DOM-tree is created by libxml from XML doc)
> > > 2.) create from text
> >
> >This one is to create elements with API calls. Tell me if I am wrong!
>
> No, you are right!
>
> > > 3.) render to XML (the reverse of the first)
> > > 4.) render to SQL
> > >
> >
> > The 4th one is a bit different since the rendering should be done by the
> > provider itself (otherwise you can't generate SQL-like which is specific to a
> > provider, or maybe is it generic SQL92 that you want to generate here?)
>
> Generating generic SQL92 could be the default, if a provider doesn't provide it's own diallect.
>

yes, we could use the current to_sql function which was added by Vivien for this.

> What about defining a gensym- or sequence-object with (at least) the two methods
> currval und nextval, that creates unique strings, for exapmle "id_0001", "id_0002", ....
> This can be used to define the id for the table (nextval) and the idrefs for the fields (currval).
>

I think also this would be better, so that we've got no repeated IDs, but we can put the same
table/view, etc in the same query twice.

cheers