SSDN - Delete rows in a MS SQL Server database table ?

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

stig persson

Subject: 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

(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

stig persson

Subject: 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

(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

stig persson

Subject: 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.

Tony Lavinio

Subject: 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.

stig persson

Subject: 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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.