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
Go to previous topicPrev TopicGo to next topicNext Topic
cheryl culwellSubject: need help in converting this access query to an xml query
Author: cheryl culwell
Date: 13 Oct 2010 03:17 PM
I am new to XML and have a deadline to meet, I know my learning XQL will not get me to the finish line in time...can I get help to convert this to an XML query?
thanks in advance

SELECT Wells.APICode AS FACId, Format([YearMonth],"mm/yyyy") AS FacREport, "0" AS FacAmend, "Well" AS FacType, Wells.UserField9 AS FacFormation, Wells.WellName AS FacName, Wells.Status AS FacGroup, "None" AS FacComment, "" AS Production, "OIL" AS ProdType, Round(([AllocBegInventory]),0) AS [Prod Begin Inventory], Round(([AllocEndInventory]),0) AS [Prod End Inventory], "bbls" AS ProdUnits, Round(([AllocOil]),0) AS [Prod Quantity], Well_Summary.DaysOn AS [Prod Days Producing], "" AS Disposition, "SOLD" AS DispType, Round([AllocOilSold],0) AS [Disp Quantity], "" AS EDisposition, "" AS Disposition2, "BSW" AS DispType2, IIf(Round([Prod Quantity])<0,(Round([Prod Quantity]*-1)),0) AS [Disp Quantity2], "" AS EDispostion2, "" AS Disposition3, "USED" AS DispType3, Round([AllocOilUsed],0) AS [Disp Quantity3], "" AS Edispostion3, "" AS EProduction, "" AS Production1, "Water" AS ProdType1, "bbls" AS [Prod Units1], Round([AllocWater],0) AS [Prod Quantity1], Well_Summary.DaysOn AS [Prod Days Producing1], "" AS EProduction1
FROM ((Wells RIGHT JOIN Well_Summary ON Wells.WellID = Well_Summary.WellID) LEFT JOIN Company_Info ON Wells.WellOperator = Company_Info.Name) LEFT JOIN Leases ON Wells.LeaseID = Leases.LeaseID
WHERE (((Wells.UserField9) Is Not Null) AND ((Wells.Status) Not Like "P&A") AND ((Well_Summary.YearMonth)=[Enter Year & Month Like "2004/02"]) AND ((Wells.State)="nd") AND ((Wells.WellOperator) Like "*petro*") AND ((Leases.ClientID)=15))
ORDER BY Wells.APICode, Wells.WellName;

Ivan PedruzziSubject: need help in converting this access query to an xml query
Author: Ivan Pedruzzi
Date: 13 Oct 2010 10:48 PM

Hi Cheryl

Stylus Studio XQuery engine does not support Microsoft Access.


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!  

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.