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 (1189)
- Stylus Studio Technical Forum (14595)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-> + Problem with SAXO processor - ... (5)
-> + PDF Format Help (4)
-> + License check unreliable (2)
-> - XML related issue (1)
-> + Need help regarding pipeline o... (2)
-> + Error converting XML to EDIFAC... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7618)
+ XQuery Help and Discussion (1985)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Pim TaaiSubject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Pim Taai
Date: 22 Feb 2011 03:31 AM
Dear,

Read structure on SQL Server 2000 not always gives a result for no apparent reason.
I'v connected to my SQL 2000 database server, selected the appropriate database, found my table. Right click, "read structure" -> I get an empty set.
If I choose a different table, I gives a result.
Always the same table give the same result!

Attached is a screen picture to show 2 tables. Also the create table SQL statements are enclosed below.


create table ReplenishmentRequest
(
 ReplenishmentRequestId int identity(1,1),
 Sender varchar(100) not null,
 Identifier varchar(100) not null,
 Type varchar(100),
 CreationDate datetime,
 
 verwerkt udt_logical,
 
 DBUserName varchar(32),
 Dlc datetime,
 constraint PKReplenishmentRequestId primary key(ReplenishmentRequestId)
);
 
CREATE TABLE [SystemLevel] (
        [SystemLevelId] [int] NOT NULL ,
        [ModuleName] [varchar] (64) COLLATE Latin1_General_CI_AS NOT NULL ,
        [VersionNr] [int] NOT NULL ,
        [Description] [varchar] (128) COLLATE Latin1_General_CI_AS NOT NULL ,
        [Statements] [ntext] COLLATE Latin1_General_CI_AS NULL ,
        [UserName] [varchar] (128) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_SystemLevel_UserName] DEFAULT (user_name()),
        [CreationDate] [datetime] NOT NULL CONSTRAINT [DF_SystemLevel_CreationDate] DEFAULT (getdate()),
        CONSTRAINT [PK_SystemLevel] PRIMARY KEY  CLUSTERED
        (
         [SystemLevelId]
        )  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


Unknown201102211208html_img1.JPEG
Picture

Postnext
Ivan PedruzziSubject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Ivan Pedruzzi
Date: 25 Feb 2011 01:22 AM
Hi Pim,

This is a known limitation, T="Read Structure" works only if the table contains data.

Hope this helps
Ivan

Posttop
Pim TaaiSubject: BUG: Read structure on SQL Server 2000 not always gives a result for no apparent reason.
Author: Pim Taai
Date: 25 Feb 2011 09:13 AM
Thanx for the help.

   
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.