XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Delete rows in a MS SQL Server database table ?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Report reverts back to XHTML-C... (2)
-> + Certificate error (7)
-> + Opening DITA files and associa... (4)
-> + Cannot see links from source d... (10)
-> + SS 2007 vs. SS 2008 calling a ... (3)
-> + Unable to compile java file (8)
-> + Unable to use xsi:type attribu... (2)
-> + Unable to save xslt file after... (5)
-> + .NET XslTransform Compiled out... (3)
-> + Reporting Comparison (2)
-> + problems setting up the fonts ... (3)
-> + XML conversion (5)
-> + XQUERY: Application Crash (3)
-> + Base type definition does not ... (5)
-> + Tip says Generate C# Code actu... (2)
-> + install help (4)
-> + saxon-license (3)
-> + Mapping 1 xml file layout to a... (2)
-> + Problem - Schema Representatio... (3)
-> + selecting the correct Line Ter... (2)
-> + Stylus Studio crashing (14)
-> + EXSLT extensions in Stylusstud... (4)
-> + "Indent XML Tags" introduces u... (8)
-> + unable to use Stylus Studio of... (4)
-> + Replace in selection not worki... (4)
-> + Activation Key (3)
-> + Berkeley support removed! ? (2)
-> + Report editor slows to a virtu... (2)
-> + StylusStudio will not stop pro... (2)
-> + Indent tags resolves NCRs in a... (4)
-> + XML Report Table Problem (2)
-> + document() function throws unk... (7)
-> + Report indentation (2)
-> + Report editor automatic scroll... (2)
-> + java.lang.ClassNotFoundExcepti... (4)
-> + Strange output (6)
-> + Built-In Processor Handling CD... (5)
-> + Parameter values with multiple... (3)
-> + Schema review (2)
-> + seperating values within one e... (2)
-> + Filtering 1000's of XML files ... (2)
-> + replace fop0.20 by 094 (2)
-> + HTML tables from sorted XSL (3)
-> + From dicisionshema to XML (4)
-> + Convert data from SQL database... (2)
-> + Really Really need help - xsl:... (2)
-> + xslt: xsl:include not finding ... (2)
-> + One field in multiple lines (3)
-> + Stylis studio editor slow (2)
-> + Schema Documentation (3)
-> + Convert PCL to XML (7)
-> + crashing when connected via VP... (3)
-> + Repeater err:XPST0003 (3)
-> + rtf to XML (4)
-> + Questions Regarding Existing B... (3)
-> + Bug: Saved Changes Lost Switch... (3)
-> + Adding Simple Types to Attribu... (4)
-> + SQL Table to XML Convert error... (9)
-> + please help me with style shee... (2)
-> + WSDL Misbehaving (4)
-> + Regarding XSLT logic for a sim... (2)
-> + Regarding XSLT logic for a sim... (2)
-> + Integration with VB.Net (5)
-> + License for end user (5)
-> + Error when running xalan sampl... (3)
-> + generate the date time in xslt... (2)
-> + Error When Using XMLConverters... (5)
-> + Viewing the toolbox pane (3)
-> + In Sync (2)
-> + Java EE 5 SDK vs. Java 2 SDK S... (2)
-> - Odd behavior of Begin Field in... (1)
-> + I/O-error while saving style s... (2)
-> + WEB Service Session (2)
-> - XML Report - Horizontal Line (1)
-> + XML feed to a txt file (2)
-> + problem with xml output (2)
-> + XSL Debugging (2)
-> + XML schema validation issue (t... (2)
-> + Problem during saving styleshe... (4)
-> + Slow Redraw (11)
-> + Source XML code updates in map... (2)
-> + converting XML to Excel (2)
-> + Pre-Sales Questions? And Mergi... (2)
-> + How can I download an earlier ... (2)
-> + Create multiple string outputs... (2)
-> + Alternate page masters indepen... (3)
-> + Flat to XML and back with Styl... (2)
-> + BUG: Byte Order Mark inserted ... (2)
-> + Schema Validation using the to... (7)
-> + Flat Text file to XML or XSD (6)
-> + Second time it should not go i... (2)
-> + How to sum Nodes which are at ... (2)
-> + Where has the wysiwyg editor g... (2)
-> + SS says my trial has expired -... (2)
-> + XSD input; SQL Table Output Ne... (2)
-> + Building Schema from XML (2)
-> + conditions on tag values expre... (3)
-> + XML converter "omit fields whe... (3)
-> + Marklogic XQuery support in St... (2)
-> + XSL switching stylesheet from ... (10)
-- Previous [1321-1340] [1341-1360] [1361-1380] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
(Deleted User) Subject: Delete rows in a MS SQL Server database table ?
Author: (Deleted User)
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
(Deleted User) Subject: Delete rows in a MS SQL Server database table ?
Author: (Deleted User)
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
   
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.