Re: [gnome-db] Create Index SEQUENCE.

[Bas Driessen <bas driessen xobas com>]

On Tue, 2006-08-29 at 13:47 +0200, Vivien Malerba wrote:
> On 8/29/06, Bas Driessen <bas driessen xobas com> wrote:
> >
> >  Hi Vivien,
> >
> >  Can you please give me an example in what kind of format I have to put the
> > fields in case of SEQUENCE when creating an index? Is it a space separated
> > list? Comma separated? Something else?
> >
> >  >From your Table no 6:
> >
> >  /INDEX_FIELDS_S SEQUENCE Yes List of fields on which the index is applied
> > (min: 1 item)
>
> In that context a sequence is a collection of instances of some data
> grouped together. In the case of the "/INDEX_FIELDS_S" sequence, it
> contains at least one string parameter named "INDEX_FIELD" but
> depending on the provider, it can contain more like ordering, etc. So
> in this case the sequence can contain 1 or more groups of data
> composed of a string parameter and maybe other information.
>
> The path to access the "INDEX_FIELD" in the sequence is in the form:
> "/INDEX_FIELDS_S/<n>/INDEX_FIELD" where <n> is the nth group of data.
> To be more specific for example if your index is on 2 fields, you'd
> have
> "/INDEX_FIELDS_S/0/INDEX_FIELD" and "/INDEX_FIELDS_S/1/INDEX_FIELD"
> which you can put in your XML string to fill values in the
> GdaServerOperation.
>
> Tell me if this explanation is not clear enough...

Vivien, how would an CREATE INDEX xml object look like? I am having problems deciphering the table no 10. The structure below segfaults. Can you please advise?

<serv_op_data>
  <op_data path="/INDEX_DEF_P/INDEX_NAME">TestIdx</op_data>
  <op_data path="/INDEX_DEF_P/INDEX_ON_TABLE">Test1</op_data>
  <op_data path="/INDEX_FIELDS_S/0/INDEX_ON_TABLE">Id</op_data>
  <op_data path="/INDEX_FIELDS_S/1/INDEX_ON_TABLE">Desc</op_data>
</serv_op_data>

Some examples should be added to the doco, as an example explains more if you see the technology for the first time than just tables.

Thanks,
Bas.