Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Build datawindow from XML?

8 posts in XML Last posting was on 2003-06-08 12:15:41.0Z
Ken Balakrishnan Posted on 2003-05-30 19:26:07.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Ken Balakrishnan" <kNeOnSPAM@cps92.com>
Subject: Build datawindow from XML?
Date: Fri, 30 May 2003 15:26:07 -0400
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 204.60.85.209
Message-ID: <373_eEkoDJuJDHA.187@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:74
Article PK: 813152

Sorry if this question has been asked and answered before...

Is there any way in PB to build an external datawindow from an XML template
or actual XML, analogous to building one from a SQL or stored procedure
source (minus the update information, of course)? If not, has anyone
already written a function or tool to do this and made it public? At the
moment we're planning to build one ourselves, but I thought I'd better check
to make sure we're not reinventing the wheel.

Thanks,
Ken


Jim O'Neil [Sybase] Posted on 2003-05-30 19:53:19.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: joneil@sybase.com (Jim O'Neil [Sybase])
Subject: Re: Build datawindow from XML?
Date: Fri, 30 May 2003 19:53:19 GMT
Organization: Sybase Technical Support
Reply-To: joneil_REMOVETHISPART@sybase.com
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: joneilpc.sybase.com 10.18.61.121
Lines: 20
Message-ID: <373_3ed7b695.24031455@forums.sybase.com>
References: <373_eEkoDJuJDHA.187@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:75
Article PK: 813149

You might want to check out PowerBuilder 9 which can import and export
XML from/to a datawindow.

On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"

<kNeOnSPAM@cps92.com> wrote:

>Sorry if this question has been asked and answered before...
>
>Is there any way in PB to build an external datawindow from an XML template
>or actual XML, analogous to building one from a SQL or stored procedure
>source (minus the update information, of course)? If not, has anyone
>already written a function or tool to do this and made it public? At the
>moment we're planning to build one ourselves, but I thought I'd better check
>to make sure we're not reinventing the wheel.
>
>Thanks,
>Ken
>
>

Jim O'Neil
Principal Technical Support Engineer
Sybase, Inc.
Concord, MA


Ken Balakrishnan Posted on 2003-05-30 20:15:52.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Ken Balakrishnan" <kNeOnSPAM@cps92.com>
Subject: Re: Build datawindow from XML?
Date: Fri, 30 May 2003 16:15:52 -0400
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 204.60.85.209
Message-ID: <373_uuBwIjuJDHA.221@forums-1-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:76
Article PK: 813151

Oops, I should've mentioned I'm using PB9. The XML import/export is great,
the issue I'm attacking is creating the datawindow in the first place. If I
have some sample XML with all 30 or 50 fields, I'd rather not have to re-key
every field in the "Enter Result Set Description" area of the DW wizard. I
guess what I'm looking for is SyntaxFromXML, analogous to
sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
utility to do this, I just wanted to see if anyone had already done it and
was willing to share, or if PB9 already had that built in and I just hadn't
come across it.

"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
news:3ed7b695.24031455@forums.sybase.com...
> You might want to check out PowerBuilder 9 which can import and export
> XML from/to a datawindow.
>
> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
> <kNeOnSPAM@cps92.com> wrote:
>
> >Sorry if this question has been asked and answered before...
> >
> >Is there any way in PB to build an external datawindow from an XML
template
> >or actual XML, analogous to building one from a SQL or stored procedure
> >source (minus the update information, of course)? If not, has anyone
> >already written a function or tool to do this and made it public? At the
> >moment we're planning to build one ourselves, but I thought I'd better
check
> >to make sure we're not reinventing the wheel.
> >
> >Thanks,
> >Ken
> >
> >
>
> Jim O'Neil
> Principal Technical Support Engineer
> Sybase, Inc.
> Concord, MA


Bruce Armstrong [TeamSybase] Posted on 2003-05-30 21:04:42.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Organization: TeamSybase[130.76.64.15]
X-Newsreader: AspNNTP 1.50 (Tri Hoang)
Subject: Re: Build datawindow from XML?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 30 May 2003 14:04:42 -0700
NNTP-Posting-Host: transinc-win02.netoptex.com 206.169.167.22
Lines: 70
Message-ID: <373_uTyUY8uJDHA.221@forums-1-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com> <373_uuBwIjuJDHA.221@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:78
Article PK: 813147

Sounds like a good enhancement request. I'd suggest posting it over in the
future_discussions area to start some buzz, and submitting it to Sybase through
CaseXpress as an enhancement request.

