XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
stig perssonSubject: Delete rows in a MS SQL Server database table ?
Author: stig persson
Date: 11 Sep 2007 05:44 AM
Originally Posted: 11 Sep 2007 05:45 AM
Is it possible to delete rows in a MS SQL Server database table using
Stylus Studio ?

Regards
//Stig

Postnext
Alberto MassariSubject: Delete rows in a MS SQL Server database table ?
Author: Alberto Massari
Date: 12 Sep 2007 04:01 AM
Hi Stig,
in order to manipulate a database with Stylus Studio you need to create an XQuery document, set the processor to be DataDirect XQuery, and then use the ddtek:sql-delete function.

Hope this helps,
Alberto

Postnext
stig perssonSubject: Delete rows in a MS SQL Server database table ?
Author: stig persson
Date: 12 Sep 2007 04:16 AM
Hi Alberto!

Thank's for the answer!
Do you have a simple code-example for me to look at ?

Regards
//Stig

Postnext
Alberto MassariSubject: Delete rows in a MS SQL Server database table ?
Author: Alberto Massari
Date: 12 Sep 2007 04:27 AM
Hi Stig,
you invoke the ddtek:sql-delete function on the XML node you fetched from the database table; for instance, if you want to delete all the rows from the "holdings" table having the "userid" column equal to "Stig" you write:

ddtek:sql-delete(collection("holdings")/holdings[userid = "Stig"])

Hope this helps,
Alberto

Postnext
stig perssonSubject: Delete rows in a MS SQL Server database table ?
Author: stig persson
Date: 17 Sep 2007 08:30 AM
Hi Alberto!

Thank's for your quick response!

We still have problems, for example with
the declaration of the external function (ddtek:sql-delete) !

Following is the XQuery code :

declare function ddtek:sql-delete($row as element()*) external;

ddtek:sql-delete(collection("pubs.dbo.StylusTest")/StylusTest[FNAMN = "Stig"])

We receive the following error :

[DataDirect][XQuery]Error at line 2, column 18. The namespace uri of external function declarations must start with "ddtekjava:".

Do you have a complete example for an XQuery ?

We are running Stylus Studio 2006 Enterprise Edition.

Postnext
Tony LavinioSubject: Delete rows in a MS SQL Server database table ?
Author: Tony Lavinio
Date: 17 Sep 2007 09:21 AM
Ah. Delete wasn't available at that point.
You need Stylus Studio 2007 Release 2.

Posttop
stig perssonSubject: Delete rows in a MS SQL Server database table ?
Author: stig persson
Date: 17 Sep 2007 09:28 AM
Thank's that explains it !
We have to get 2007 !!

Regards
//Stig

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.