Re: XSD to Pascal Objects?

From: Bryce K. Nielsen (bryce_at_sysonyx.com)
Date: 04/20/04 

Date: Mon, 19 Apr 2004 23:46:46 -0600

> There is similar stuff for C# and C++ (XMLSpy) but nothing for
> Delphi; I wonder if it is for the lack of demand or oversight
> of a market. Hint hint for 3rd party app makers :-)
>

Would be nice, but my gut reaction (without any research) is there's not
enough market to justify such a product. Seeings how it'd be pretty much
only for Delphi users, and Delphi users of XML at that, we're talking about
a very niche, specific market. And the tool would be too simple to justify a
high price or else no one would buy it. No, it'd probably have to be pretty
low-priced (my guess no more than one hundred dollars).

IMHO, it's something that would only happen if the tool had been developed
in-house and then someone thought "let's take this to market". The only
other possibility would be a feature tacked onto some other tool, kinda like
what XMLSpy does.

> If it is a tree-like structure, in order to get to a branch you
> are interested, you have to:
>
> i) create as many tables as there are node types;
> ii) set up fields etc for master-detail relationships;
> ii) hope that you have some patience left to do filtering and
> ranging and what not;
>
> IMHO, this is too much chuff for what it attempts to solve, wouldn't
> you agree.
>
> Or, am I missing a whole lotta simpler way?
>

I actually do this quite often in ADO. A recordset field can be another,
nested recordset. So you can potentially nest as much of a hierarchy as you
want. Then, when you save the top-level recordset as an XML file, it saves
all the child recordsets too. In effect, with little VCL configuration, I've
got my read/write hierarchical data structure. The XML itself isn't very
clean (I hate looking at raw ADO XML), but I never need to mess with the
XML, rather just save/load it and the Data-Aware controls take care of the
rest.

Bryce K. Nielsen
SysOnyx, Inc. (www.sysonyx.com)
Makers of xmlLinguist, the EDI-to-XML Translator
http://www.xmllinguist.com

Relevant Pages

  • Recordset load XML
    ... I'm writing a web service in .NET to work with Delphi clients. ... Recordset return so I save the RecordSet to an XML string: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to Programmatically Export as XML & SXL
    ... Unfortunately, I've had precious little to do with XML in Access, so I'm ... you use the ADO Recordset object's Save ... >>Dim rs As ADODB.Recordset ... >>Dim strADTGFile As String ...
    (microsoft.public.access.externaldata)
  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Database + dll
    ... You can include an XML or ADTG persisted Recordset with the ... XML can be compiled into a DLL as a resource, ... copied to a stream first anyway (not that the recordset would alter the ... It's a simple matter of creating a custom resource type from an XML file at ...
    (microsoft.public.vb.database.ado)
  • Re: need similar solution to "cascading combos"...
    ... That's not quite the same as setting it to a recordset, but the values are, ... I learned from Delphi programming that if I sniff around, ... > I'm creating a search form w/ unbound combo boxes ... Also "Filter" is a very specific term in Access, ...
    (microsoft.public.access.forms)