Hi, I try to import some valid schema (for xmlspy and oxygen) with XMLMapper in delphi and I have this error "Error Flux if:InfofileType unknown". I use namespace and this type is define in another file. Is there a way to solve this ? (I also try with Delphi 2010 demo and it still not work) <?xml version="1.0" encoding="UTF-8" ?>...
This is a very simple question, and maybe the man himself can provide insight on this :) Does anyone know the pseudocode behind how Fog Creek does database schema management? I'm running into an issue and I'm trying to figure out if I'm handling it right... I have a module that runs each time someone spins up their site and examines th...
What are the differences in database terminology between MsSQL and MySQL? Can a mysql instance have more than one database? It appears that it can only create different schemas.. However the sql command is "create database". In MsSQL you can create multiple databases.. each have a default schema of dbo?.. but multiple schemas in a data...
I'm working on a project with developers who have not worked with Ruby OR Rails before. They have created a schema that is too complicated, in my opinion. The schema has 117 tables, and obtaining the simplest piece of information would require traversing/joining 7 tabels...and of course, there's no "main" table that serves as a sort of...
Hi there, I'm having a validation problem with JavaScript in Visual Studio 2008. By default, the validation schema is set to XHTML 1.0 Transitional for JavaScript files. This makes it difficult to format a lot of comments and code while I'm writing it (although it looks fine after all the semicolons are in place and such). I have a s...
Hi all, As XML Schemas can be tedious to read (yes, just want to read through the schema) in their normal form, I'm wondering if anyone knows of an existing plugin for vim which will display the schema in tree form, as several XML editors do? Selection of a node in this tree to navigate to the relevant section of the schema would be a g...
Hi! I was trying to validate this XML file ... where if <tag1> is "Y" then <tag2> must appear if <tag1> is "N" then <tag2> must not appear .. <parent> <a> <tag1>Y</tag1> <tag2>sometext</tag2> </a> <a> <tag1>N</tag1> </a> </parent> I tried <choice> tag but doesn't seem to work .. :( I have come to conclusion th...
Let's say I have a doc.xml and corresponding doc.xsd. I use xpath to retrieve some nodes, so I get a list of org.w3c.dom.Node. How can I get type of each node from schema, eg. xs:integer, xs:string etc ? Some solution would be to parse schema with xpath query "//NodeName[@type]" using node.getNodeName() as NodeName, but that's not perfe...
Hello Experts, We are thinking about to create new schema with its own 3 tables which will be created on the fly for an individual customer. To run a particular query for those tables in a procedure, should we have something like this. declare @sName nvarchar(200); select @sName =Schema_Name from schema where Schema_Id = passed_id_fro...
I have an existing XML schema that contains a type that I would like to map to a Java Map of some sort using JAXB. My build process takes the schema and creates the beans. I would like to customize this process by having one of the complexTypes in my schema map to a java.util.Map. I've read somewhere that JAXB "can't do interfaces." I'm ...
Having a XmlDocument loaded with a XSD schema, how do I get the restrictions for a given node in the document? I would like to iterate through the document, and automatically correct errors where possible (eg: truncate strings that are too long, remove empty nodes that shouldn't be, etc.) I am doing this because xsd.exe does not take i...
Say I have two sets of XML elements: <One/> <Two/> <Three/> And <A/> <B/> <C/> And I want to have them as children of a bucket element: <Bucket> <A/> <One/> </Bucket> Or <Bucket> <C/> <Two/> </Bucket> But I don't want to allow more than one element from either set of elements. I.e: <Bucket> <A/> <B/> <On...
What would it mean to create something like the following? <xsd:simpleType name="myField"> <xsd:restriction base="xsd:boolean"/> </xsd:simpleType> Notice there are no actual elements within the restriction (no min or max length, no enumerations, etc). I feel like this is basically setting the type of myField to xsd:boolean. Howe...
Let's say I want to write a program that can generate a diagram (e.g. an organization chart, timeline, or GANTT chart) out of some input data sitting in a spreadsheet or database. One big challenge is that users store their data in different formats that are frequently unstructured or missing 100% integrity. For example, I can think of...
I'm working on creating a messaging system as a pet project, that will include the ability to have file attachments. This will be used on a website of mine for the internal messaging system. One of the features of this system is I want to maintain the MD5 checksum of every file that is uploaded so if duplicate files are uploaded, the t...
I'm setting up an asset tracking database. Assets vary among black berries, PCs, servers, monitors, speakers, keyboards, mice, chairs, desks, cubicals, cubical walls, printers, refrigerators, microwaves... the whole range of things. That range would be my Category table: create table AssetManagement.zCategory( zCategoryId int identit...
Hello. I am evaluating Amazon SimpleDB at this time. SimpleDB is very flexible in the sense that it does not have to have table (or domain) schemas. The schema evolves as the create / update commands flow in. All this is good but while I am using a modeling tool (evaluating MindScape LightSpeed) I require the schema upfront, in order for...
I am using Entity Framework to do the ORM in .NET project. The problem I am facing is that when the database schema changes, there is no proper mechanism to update the edmx file. For example, If there is a column called "Salary", and I change it to "EmpSalary", then when I update the edmx from visual studio and it shows me two columns ...
I transfered a project to a new machine. Everything works. I can run migrations and they update the mysql database. However, the schema.rb file doesn't acknowledge the changes. I checked the read/write permissions for schema.rb are OK. Does anyone have any idea about what could cause this problem. I'm using Rails version 2.3.5. ra...
Hi - I am running several schemas on a single mysql server. One of the schemas has an underscore in its name ("some_name"), and the rest don't. I noticed that in the Admin GUI I am seeing 2 schemas that represent the same one, with one having an escape character before the underscore - so in the schema list I see: schema1 schema2 some_...