Subject Re: [Firebird-Architect] Firebird and XML
Author Milan Babuskov
Simon Carter wrote:
>><Table Type="SQL">SELECT *
>>FROM WS_IPTOCOUNTRY
>>WHERE COUNTRY_CODE = 'US'
>> <Row>
>> ...etc.
>>
>>On screenshot it is not visible how did it end. My guess is:
>></Table>
>
> The type="SQL" bit just allows you to see what went into building the xml,
> if it's a table/view then it will tell you so.

I was actually concerned about mixing free form text (like sql statement) with
having a tag (like <Row>) on the same level. Wouldn't the following be more
appropriate or standard:

<Table>
<sql>SELECT * FROM ...etc.</sql>
<Row>
...etc.
</Row>
</Table>

?

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org