There's no such function that I'm aware of, but I imagine it could be written
fairly easily. The hard part would be tieing it to a table. When all you have
is XML, it's like creating a DataWindow from any other pure data format (CSV).
You might create an external datawindow that could hold the data, but there's
nothing in the XML itself that would tell you what database table to associate
it with.

On Fri, 30 May 2003 16:15:52 -0400,
in powersoft.public.powerbuilder.xml

Ken Balakrishnan <kNeOnSPAM@cps92.com> wrote:
>Oops, I should've mentioned I'm using PB9. The XML import/export is great,
>the issue I'm attacking is creating the datawindow in the first place. If I
>have some sample XML with all 30 or 50 fields, I'd rather not have to re-key
>every field in the "Enter Result Set Description" area of the DW wizard. I
>guess what I'm looking for is SyntaxFromXML, analogous to
>sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
>utility to do this, I just wanted to see if anyone had already done it and
>was willing to share, or if PB9 already had that built in and I just hadn't
>come across it.
>
>
>"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
>news:3ed7b695.24031455@forums.sybase.com...
>> You might want to check out PowerBuilder 9 which can import and export
>> XML from/to a datawindow.
>>
>> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
>> <kNeOnSPAM@cps92.com> wrote:
>>
>> >Sorry if this question has been asked and answered before...
>> >
>> >Is there any way in PB to build an external datawindow from an XML
>template
>> >or actual XML, analogous to building one from a SQL or stored procedure
>> >source (minus the update information, of course)? If not, has anyone
>> >already written a function or tool to do this and made it public? At the
>> >moment we're planning to build one ourselves, but I thought I'd better
>check
>> >to make sure we're not reinventing the wheel.
>> >
>> >Thanks,
>> >Ken
>> >
>> >
>>
>> Jim O'Neil
>> Principal Technical Support Engineer
>> Sybase, Inc.
>> Concord, MA
>
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Not 1 - but 2 new books on developing with PowerBuilder
http://www.pb9books.com

Hurrah! Google Groups works again! But remember its only good for searching,
don't post through it.
http://groups.google.com/advanced_group_search?hl=en&as_ugroup=powersoft.public.
powerbuilder.*

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org


Ken Balakrishnan Posted on 2003-05-30 21:21:14.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Ken Balakrishnan" <kNeOnSPAM@cps92.com>
Subject: Re: Build datawindow from XML?
Date: Fri, 30 May 2003 17:21:14 -0400
Lines: 108
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 204.60.85.209
Message-ID: <373_eBkKqHvJDHA.221@forums-1-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com> <373_uuBwIjuJDHA.221@forums-1-dub> <373_uTyUY8uJDHA.221@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:79
Article PK: 813153

Well, for our case, we don't need to tie it to a table -- we're exploring
the idea of replacing all the db calls in our client app with web service
calls, so the front end would just shoot the xml back to the webservice and
let that deal with which fields go to which tables. Ideally, we'd like to
work with XML as if it were another kind of datasource, rather than just an
import/export format. For example, I'd love it if I could issue a
dw.updatetoXML() command and have PB give me xml that contains only the
columns that have been changed, just like it does with SQL. For now, we'll
have to roll our own -- again, not especially difficult to write, but it
would be nice to have built-in.

I'll take your advice and send this to the proper channels.

Thanks,
Ken

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>

