SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
Sherlock

SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string

Post by Sherlock » 16 Mar 2004, 21:29

 Posted by:  Sherlock 

Hi Edgardo

Pardon, as mentioned the MSXML parser is very easy to use. I am writing
a general function(Just started_ to populate the result set from any Sql
Handle to a XML file.

I will post it in this forum or send you a private mail. But do you have
any limitations with the article by Martin Knopp in tea talk?. We found
it to be great.

Estimated man day--> 2 days (1 day code and 1 day test)

Gracias
Karthik


--

Freeware tool for SQLBASE with tons of features
Please visit http://www.iceteagroup.com/Products/SqlEngineer.htt

Eduardo Ahumada

SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string.

Post by Eduardo Ahumada » 17 Mar 2004, 05:05

 Posted by:  Eduardo Ahumada G. 

I know that the parser is very easy to use, but I want to dinamically
populate the XML from any query.

If you can generate a XML from "select * from budget" without use any visual
component that can be great !!!

I prefer to spend 1 hour, half to code SqlResultsetToXml(hSql, sXml) and
half to test

If you have a functión to dynamically determine the columns in the resultset
can be usefull. (¿sqldes?)

... 1 hour, not 2 days.

Sherlock

SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string.

Post by Sherlock » 17 Mar 2004, 06:41

 Posted by:  Sherlock 

Hi,

I think it it sqldsc and not sqldes . Here you go. ((Eduardo.apt) There is
an internal function called
FnSDescribeSql. Check that. It will call sqldsc. Its very simple. Prepare a
handle and send it to
FnSDescribeSql

Set sMyString= FnSDescribeSql(hSql)

sMyString will have the contents which look like the bitmap.

Making Martin Knopps function general rather than specific should not be
very difficult.

I have attached a bitmap showing how the result from sqldsc looks. I use it
for my freeware tool SqlEngineer.

If you use the XML parser to write such a function, post it to the
forum.sourcecode and give it to Thomas Lauzi.
It will be useful for all.

I have another function (my own parser) to generate XML from table window.
Its buggy. So i plan to write another one.
I will post it once i am done.

Gracias,
Karthik

Attachment: EDUARDO.apt
Attachment: sqlEngineer.JPG

Sherlock

SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string.

Post by Sherlock » 17 Mar 2004, 06:51

 Posted by:  Sherlock 

Or write your own parser and make the structure of the XML document simple

Like this-------------------------->




1
Larry Wall


2
Tim Bunce


3
Matt Sergeant


4
Robin Berjon


5
Ilya Sterin


Make a New Comment

Martin Knopp

SqlResultsetToXml(hSql, sXml) : Non visual function to persist a hSql Resultset to XML to string.

Post by Martin Knopp » 17 Mar 2004, 07:57

 Posted by:  Martin Knopp 

Just for the records:

There might be one limitation in the approach using MSXML and this is
performance for big XML documents.

First its going via COM IDispatch which is not high performance even after
the nice improvements that Gupta did achieve in COM client performance in
TD3.0.

Second DOM generally is not the best approach to build huge XML documents.

But until you reach a limitation in performance its definitely an easy
solution.

--
Martin Knopp, Dipl. Ing.

fecher GmbH
good people - good software

D'Orsay-Gasse 4/1
A-1090 Wien

Phone +43-1-3199124-0
Fax: +43-1-3199124-80
mailto:Martin.Knopp@fecher.at
http://www.fecher.at
------------------------------------------

Besuchen Sie fecher auf der CeBIT 2004 und informieren Sie sich über die
folgenden spannenden Themen:

-- SQLBASE und TEAM DEVELOPER unter LINUX (Halle 3 B25, Gupta )

-- ASP.NET Web Oberflächen mit Building Blocks XP und Team Developer (Halle
3 B25, Gupta)

-- BUILDING BLOCKS for JAVA: Effiziente Entwicklung offener,
plattformunabhängiger Geschäftsanwendungen (Halle 5 C38, Wilken)

-- ENSEMBLE: Die Integrationsplattform für Ihre Geschäftsprozesse,
Anwendungen und Daten. (Halle 3 D43, Intersystems)

-- CACHÉ: Die postrelationale, objektorientierte und hochperformante
Datenbank (Halle 3 D43, Intersystems)

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot] and 1 guest