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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Maximum recursion depth exceed... (3)
-> + How do I develop the server si... (2)
-> + XSD Reuse (2)
-> + what happened to my preview re... (3)
-> + How do I use the Custom XML Co... (4)
-> + WYSIWYG missing in release 2 o... (2)
-> + space between elements (3)
-> + Oracle XML Gateway output CONV... (6)
-> + Someone please help me install... (5)
-> + XML Schema (XSD) to COBOL Data... (2)
-> + Can't compile Java (9)
-> + Trouble using the UDDI Browser (5)
-> + JVM Problem when installing Ar... (2)
-> + Stylus Studio Enterprise 8r2 d... (2)
-> - xml report headers (1)
-> + ddtek:sql-delete and ddtek:sql... (4)
-> + Validation blocked (4)
-> + List from XMl to be displayed ... (2)
-> + reports - changing data source (5)
-> + Disable HTML tags in Sense:X (8)
-> + .NETCompiledTransform Paramete... (3)
-> + Why Is The Saxon Processor So ... (13)
-> + Still can not get "integrated ... (15)
-> + quick xml gen from xsd (2)
-> - new to sylus, issue with if va... (1)
-> + Question about using Data Dire... (5)
-> + Why is the DB to XML Data Sour... (2)
-> + Relational db => XML pipeline (2)
-> + connection to oracle 10g (8)
-> + xsl:function misdemeanor (3)
-> + Records Extraction from XML (2)
-> + line break variable destroyed (2)
-> + Restricting on an extended typ... (5)
-> + folding all xml elements at on... (2)
-> + help converting a text file to... (5)
-> + Java Functions (5)
-> + XML Schema - extend then restr... (6)
-> + Converting SGML to XML in pipe... (2)
-> + Unattended install? (3)
-> + what are the differences betwe... (2)
-> + cannot install (2)
-> + Missing Parameters within Web ... (3)
-> + XSLT processors not creating o... (8)
-> - How to format a seperate colum... (1)
-> + Finnish language characters (3)
-> + x12 schemas (10)
-> + Howto search multiple XML file... (3)
-> + Chameleon Schema? (2)
-> + Problems generating pdf (9)
-> + Cannot install Stylus Studio R... (19)
-> + source xml of a report (3)
-> + File I/O Error when encounter ... (3)
-> + substitution groups in xslt ma... (4)
-> - Delete rows in a MS SQL Server... (7)
-> ->Delete rows in a MS SQL S...
-> ->Delete rows in a MS SQL S...
-> ->Delete rows in a MS SQL S...
-> ->Delete rows in a MS SQL S...
-> ->Delete rows in a MS SQL S...
-> ->Delete rows in a MS SQL S...
-> - Attaching DB2 Database in File... (1)
-> + Can't debug xsl examples with ... (14)
-> + Best way to transform existing... (2)
-> + Exception in generated java co... (3)
-> + Java API for converting EDI X1... (2)
-> + XPath Query Editor slow perfor... (7)
-> + mapper schema problem (5)
-> + cursor issue in stylus studio ... (2)
-> + how to generate xslt code for ... (4)
-> + Web Service (12)
-> + Additional rule (2)
-> + Help needed: XMLSchema and unp... (9)
-> + Module settings for external X... (3)
-> + Finding Errors in the XML File (6)
-> + CSV 2 XML (2)
-> + Automatic Namespace when using... (2)
-> + Can't find 'Associate XML Sche... (3)
-> + Calling Stylus Studio API from... (2)
-> + EDI TO XML using the Stylus St... (4)
-> + MarkLogic Integration (4)
-> + (null)0:0 (3)
-> + Recent Windows Patch for MSXML... (3)
-> + Show XML from Schema (2)
-> + xml publisher - report to xslt... (4)
-> + EDI TO XML using the Stylus St... (3)
-> + Unable to Generate XML file fr... (6)
-> + DB to XML in Enterprise Suite (2)
-> + pdf to xml (2)
-> - Open External Schema - button ... (1)
-> - Unable to Generate XML from xC... (1)
-> + Unable to Generate XML from xC... (2)
-> + pre-proc processing in xml (2)
-> + FATAL ERROR: Expected comment ... (2)
-> + How to split window (3)
-> + XML Transformation Architectur... (2)
-> + only one record get run in an ... (2)
-> + xbrl schema file (2)
-> + Compare of 2 xml files (2)
-> + config control (4)
-> + create copy link in mapper (5)
-> + SGML DTD (3)
-> + command line access to your xs... (4)
-> + XML Schema: Attribute Choice (2)
-> + Upload file w/ topic (6)
-> - Can't View Properties (1)
-> + Can't View Properties (5)
-- Previous [1381-1400] [1401-1420] [1421-1440] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ 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.