wrote in message news:uTyUY8uJDHA.221@forums-1-dub...
> Sounds like a good enhancement request. I'd suggest posting it over in
the
> future_discussions area to start some buzz, and submitting it to Sybase
through
> CaseXpress as an enhancement request.
>
> There's no such function that I'm aware of, but I imagine it could be
written
> fairly easily. The hard part would be tieing it to a table. When all you
have
> is XML, it's like creating a DataWindow from any other pure data format
(CSV).
> You might create an external datawindow that could hold the data, but
there's
> nothing in the XML itself that would tell you what database table to
associate
> it with.
>
> On Fri, 30 May 2003 16:15:52 -0400,
> in powersoft.public.powerbuilder.xml
> Ken Balakrishnan <kNeOnSPAM@cps92.com> wrote:
> >Oops, I should've mentioned I'm using PB9. The XML import/export is
great,
> >the issue I'm attacking is creating the datawindow in the first place. If
I
> >have some sample XML with all 30 or 50 fields, I'd rather not have to
re-key
> >every field in the "Enter Result Set Description" area of the DW wizard.
I
> >guess what I'm looking for is SyntaxFromXML, analogous to
> >sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
> >utility to do this, I just wanted to see if anyone had already done it
and
> >was willing to share, or if PB9 already had that built in and I just
hadn't
> >come across it.
> >
> >
> >"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
> >news:3ed7b695.24031455@forums.sybase.com...
> >> You might want to check out PowerBuilder 9 which can import and export
> >> XML from/to a datawindow.
> >>
> >> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
> >> <kNeOnSPAM@cps92.com> wrote:
> >>
> >> >Sorry if this question has been asked and answered before...
> >> >
> >> >Is there any way in PB to build an external datawindow from an XML
> >template
> >> >or actual XML, analogous to building one from a SQL or stored
procedure
> >> >source (minus the update information, of course)? If not, has anyone
> >> >already written a function or tool to do this and made it public? At
the
> >> >moment we're planning to build one ourselves, but I thought I'd better
> >check
> >> >to make sure we're not reinventing the wheel.
> >> >
> >> >Thanks,
> >> >Ken
> >> >
> >> >
> >>
> >> Jim O'Neil
> >> Principal Technical Support Engineer
> >> Sybase, Inc.
> >> Concord, MA
> >
> >
>
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
>
> Not 1 - but 2 new books on developing with PowerBuilder
> http://www.pb9books.com
>
> Hurrah! Google Groups works again! But remember its only good for
searching,
> don't post through it.
>

http://groups.google.com/advanced_group_search?hl=en&as_ugroup=powersoft.pub
lic.
> powerbuilder.*
>
> Preach the gospel at all times. If necessary, use words. - Francis of
Assisi
> http://www.needhim.org


Paul Horan[TeamSybase] Posted on 2003-06-02 16:33:22.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
Subject: Re: Build datawindow from XML?
Date: Mon, 2 Jun 2003 12:33:22 -0400
Lines: 127
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ny-chicagost2d-148.buf.adelphia.net 24.49.119.148
Message-ID: <373_uf94lWSKDHA.275@forums-2-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com> <373_uuBwIjuJDHA.221@forums-1-dub> <373_uTyUY8uJDHA.221@forums-1-dub> <373_eBkKqHvJDHA.221@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:87
Article PK: 813159

FYI: I'm not current with the details, but I *think* the Cynergy EAF framework for EAServer is already doing "something"
like this... They wanted to find a replacement for the blob used in getFullState()/setFullState() calls, and found a
way to simulate that functionality with an XML stream between client and EAServer components.

Carson?

www.cynergysystems.com

--
Paul Horan[TeamSybase]
VCI Springfield, MA
www.vcisolutions.com

Get the two new PB9 Books!
http://www.pb9books.com?source=newsgroups

