>I am getting an XML file from one of our clients. They are sending me an Author field. Some times there is more than one author in a book and it is sent in the format below
>
><fv_author id="1">Fred Besterwitch</fv_author>
><fv_author id="2">John SMITH</fv_author>
>
>XMLtoCursor function only reads the Last Author and ignores the first author field. IS this a Bug or a Feature :)))))
It's a
feature... In fact, there is no way you'll get two columns with the same name in the same row (that is, two
fv_author fields), unless, of course,
XMLtoCursor could be able to produce a bunch of related cursors. The solution is to build your own method of reading the XML document and place the info inside the proper table (in this case, table
s, since you have a one-to-many relation in hands).
----------------------------------
António Tavares Lopes