"Ken Balakrishnan" <kNeOnSPAM@cps92.com> wrote in message news:eBkKqHvJDHA.221@forums-1-dub...
> Well, for our case, we don't need to tie it to a table -- we're exploring
> the idea of replacing all the db calls in our client app with web service
> calls, so the front end would just shoot the xml back to the webservice and
> let that deal with which fields go to which tables. Ideally, we'd like to
> work with XML as if it were another kind of datasource, rather than just an
> import/export format. For example, I'd love it if I could issue a
> dw.updatetoXML() command and have PB give me xml that contains only the
> columns that have been changed, just like it does with SQL. For now, we'll
> have to roll our own -- again, not especially difficult to write, but it
> would be nice to have built-in.
>
> I'll take your advice and send this to the proper channels.
>
> Thanks,
> Ken
>
> "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
> wrote in message news:uTyUY8uJDHA.221@forums-1-dub...
> > Sounds like a good enhancement request. I'd suggest posting it over in
> the
> > future_discussions area to start some buzz, and submitting it to Sybase
> through
> > CaseXpress as an enhancement request.
> >
> > There's no such function that I'm aware of, but I imagine it could be
> written
> > fairly easily. The hard part would be tieing it to a table. When all you
> have
> > is XML, it's like creating a DataWindow from any other pure data format
> (CSV).
> > You might create an external datawindow that could hold the data, but
> there's
> > nothing in the XML itself that would tell you what database table to
> associate
> > it with.
> >
> > On Fri, 30 May 2003 16:15:52 -0400,
> > in powersoft.public.powerbuilder.xml
> > Ken Balakrishnan <kNeOnSPAM@cps92.com> wrote:
> > >Oops, I should've mentioned I'm using PB9. The XML import/export is
> great,
> > >the issue I'm attacking is creating the datawindow in the first place. If
> I
> > >have some sample XML with all 30 or 50 fields, I'd rather not have to
> re-key
> > >every field in the "Enter Result Set Description" area of the DW wizard.
> I
> > >guess what I'm looking for is SyntaxFromXML, analogous to
> > >sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
> > >utility to do this, I just wanted to see if anyone had already done it
> and
> > >was willing to share, or if PB9 already had that built in and I just
> hadn't
> > >come across it.
> > >
> > >
> > >"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
> > >news:3ed7b695.24031455@forums.sybase.com...
> > >> You might want to check out PowerBuilder 9 which can import and export
> > >> XML from/to a datawindow.
> > >>
> > >> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
> > >> <kNeOnSPAM@cps92.com> wrote:
> > >>
> > >> >Sorry if this question has been asked and answered before...
> > >> >
> > >> >Is there any way in PB to build an external datawindow from an XML
> > >template
> > >> >or actual XML, analogous to building one from a SQL or stored
> procedure
> > >> >source (minus the update information, of course)? If not, has anyone
> > >> >already written a function or tool to do this and made it public? At
> the
> > >> >moment we're planning to build one ourselves, but I thought I'd better
> > >check
> > >> >to make sure we're not reinventing the wheel.
> > >> >
> > >> >Thanks,
> > >> >Ken
> > >> >
> > >> >
> > >>
> > >> Jim O'Neil
> > >> Principal Technical Support Engineer
> > >> Sybase, Inc.
> > >> Concord, MA
> > >
> > >
> >
> > Bruce Armstrong [TeamSybase]
> > http://www.teamsybase.com
> >
> > Not 1 - but 2 new books on developing with PowerBuilder
> > http://www.pb9books.com
> >
> > Hurrah! Google Groups works again! But remember its only good for
> searching,
> > don't post through it.
> >
> http://groups.google.com/advanced_group_search?hl=en&as_ugroup=powersoft.pub
> lic.
> > powerbuilder.*
> >
> > Preach the gospel at all times. If necessary, use words. - Francis of
> Assisi
> > http://www.needhim.org
>
>


T. Carson Hager [Team Sybase] Posted on 2003-06-02 16:47:24.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "T. Carson Hager [Team Sybase]" <carson.hager@cynergysystems.com>
Subject: Re: Build datawindow from XML?
Date: Mon, 2 Jun 2003 12:47:24 -0400
Lines: 168
Organization: Cynergy Systems, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: CECARTER.dhcp.loc.gov 140.147.144.83
Message-ID: <373_#1kUmcSKDHA.220@forums-1-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com> <373_uuBwIjuJDHA.221@forums-1-dub> <373_uTyUY8uJDHA.221@forums-1-dub> <373_eBkKqHvJDHA.221@forums-1-dub> <373_uf94lWSKDHA.275@forums-2-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:88
Article PK: 813163

EAF 3.0 has this built in. It's one of our ContentProviders. We have
content providers for XML, ResutSets and native DW Synch for updates as well
as Excel, PDF, Text, etc. for pure retrieve. We built the XML provider for
8.0 originally with our own homegrown native XML parser but it was just too
slow given string manipulation in powerscript. It's being replaced as an
extension for PB9 only using PBDOM. Given this change, the extension will
likely be released about a month after 3.0's release this coming Wednesday.


Carson

"Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom> wrote in message
news:uf94lWSKDHA.275@forums-2-dub...
> FYI: I'm not current with the details, but I *think* the Cynergy EAF
framework for EAServer is already doing "something"
> like this... They wanted to find a replacement for the blob used in
getFullState()/setFullState() calls, and found a
> way to simulate that functionality with an XML stream between client and
EAServer components.
>
> Carson?
>
> www.cynergysystems.com
>
> --
> Paul Horan[TeamSybase]
> VCI Springfield, MA
> www.vcisolutions.com
>
> Get the two new PB9 Books!
> http://www.pb9books.com?source=newsgroups
>
> "Ken Balakrishnan" <kNeOnSPAM@cps92.com> wrote in message
news:eBkKqHvJDHA.221@forums-1-dub...
> > Well, for our case, we don't need to tie it to a table -- we're
exploring
> > the idea of replacing all the db calls in our client app with web
service
> > calls, so the front end would just shoot the xml back to the webservice
and
> > let that deal with which fields go to which tables. Ideally, we'd like
to
> > work with XML as if it were another kind of datasource, rather than just
an
> > import/export format. For example, I'd love it if I could issue a
> > dw.updatetoXML() command and have PB give me xml that contains only the
> > columns that have been changed, just like it does with SQL. For now,
we'll
> > have to roll our own -- again, not especially difficult to write, but it
> > would be nice to have built-in.
> >
> > I'll take your advice and send this to the proper channels.
> >
> > Thanks,
> > Ken
> >
> > "Bruce Armstrong [TeamSybase]"
<NOCANSPAM_bruce.armstrong@teamsybase.com>
> > wrote in message news:uTyUY8uJDHA.221@forums-1-dub...
> > > Sounds like a good enhancement request. I'd suggest posting it over
in
> > the
> > > future_discussions area to start some buzz, and submitting it to
Sybase
> > through
> > > CaseXpress as an enhancement request.
> > >
> > > There's no such function that I'm aware of, but I imagine it could be
> > written
> > > fairly easily. The hard part would be tieing it to a table. When all
you
> > have
> > > is XML, it's like creating a DataWindow from any other pure data
format
> > (CSV).
> > > You might create an external datawindow that could hold the data, but
> > there's
> > > nothing in the XML itself that would tell you what database table to
> > associate
> > > it with.
> > >
> > > On Fri, 30 May 2003 16:15:52 -0400,
> > > in powersoft.public.powerbuilder.xml
> > > Ken Balakrishnan <kNeOnSPAM@cps92.com> wrote:
> > > >Oops, I should've mentioned I'm using PB9. The XML import/export is
> > great,
> > > >the issue I'm attacking is creating the datawindow in the first
place. If
> > I
> > > >have some sample XML with all 30 or 50 fields, I'd rather not have to
> > re-key
> > > >every field in the "Enter Result Set Description" area of the DW
wizard.
> > I
> > > >guess what I'm looking for is SyntaxFromXML, analogous to
> > > >sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
> > > >utility to do this, I just wanted to see if anyone had already done
it
> > and
> > > >was willing to share, or if PB9 already had that built in and I just
> > hadn't
> > > >come across it.
> > > >
> > > >
> > > >"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
> > > >news:3ed7b695.24031455@forums.sybase.com...
> > > >> You might want to check out PowerBuilder 9 which can import and
export
> > > >> XML from/to a datawindow.
> > > >>
> > > >> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
> > > >> <kNeOnSPAM@cps92.com> wrote:
> > > >>
> > > >> >Sorry if this question has been asked and answered before...
> > > >> >
> > > >> >Is there any way in PB to build an external datawindow from an XML
> > > >template
> > > >> >or actual XML, analogous to building one from a SQL or stored
> > procedure
> > > >> >source (minus the update information, of course)? If not, has
anyone
> > > >> >already written a function or tool to do this and made it public?
At
> > the
> > > >> >moment we're planning to build one ourselves, but I thought I'd
better
> > > >check
> > > >> >to make sure we're not reinventing the wheel.
> > > >> >
> > > >> >Thanks,
> > > >> >Ken
> > > >> >
> > > >> >
> > > >>
> > > >> Jim O'Neil
> > > >> Principal Technical Support Engineer
> > > >> Sybase, Inc.
> > > >> Concord, MA
> > > >
> > > >
> > >
> > > Bruce Armstrong [TeamSybase]
> > > http://www.teamsybase.com
> > >
> > > Not 1 - but 2 new books on developing with PowerBuilder
> > > http://www.pb9books.com
> > >
> > > Hurrah! Google Groups works again! But remember its only good for
> > searching,
> > > don't post through it.
> > >
> >
http://groups.google.com/advanced_group_search?hl=en&as_ugroup=powersoft.pub
> > lic.
> > > powerbuilder.*
> > >
> > > Preach the gospel at all times. If necessary, use words. - Francis of
> > Assisi
> > > http://www.needhim.org
> >
> >
>
>


Vikas J Posted on 2003-06-08 12:15:41.0Z
Newsgroups: sybase.public.powerbuilder.xml
From: "Vikas J" <vanjacobson@hotmail.com>
Subject: Re: Build datawindow from XML?
Date: Sun, 8 Jun 2003 17:45:41 +0530
Lines: 130
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: dialup-del-203.94.241.74.bol.net.in 203.94.241.74
Message-ID: <373_OjSZ7ibLDHA.275@forums-2-dub>
References: <373_eEkoDJuJDHA.187@forums-2-dub> <373_3ed7b695.24031455@forums.sybase.com> <373_uuBwIjuJDHA.221@forums-1-dub> <373_uTyUY8uJDHA.221@forums-1-dub> <373_eBkKqHvJDHA.221@forums-1-dub>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.xml:102
Article PK: 813176

yah !
Ken
nice thought ...
My vote...

Regards
Vikas J

"Ken Balakrishnan" <kNeOnSPAM@cps92.com> wrote in message
news:eBkKqHvJDHA.221@forums-1-dub...
> Well, for our case, we don't need to tie it to a table -- we're exploring
> the idea of replacing all the db calls in our client app with web service
> calls, so the front end would just shoot the xml back to the webservice
and
> let that deal with which fields go to which tables. Ideally, we'd like to
> work with XML as if it were another kind of datasource, rather than just
an
> import/export format. For example, I'd love it if I could issue a
> dw.updatetoXML() command and have PB give me xml that contains only the
> columns that have been changed, just like it does with SQL. For now,
we'll
> have to roll our own -- again, not especially difficult to write, but it
> would be nice to have built-in.
>
> I'll take your advice and send this to the proper channels.
>
> Thanks,
> Ken
>
> "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
> wrote in message news:uTyUY8uJDHA.221@forums-1-dub...
> > Sounds like a good enhancement request. I'd suggest posting it over in
> the
> > future_discussions area to start some buzz, and submitting it to Sybase
> through
> > CaseXpress as an enhancement request.
> >
> > There's no such function that I'm aware of, but I imagine it could be
> written
> > fairly easily. The hard part would be tieing it to a table. When all
you
> have
> > is XML, it's like creating a DataWindow from any other pure data format
> (CSV).
> > You might create an external datawindow that could hold the data, but
> there's
> > nothing in the XML itself that would tell you what database table to
> associate
> > it with.
> >
> > On Fri, 30 May 2003 16:15:52 -0400,
> > in powersoft.public.powerbuilder.xml
> > Ken Balakrishnan <kNeOnSPAM@cps92.com> wrote:
> > >Oops, I should've mentioned I'm using PB9. The XML import/export is
> great,
> > >the issue I'm attacking is creating the datawindow in the first place.
If
> I
> > >have some sample XML with all 30 or 50 fields, I'd rather not have to
> re-key
> > >every field in the "Enter Result Set Description" area of the DW
wizard.
> I
> > >guess what I'm looking for is SyntaxFromXML, analogous to
> > >sqlca.SyntaxFromSQL. It seems like a straightforward task to write a
> > >utility to do this, I just wanted to see if anyone had already done it
> and
> > >was willing to share, or if PB9 already had that built in and I just
> hadn't
> > >come across it.
> > >
> > >
> > >"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
> > >news:3ed7b695.24031455@forums.sybase.com...
> > >> You might want to check out PowerBuilder 9 which can import and
export
> > >> XML from/to a datawindow.
> > >>
> > >> On Fri, 30 May 2003 15:26:07 -0400, "Ken Balakrishnan"
> > >> <kNeOnSPAM@cps92.com> wrote:
> > >>
> > >> >Sorry if this question has been asked and answered before...
> > >> >
> > >> >Is there any way in PB to build an external datawindow from an XML
> > >template
> > >> >or actual XML, analogous to building one from a SQL or stored
> procedure
> > >> >source (minus the update information, of course)? If not, has
anyone
> > >> >already written a function or tool to do this and made it public?
At
> the
> > >> >moment we're planning to build one ourselves, but I thought I'd
better
> > >check
> > >> >to make sure we're not reinventing the wheel.
> > >> >
> > >> >Thanks,
> > >> >Ken
> > >> >
> > >> >
> > >>
> > >> Jim O'Neil
> > >> Principal Technical Support Engineer
> > >> Sybase, Inc.
> > >> Concord, MA
> > >
> > >
> >
> > Bruce Armstrong [TeamSybase]
> > http://www.teamsybase.com
> >
> > Not 1 - but 2 new books on developing with PowerBuilder
> > http://www.pb9books.com
> >
> > Hurrah! Google Groups works again! But remember its only good for
> searching,
> > don't post through it.
> >
>
http://groups.google.com/advanced_group_search?hl=en&as_ugroup=powersoft.pub
> lic.
> > powerbuilder.*
> >
> > Preach the gospel at all times. If necessary, use words. - Francis of
> Assisi
> > http://www.needhim.org
>
>