Microsoft SQL Server Modeling Forum

How is "M" better than SQL92 in modeling data?

Wed, 25 Nov 2009 18:17:00 Z

Maybe I am a blockhead but I don't get it.

- Ciper

How can I reverse-engineer a SQL Server 2005 database into Quadrant?

Wed, 25 Nov 2009 19:12:50 Z

The point is not to model from scratch but to take a model back and re-model it.

-Ciper

Using Oslo MVC 2.0 Web Application - Template

Tue, 24 Nov 2009 12:13:58 Z

Hi,
I've a problem b using the Oslo MVC 2.0 Web Application Template and Visual Studio 2010 Ultimate. If I chose this template I get an the following error:

Error: this template attempted to load an untrsuted component 'Micrsoft.VisualStudio.Web.Mvc.2.0,Version=10.0.0.0 ....

Can anyone help me, to solve this problem?

Thank's

Why does Oslo require SP3 for XP?

Wed, 25 Nov 2009 19:29:47 Z

Even VS2010 doesn't require it.

- Ciper

The current Oslo CTP freezes on an XP install

Wed, 25 Nov 2009 20:25:56 Z

Maybe nobody uses XP anymore but I do.

Can an Oslo guru shed some light on it or are we completely out?

- Ciper

Creating offline OLAP cube with C#.

Wed, 25 Nov 2009 16:43:32 Z

I have a problem with creating an offline OLAP cube from C# using following code:

using (var connection = new OleDbConnection()) { connection.ConnectionString = "Provider=MSOLAP; Initial Catalog=[OCWCube]; Data Source=C:\temp\test.cub; CreateCube=CREATE CUBE [OCWCube] ( DIMENSION [NAME], LEVEL [Wszystkie] TYPE ALL, LEVEL [NAME], MEASURE [Liczba DESCRIPTIO] FUNCTION COUNT ); InsertInto=INSERT INTO OCWCube([Liczba DESCRIPTIO], [NAME].[NAME]) OPTIONS ATTEMPT_ANALYSIS SELECT Planners.DESCRIPTIO, Planners.NAME FROM Planners Planners; Source_DSN=\"CollatingSequence=ASCII;DefaultDir=c:\temp;Deleted=1;Driver={Microsoft dBase Driver (*.dbf)};DriverId=277;FIL=dBase IV;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=600;SafeTransactions=0;Statistics=0;Threads=3;UserCommitSync=Yes;\";Mode=Write;UseExistingFile=True"; try { connection.Open(); } catch (OleDbException e) { Console.WriteLine(e); } }

I keep on getting the following exception:

"Multiple-step operation generated errors. Check each OLE database status value. No action was taken."

I took the connection string literally from OQY file generated by Excel. I had to add "Mode=Write" section, otherwise I was getting another exception ("file may be in use").

What is wrong with the connection string? How to diagnose the error? Somebody please guide me...

Problem using MCompile task and CaseInsensitive attribute in Nov 09 CTP

Tue, 24 Nov 2009 12:40:10 Z

In the previous CTP I had added the Microsoft.M.Embedded.targets file to my csproj, added an mg file to my project and set its build action to MCompile. When I upgraded to Nov 09 CTP this caused build errors, though the same mg file compiles fine from the command line in Nov 09.

I tracked this down to use of the CaseInsensitive attribute on my language, and it occurs even on the simplest of language definitions:

module Test
{
    @{CaseInsensitive}
    language Test
    {
        syntax Main = "Hello";
    }
}

This causes the following build error:

C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error : System.InvalidCastException: [A]Microsoft.M.SemanticGraph.Constant cannot be cast to [B]Microsoft.M.SemanticGraph.Constant. Type A originates from 'Microsoft.M, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' in the context 'LoadFrom' at location 'C:\Program Files (x86)\Microsoft Oslo\1.0\bin\Microsoft.M.dll'. Type B originates from 'Microsoft.M, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' in the context 'LoadNeither' at location 'C:\Users\PDevaney\AppData\Local\Microsoft\VisualStudio\10.0\ProjectAssemblies\7leap_bo01\Microsoft.M.dll'.
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.M.SemanticGraph.ConstantTypeConverter.ConvertTo(ITypeDescriptorContext context, CultureInfo culture, Object value, Type destinationType)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.WrapperTypeConverter.ConvertTo(ITypeDescriptorContext context, CultureInfo culture, Object value, Type destinationType)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.TypeConverterExtensions.ConvertToInvariant[T](TypeConverter converter, ITypeDescriptorContext context, Object value)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.SerializerContext.TryConvertToMarkupExtension(TypeConverter converter, Object& value)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.GetPropertyValueInfoInternal(Object propertyValue, TypeConverter propertyConverter, Boolean isXamlTemplate, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.GetPropertyValueInfo(Object propertyValue, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForReadWriteProperty(Object source, PropertyDescriptor property, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForPropertyDescriptor(Object source, SchemaProperty property, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, HashSet`1 propertyNames, ParameterInfo[] methodParameters, SchemaType type, String contentPropertyName, String runtimeNamePropertyName)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObjectInternal(Object value, SerializerContext context, Boolean valueType, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForSequence(Object sourceOrValue, PropertyDescriptor property, SchemaType type, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForPropertyDescriptor(Object source, SchemaProperty property, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, HashSet`1 propertyNames, ParameterInfo[] methodParameters, SchemaType type, String contentPropertyName, String runtimeNamePropertyName)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObjectInternal(Object value, SerializerContext context, Boolean valueType, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.GetPropertyValueInfoInternal(Object propertyValue, TypeConverter propertyConverter, Boolean isXamlTemplate, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.GetPropertyValueInfo(Object propertyValue, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForReadWriteProperty(Object source, PropertyDescriptor property, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForPropertyDescriptor(Object source, SchemaProperty property, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, HashSet`1 propertyNames, ParameterInfo[] methodParameters, SchemaType type, String contentPropertyName, String runtimeNamePropertyName)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObjectInternal(Object value, SerializerContext context, Boolean valueType, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForArray(Array value, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForDictionary(Object sourceOrValue, PropertyDescriptor property, SchemaType type, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.PropertySerializationInfo.ForPropertyDescriptor(Object source, SchemaProperty property, PropertyDescriptor propertyDescriptor, SerializerContext context)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, HashSet`1 propertyNames, ParameterInfo[] methodParameters, SchemaType type, String contentPropertyName, String runtimeNamePropertyName)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.AddRecordMembers(Object value, SerializerContext context, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObjectInternal(Object value, SerializerContext context, Boolean valueType, TypeConverter converter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.RecordSerializationInfo.ForObject(Object value, SerializerContext context, Boolean isValueType, TypeConverter instanceConverter)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlObjectSerializer.Save(XamlWriter writer, Object obj)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlServices.Save(XamlWriter writer, Object obj)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.Oslo.Xaml.XamlServices.Save(XmlWriter writer, Object obj)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at System.Dataflow.Languages.MImageBase.SaveXaml(PackagePart part, Object data)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at System.Dataflow.Languages.MImageBase.SaveManifest()
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at System.Dataflow.Languages.MImageBase.Save(Stream outputStream, Boolean closeOnDispose)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.M.BuildTask.MCompilerDriver.OutputImage(String outputFile, CompilationResults results)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.M.BuildTask.MCompilerDriver.OutputResult(CompilationResults result)
C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(95,5): error :    at Microsoft.M.BuildTask.MCompilerDriver.Run()

Differences in tree construction?

Wed, 23 Sep 2009 22:25:46 Z

Hi:

I want to show you an example of an MGrammar developed with CTP May 2009.

I tried to make it as small as possible in order to reproduce it.

So, find enclose 3 files:

The point is that there are two productions to parse a property (see variant 1 & 2). The variations changes the way of parsing the “type”. These changes, of course make a structural change in the output tree to the “type” part.

However, take a look (in the picture) to the “name” of the property built in the tree for Prop1 & Prop2.

For Prop1: Name { “Prop1” }
For Prop2: Name => “Prop2”

It’s different!!!! But if you look again to the productions, the parsing for the Name: ( = name:Id ) is the same in both cases.

Why is different?

Open image.

This subtle difference is important when trying to map the parsed graph to .NET objects using MGraphXamlReader. Ending in case 2 with a type mismatch exception between System.Generic.Collection.List’1<object> & PropertyDef.

Maybe I am missing something or may be it is a bug in MGrammar?

I reviewed the bug database in Connect and found nothing similar to this. Any clue?

Thanks in advance,

Dr. Pedro J. Molina | Capgemini Spain

Change Data Capture gives error: invalid number of arguments

Sun, 13 Sep 2009 12:35:47 Z

Hi all,

I'm piloting CDC in Oslo. This article tells what to do: http://msdn.microsoft.com/en-us/library/dd129574(VS.85).aspx

So, after running through that article, im getting a strange error message:

Msg 313, Level 16, State 3, Line 7:

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_ ... .

I thought the message was truncated by management studio; but i think its not. After digging and digging through the functions for CDC, i stubled upon sys.fn_cdc_check_parameters. However nice that may be; i cannot get a resultset from CDC; i need such a resultset for a demo.

Im convinced i missed out something trivial; but i've scanned the msdn page 10 (decimal) times.

So now, how am i going to try out CDC?

I also have another question, since that is what i'm working on now: how can i see who (what connection / repository user) changed some data with CDC?
(as i can get the change-date back from an LSN, can i also get other information?)

Performing my Final Project, looking into codename "Oslo".

Example - building a DSL for Analysis Services Cubes

Tue, 24 Nov 2009 14:37:45 Z

For anyone interested in a step-by-step guide and an example how to build a simple DSL for SQL Server Analysis Services cubes, I put a link to my blog:
http://blogical.se/blogs/jahlen/archive/2009/11/17/instantcube-building-a-sql-server-modeling-application-for-quicker-cube-development.aspx

Any feedback and suggestions is welcome!

Parser.Parse throws InvalidCastException with Nov09 CTP

Fri, 20 Nov 2009 15:38:16 Z

I have upgraded to the Nov09 CTP and a grammar that worked fine in the previous CTP now throws an InvalidCastException when trying to parse what should be valid input. This can be seen in code (calling Parser.Parse) and Intellipad.

I am using M to define a simple "expression evaluator" DSL for my application. I am not using any of the modelling stuff. My DSL is a fairly standard expression syntax, with unary & binary operators, literals of various types, function calls etc. The problem seems to be with the function call syntax.

Here's a cut-down version of my grammar:

module Test
{
    language Test
    {
        interleave Skippable = TWhitespace+;
            
        // Productions    
        syntax Main = e:Expr? => e;    
    
        syntax Expr = e:BinaryExpr => e;
        
        syntax BinaryExpr = 
            r:PrimaryExpr => r
        |   l:BinaryExpr "+" r:PrimaryExpr => BinaryOperator { l, "+", r }
        |   l:BinaryExpr "-" r:PrimaryExpr => BinaryOperator { l, "-", r }
        ;
        
        syntax PrimaryExpr =
            e:TNumber =>  e
        |   e:FunctionExpr => e;
        
        syntax FunctionExpr =
             i:TIdentifier "(" el:ExprList? ")" => Function{ i, el };    
             
        syntax ExprList =
            e:Expr => [e]
        |   el:ExprList "," e:Expr => [valuesof( el ), e];
        
        // Tokens
        token TWhitespace = '\u000C' | '\u0020';
        
        token TNumber = TDigit+;
        token TIdentifier = TLetter+;        
        
        token TDigit = '0'..'9';
        token TLetter = 'a'..'z' | 'A'..'Z';                
    }
}

If I enter this in Intellipad, and give it some input involving numbers & operators (e.g. "1 + 1"), then it is parsed OK. But if I give it input involving a function call (e.g. "foo()"), the error "\\untitled2(1,1): error 0198: Specified cast is not valid." is displayed.

If I compile this into a program and call Parser.Parse, an InvalidCastException is thrown with the following call stack:

 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.Coerce(object result = "a", Microsoft.M.SemanticGraph.TypeCoercion coercion = {Microsoft.M.SemanticGraph.TypeCoercion}, Microsoft.M.SemanticGraph.SymbolResolverBase resolver = {Microsoft.M.SemanticGraph.SymbolResolver}) + 0x1d8 bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.Evaluate(Microsoft.M.SemanticGraph.IExpressionSymbol expression = {Microsoft.M.SemanticGraph.TypeCoercion}, System.Dataflow.IRuntimeEnvironment environment = {System.Dataflow.Parser.BindingEnvironment}, System.Dataflow.IGraphBuilder builder = {System.Dataflow.GraphBuilder}, System.Action<object> setSourceInfo = {Method = {Void <get_Item>b__25(System.Object)}}, Microsoft.M.SemanticGraph.SymbolResolverBase resolver = {Microsoft.M.SemanticGraph.SymbolResolver}) + 0xb5 bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.EvaluateGraph.AnonymousMethod__f() + 0x8f bytes	
 	System.Core.dll!System.Linq.Enumerable.CombineSelectors<System.__Canon,System.__Canon,System.Collections.Generic.KeyValuePair<System.__Canon,System.__Canon>>.AnonymousMethod__11(System.__Canon x) + 0x28 bytes	
 	System.Core.dll!System.Linq.Enumerable.WhereSelectListIterator<Microsoft.M.SemanticGraph.IExpressionSymbol,System.Collections.Generic.KeyValuePair<object,object>>.MoveNext() + 0x68 bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.EvaluateGraph(Microsoft.M.SemanticGraph.GraphExpressionSymbol graph = {GraphSymbol: <null>`2}, System.Dataflow.IRuntimeEnvironment environment = {System.Dataflow.Parser.BindingEnvironment}, System.Dataflow.IGraphBuilder builder = {System.Dataflow.GraphBuilder}, System.Action<object> setSourceInfo = {Method = {Void <get_Item>b__25(System.Object)}}, Microsoft.M.SemanticGraph.SymbolResolverBase resolver = {Microsoft.M.SemanticGraph.SymbolResolver}) + 0x698 bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.Evaluate(Microsoft.M.SemanticGraph.IExpressionSymbol expression = {GraphSymbol: <null>`2}, System.Dataflow.IRuntimeEnvironment environment = {System.Dataflow.Parser.BindingEnvironment}, System.Dataflow.IGraphBuilder builder = {System.Dataflow.GraphBuilder}, System.Action<object> setSourceInfo = {Method = {Void <get_Item>b__25(System.Object)}}, Microsoft.M.SemanticGraph.SymbolResolverBase resolver = {Microsoft.M.SemanticGraph.SymbolResolver}) + 0x12f bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.MockRuntime.Run(System.Dataflow.IRuntimeEnvironment environment = {System.Dataflow.Parser.BindingEnvironment}) + 0xff bytes	
 	Microsoft.M.dll!Microsoft.M.SemanticGraph.SerializationRuntime.Run(System.Dataflow.IRuntimeEnvironment environment = {System.Dataflow.Parser.BindingEnvironment}) + 0x2b bytes	
 	System.Dataflow.dll!System.Dataflow.Parser.ExecuteAction(int productionId = 9, System.Dataflow.IStackState stack = {unique 4 state 18 reductions 0}) + 0x2d6 bytes	
 	System.Dataflow.dll!System.Dataflow.Parser.Exec(int productionId = 9, System.Dataflow.IStackState state = {unique 4 state 18 reductions 0}) + 0x59 bytes	
 	System.Dataflow.dll!System.Dataflow.Reduction.Evaluate() + 0xc9 bytes	
 	System.Dataflow.dll!System.Dataflow.GlrState.GetObject() + 0x1c1 bytes	
 	System.Dataflow.dll!System.Dataflow.GlrState.GetActionResult() + 0x37c bytes	
 	System.Dataflow.dll!System.Dataflow.Parser.Parse(System.Dataflow.ITextStream textStream = {System.Dataflow.TextReaderTextStream}, System.Dataflow.ErrorReporter errorReporter = {System.Dataflow.TextWriterReporter}, System.Dataflow.SourcePoint startLoc = {(1,1)}) + 0x1e0 bytes	
 	System.Dataflow.dll!System.Dataflow.Parser.Parse(System.Dataflow.ITextStream textStream = {System.Dataflow.TextReaderTextStream}, System.Dataflow.ErrorReporter errorReporter = {System.Dataflow.TextWriterReporter}) + 0x39 bytes	
>	MTest.exe!MTest.Program.Main(string[] args = {string[1]}) Line 28 + 0x5f bytes	C#

The exception is caught, but the returned object graph contains a single node with the same error message as Intellipad.

What is going on? Is this a bug, or do I need to make changes to my grammar definition?

Add-on for Visual Studio 2005 to generate Insert statements for SQL 2005

Fri, 20 Nov 2009 17:09:17 Z

Hi, I´m new in this forum, I´m from Argentina and I want to ask if someone knows about an add-on for Visual Studio 2005 that can generate insert statements for an existing table in SQL Server 2005.

I would appreciate if someone could help me.

Thanks in advance.

Dll Security

Mon, 23 Nov 2009 06:59:37 Z

Hi All,

I want to create a dll file that has a high level of security, i.e. I don't want anyone to disassemble this dll, i.e. if you use the IL Disassembler it will show you the defined namespaces and classes inside the dll, how can I prevent anyone from seeing anything if he disassemble my dll?

Thank you very much

Nov CTP: Quadrant fails to start after successful install.

Wed, 18 Nov 2009 13:11:37 Z

When starting Quadrant on the NOV CTP I get the following error

---------------------------
Quadrant Repository Connection Failure
---------------------------
Error on startup.: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
---------------------------
OK
---------------------------

1) Win7 RTM
2) The CTP install completed without any errors being reported
3) The SQL Server 2008 Mgmt Studio can connect to the server and I can see the Repository database and connect to it.

Any ideas?

Installing Nov09CTP on machine without VS2010

Fri, 20 Nov 2009 12:58:29 Z

Hello!

it is possible to install SQL Modeling Nov09 CTP on machine without Visual Studio?

I know that I did not get M integration with VS, but I like to have IntelliPad and Quadrant on that machine to play with existing SQL Server 2008 databases there, and do not like to install visual studio 2010 there (it is test machine running SQL Server 2008 on which I like to show my colleagues what Quadrant and M is).

thanks,

Installation of Microsoft SQL Server Modeling CTP failed.

Wed, 18 Nov 2009 02:41:20 Z

Installation fails with following error in c:\temp\OsloSetup.log

error : Cannot open database "Repository" requested by the login. The login failed.

But I could connect to sql server with windows authentication using management studio.

I tried to restart sql server service and attempted to install.

Then I get this error

catalogentries.sql(26626,1): error M6040: Sql Exception: There is insufficient system memory in resource pool 'internal' to run this query.

also there is another warning prior to this

warning M6046: Database collation is unexpected: M assumes 'Latin1_General_100_CS_AS_KS_WS' but database has collation 'Latin1_General_100_CI_AS_KS_WS'.

SQL Server Modeling Nov CTP setup database creation failure M6049

Wed, 18 Nov 2009 21:43:27 Z

Hi!

Just to possibly help others out, in case you bump into "mysterious" database compatibility has to be 100 error M6049 for the repository creation... turned out to be likely the case with VS 2008 and then VS2010 B2 installation on top of it.

Apparently the SQL Server 2005 is upgraded to SQL Server 2008 in the SQLEXPRESS instance. However the master database kept the compatibility level of SQL Server 2005. After changing that to SQL Server 2008 (= 100), the error went away and setup and/or mx.exe create succeeded.

I'm not yet sure if there are any other issues, however at least one can complete the setup and get the Repository database to begin with...

Br,

Kalle Launiala, Consultant & CEO
ProtonIT Oy

Single Table or Table per subclass

Mon, 16 Nov 2009 21:07:44 Z

Hi, which is better type of inherance, Single Table or Table per subclass?
thanks.

Is MGrammar ditched?

Fri, 13 Nov 2009 22:18:49 Z

Seriously, I won't be surprised if it is, as I had surmised its demise from long ago.

Come on, it cannot be inside SQL Server! Can it?

sql injection?

Fri, 13 Nov 2009 04:51:50 Z

hi can anyone tell wat is sql injection and how it can be used?

pavankumar kavety

Running Oslo tutorial from MSDN

Fri, 13 Nov 2009 22:00:31 Z

Hi,

I am very interested in Oslo, our company does a lot of business modeling. Currently we load our models in SQL server using our own custom-built modeling environment. Oslo seems the logical next step. I want to run the tutorial on MSDN that describes an Oslo model of an installer class (http://msdn.microsoft.com/en-us/library/dd857488(VS.85).aspx). I have one problem: I cannot download the repinst sample application needed to build a wix installer from the installer model. The error message when trying to download from http://code.msdn.microsoft.com/SQLModCTPRepInst/Release/ProjectReleases.aspx?ReleaseId=3454 is: 'this project is not yet published. If you are a coordinator or developer on this project, please sign in with an authorized account.' So what next? I suppose that since the link is on MSDN it should be possible to download the RepInst sample application.

Please help,

Bert-Jan Lappenschaar

Tree Language

Fri, 13 Nov 2009 21:53:32 Z

Here is a small language for modeling and representing trees:

"ceo (cfo (acct hr) cio(it))".ToTree() → Tree
"ceo (cfo (acct hr) cio(it))".ToCanvas() → Canvas
"ceo (cfo (acct hr) cio(it))".ToXaml() → Xaml

If all you want is to get a visual tree for your tree, then you can use it.

If you want to get a strongly-typed tree structure out of a semi-structured string, column or whatever, then you may want to use it.

It is like a TreeRegEx, and will continue to be with the addition of boost-like algorithms such as breadth-first-search, minimum-spanning-tree, etc. (I wish "elevate" included those!)

For more information, please visit http://www.sixpairs.com/dsl/tree-language.aspx or refer to the "Tree Language Developer's Guide" @ http://sixpairs.blob.core.windows.net/docs/tree-language-guide.pdf

Keyword colouring not working in May 2009 CTP

Thu, 15 Oct 2009 19:19:56 Z

I am using Build 3.0.1803.10 on WIN 7.
Even though I have used classification attribute in my grammar, but my texts are not coloured in the DSL text.

Regards

singhhome

'Where' clause in views

Wed, 04 Nov 2009 12:20:32 Z

Hi,

I am having problems using 'where' clause in views. See code below.

type Person
{
PersonId : Integer64;
FName : Text#25;
} where identity PersonId;

Persons : Person*;

PersonView() { from Person in Persons select { FName => Person.FName } where value.PersonId > 10 }

It works ok as long as there is no 'where' clause in PersonView(). When the clause is added, intellipad throws an error below:

-----------------------------------------------------
Microsoft.Internal.Invariant+InternalException: An internal error has occurred:
   at Microsoft.Internal.Invariant.Fail(String description)
   at Microsoft.Internal.Invariant.Assert(Boolean condition)
   at Microsoft.M.SqlGen.RelationBindingHelper.BindRelationColumns(SqlCreatorContext context, RelationBinding binding, IEnumerable`1 columns)
   at Microsoft.M.SqlGen.BoundSqlExpressionOptimizations.OptimizeFromTableViewOrFunctionSubSelect(SqlCreatorContext context, FromItem fromItem, RelationBinding binding)
   at Microsoft.M.SqlGen.SqlExpressionCreator.GenerateFromQueryExpression(FromExpressionSymbol from, QuerySpecification querySpec, HashSet`1 dependencies)
   at Microsoft.M.SqlGen.SqlExpressionCreator.GenerateQueryExpression(IExpressionSymbol queryStart)
   at Microsoft.M.SqlGen.SqlExpressionCreator.GenerateFromExpression(FromExpressionSymbol from)
   at Microsoft.Internal.MethodInfoExtensions.FuncCastingStub`6.Call(T1Sig t1, T2Sig t2)
   at Microsoft.M.TermDispatcherFunc`4.Invoke(TDiscriminator discriminator, T1 arg1, T2 arg2)
   at Microsoft.M.SqlGen.SqlExpressionCreator.Generate(IExpressionSymbol expression)
   at Microsoft.M.SqlGen.SqlExpressionCreator.ForceQuery(IExpressionSymbol expression)
   at Microsoft.M.SqlGen.SqlViewFunctionCreator.FinalizeViewOrFunction(ComputedValue computedValue)
   at Microsoft.M.SqlGen.SqlCreator.FinalizeFunctionsAndViews(SqlCreatorContext context, Module module)
   at Microsoft.M.SqlGen.SqlCreator.DefineImplementations(SqlCreatorContext context, IEnumerable`1 modules)
   at Microsoft.M.SqlGen.SqlCreator.CreateSql(SqlCreatorContext context, Program originalProgram, SymbolResolver originalResolver, IEnumerable`1 references, CatalogCreator catalogCreator)
   at Microsoft.M.SqlGen.SqlCreator.CreateSql(Program program, SymbolResolver resolver, IEnumerable`1 references, CatalogCreator catalogCreator)
   at Microsoft.M.LanguageServices.MProjectStateMachine`2.GenerateDatabaseHelper()
   at Microsoft.M.LanguageServices.MProjectStateMachine`2.GenerateDatabasePending.<OnEnterState>b__35(Object o)
-----------------------------------------

Any idea, what i am doing wrong?

Regards,

Caelius

MGrammar stuck when compiled, Intellipad stops responding

Tue, 03 Nov 2009 11:18:14 Z

Hello,
I'm dealing with a grammar that causes Intellipad to stop validating it. Also when I try to compile it with m.exe, the compiler gets stuck and doesn't compile the grammar. It seems to me that the compiler gets to infinite loop somewhere and most likely that's what makes Intellipad unresponsive to the given grammar as well.

Here is a short grammar that cannot be compiled, if you remove syntax parameters the m.exe will be able to compile it and Intellipad to handle the grammar:

module X
{
language wtf
{
    token Letter = "a".."z" | "A".."Z";
    token String = Letter+;

    syntax Main = A(" ");

    syntax A(x) = "a"
                | "a" B(" ");

    syntax B(y) = "b"
                | "b" A(" ");
}
}

contact: http://hidentity.org/hid/CZ123456

VS2010Beta2

Sat, 31 Oct 2009 14:50:45 Z

Since it appears that Visual Studio 2010 Beta 2 does NOT compile M grammars, wouldn't it be helpful to post a notice to that effect on the Oslo developer's site? I wasted a lot of time trying to get the State Machine example to work before finding related discussion in this forum.

Grammar Inference

Thu, 29 Oct 2009 14:25:16 Z

Are there any plans to automatically infer grammars from text in Oslo?

Example:

abcdabccd

S -> ABAcB
A -> ab
B -> cd

-Ciper

VS2010 beta 2 can't build MG files? "error 0000: Cannot resolve type with name 'MarkupExtension'"

Wed, 21 Oct 2009 17:30:32 Z

Hi,

I hope this is the proper place to post this. I realise it could be taken as a VS question, but the problem (and stack trace) seem to point to Oslo as the culprit.

In a nutshell, when I try to build a project with a .mg file in it in VS2010 beta 2, I get the error:

C:\Program Files (x86)\MsBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(138,5): error 0000: Cannot resolve type with name 'MarkupExtension' and namespace 'http://schemas.microsoft.com/winfx/2006/xaml'. Multiple CLR types found with the same name and namespace. Please check the type names and XmlnsDefinitionAttribute declarations to ensure that XAML type names are unique.

The same project built fine in VS2010 beta 1.

I tried a completely clean project file, added the mprice.mg file from this article:
    http://msdn.microsoft.com/en-us/library/dd441702.aspx

Then made the changes to the project file described here:
    http://social.msdn.microsoft.com/Forums/en-US/oslo/thread/c8563030-1c70-47b1-8bfc-4bc9c638c2b4

And the same problem happened. (It's nice that it wasn't my code that was the problem, but...)

If I run MSBuild on it directly, outside of VS2010, I get an exception and stack trace:

ExecuteM:
Compiling to obj\x86\Debug\mprice.mx
     at Microsoft.M.Driver.DriverBase.Compile(TargetType target, CompilerOptions compilerOptions)
     at Microsoft.M.BuildTask.MCompilerDriver.Run()
     at System.Xaml.ClrTypeResolver.FindTypeInNamespace(XamlNamespaceRecord namespaceRecord, String typeName, XNamespace typeNamespace, Int32 genericArgumentCount)
     at System.Xaml.ClrTypeResolver.ResolveUserType(XName typeName, Int32 genericArgumentCount)
     at System.Xaml.ClrTypeResolver.TryResolveType(XName typeName, Int32 genericArgumentCount, Type& type)
     at System.Xaml.ClrTypeResolver.TryResolveType(TypeReference typeReference, ISchemaTypeResolver schemaTypeResolver, Type& type)
     at System.Xaml.XamlSchemaTypeResolver.RegisterClrType(TypeReference typeReference)
     at System.Xaml.XamlSchemaTypeResolver.Resolve(TypeReference typeReference)
     at System.Xaml.XamlValidatingReader.PopulateSchemaTypeHierachy(SchemaType type)
     at System.Xaml.XamlValidatingReader.FindMemberForType(String memberName, SchemaType type)
     at System.Xaml.XamlValidatingReader.CaptureStartMember()
     at System.Xaml.XamlValidatingReader.InRecord.HandleMember(XamlValidatingReader reader)
     at System.Xaml.XamlValidatingReader.ReaderState.Read(XamlValidatingReader reader)
     at System.Xaml.XamlValidatingReader.Read()
     at System.Xaml.XamlValidatingReader.ReadToEnd()
     at System.Xaml.XamlObjectDeserializer.XamlNavigator..ctor(ISchemaTypeResolver schemaTypeResolver, XamlObjectDeserializerSettings settings, XamlReader reader)
     at System.Xaml.XamlObjectDeserializer.Load(XamlReader xamlReader, XamlObjectDeserializerContext context)
     at System.Xaml.XamlServices.Load(XamlReader reader)
     at System.Xaml.XamlServices.Load(XmlReader reader)
     at System.Xaml.XamlServices.Load(TextReader reader)
     at System.Xaml.XamlServices.Load(Stream stream)
     at System.Dataflow.DynamicParserFactory.GetParser(IList`1 parts, String parserName)
     at System.Dataflow.DynamicParserFactory.GetParser(Package package, String parserName)
     at System.Dataflow.DynamicParserFactory.LoadFromStream(Stream stream, String parserName)
     at Microsoft.M.Parser.SourceParser.<>c__DisplayClass3.<CreateDynamicParserHelper>b__0()
     at Microsoft.Internal.LazyInit.Init2[T](T& itemToInit, Func`1 lazyCreator)
     at Microsoft.Internal.LazyInit.Init[T](T& itemToInit, Func`1 lazyCreator)
     at Microsoft.M.Parser.SourceParser.CreateDynamicParserHelper(String parserName, DynamicParserFactory& factory, DynamicParser& dynamicParser)
     at Microsoft.M.StandardLibrary.StandardLibraryCreator.Parse()
     at Microsoft.M.StandardLibrary.StandardLibraryCreator..ctor()
     at Microsoft.M.StandardLibrary.<Create>b__0()
     at Microsoft.Internal.LazyInit.Init2[T](T& itemToInit, Func`1 lazyCreator)
     at Microsoft.Internal.LazyInit.Init[T](T& itemToInit, Func`1 lazyCreator)
     at Microsoft.M.StandardLibrary.Create()
     at Microsoft.M.SemanticGraph.SymbolResolver..ctor(IEnumerable`1 images, Boolean includeStandardLibrary)
     at Microsoft.M.SemanticGraph.SemanticGraphImporter..ctor(IEnumerable`1 images, Boolean includeStandardLibrary)
     at Microsoft.M.Compiler.SemanticAnalyzeSchema(CompilerOptions options, CompilationResults results)
     at Microsoft.M.Compiler.SemanticAnalyze(CompilerOptions options)
     at Microsoft.M.Driver.DriverBase.Compile(TargetType target, CompilerOptions compilerOptions)
---Inner Exception Details---
C:\Program Files (x86)\MSBuild\Microsoft\M\v1.0\Microsoft.M.Embedded.targets(138,5): error 0000: Cannot resolve type with name 'MarkupExtension' and namespace 'http://schemas.microsoft.com/winfx/2006/xaml'. Multiple CLR types found with the same name and namespace. Please check the type names and XmlnsDefinitionAttribute declarations to ensure that XAML type names are unique.

It's this stack trace that makes me think this is the right place to post the question.

So, am I doing something wrong, or is there a problem with building MGrammar files under .NET 4? If there is, how do I fix it?

Cheers,

    Geoff

How to create statement completion, tooltips and friendly validation messages for textual DSLs in IntelliPad?

Wed, 21 Oct 2009 13:47:48 Z

I would like to create a number of textual DSLs for our factory (http://solutionsfactory.macaw.nl/) to offer developers and product specialists a more productive and user-friendly editing experience than editing XML files in Visual Studio. E.g. a textual DSL for deployment configuration and a textual DSL for SharePoint configuration.

When I specify an XSD in an XML file, Visual Studio offers the following features when editing the XML file:
1) Colorizing / syntax highlighting
2) Validation (squiggles)
3) Statement completion (on elements and attribute names)
4) Tooltips (on elements and attribute names)

To make switching from XML editing in Visual Studio to editing M-based textual DSLs in Intellipad an actual improvement for editing, I need to offer comparable features - I assume IntelliPad is the editor to do this in.

1) I've already achieved colorizing / syntax highlighting for a textual DSL in IntelliPad using MGrammar. No questions here.

However, these questions remain:

2) Validation : I've got squiggles, but how can I provide more user-friendly validation messages in Intelllipad? The standard MGrammar validation messages are good to the language developer, but incomprehensible to the language user. Visual Studio XML + XSD validation messages can easily be understood by users typing XML. Is there some way to hook into mgrammar validation with custom validation logic and/or custom messages?

3) Statement completion: I've seen it working when editing M in IntelliPad when specifying foreign key values (a listbox pops up with values to select from). How can I provide statement completion in my custom textual DSL - for my static DSL keywords but if possible also for user-supplied values like the foreign key value example?

4) Tooltips. How can I display a description text (in a tooltip or otherwise) when users hover over a DSL keyword?

I'm perfectly willing to customize IntelliPad if that is what t takes (what are the best resources to master this?).
However, is any of the above is planned as a standard feature for future versions of Intellipad (or another mgrammar aware editor) I'd like to know.

I know it's a lot of questions to ask, but if anyone can shed some light on any part of this, I'd really appreciate.

OSLO and XPDL

Fri, 23 Oct 2009 03:33:25 Z

Dear all,
We are researching about current technologies for BPM and other workflow applications.
As we found that XPDL is one of the most mature standards for defining and storing process models, I would like to know how can we relate this to Oslo capabilities.
My understanding is that a closer equivalent of XPDL standard to define a process model would be the "M" programming language. Is this correct? If so, is there any tool announced to translate between both? maybe some MS-BPA vendor.
Thanks in advance, hope to have a rapid answer.
Best regards,
Jaime.

Token Alias problem ?

Wed, 30 Sep 2009 07:10:59 Z

Hi,

I am currently crafting a DSL and have discovered what I think may be a problem. In my reseach, I have discovered a similar problem which relates to the use of the CaseInsensitive attribute, but I will document it here anyway.

for a syntax defined as such ...

token   tRelation
        =   "<"     => "LessThan"
        |   ">"     => "GreaterThan"
        |   "<="    => "LessThanOrEqual"
        |   ">="    => "GreaterThanOrEqual"
        ;

syntax RelationalExpression
        =   p:AdditiveExpression => p
        |   l:RelationalExpression t:tRelation r:AdditiveExpression => id(t){Left=>l,Right=>r}
        |   l:RelationalExpression t:tRelation error
        ;

You will notice that I use the "id(x)" form. This works very well for me, but with one exception. The AST is built perfectly, but for some reason the syntax highlighting does not work for any token with an alias. Interestingly, there problem also exists for ActiPro's SyntaxEditor with their Oslo plugin.

Can anyone comment on this, or is this by design?

Regards,

Gary Ranson.

Repository Updates

Tue, 20 Oct 2009 17:27:18 Z

Hi,
if I use the Oslo Repository and SQL Server 2008 R2 with .Net 4.0 Beta 1 is it possible to get a notification if some model-data changes? Perhaps changes could be from another program or another user?

Thanks for the answer.

Parsing Quoted text wich contains Quotes with escape sequence

Thu, 22 Oct 2009 06:09:50 Z

Hi,
How to parse a quoted text that contains a quote with escape charactor.
Eg. "Quoted\"this\"text"
I have seen lot of example for parsiing quoted identifier which can not conatain nested quotes.

Thanks,
Michael

Oslo and DLR in .Net 4.0

Tue, 20 Oct 2009 12:56:55 Z

Is it possible to use the Dynamic Language Runtime and Expression Trees from .Net 4.0 to help build a runtime for Oslo output?
Does this make sense?
Is there an example of this?

Generating Visual studio Test case from Mgraph

Mon, 12 Oct 2009 15:51:35 Z

Can anyone please help to point to some resources OR give any idea on how to transfer Mgraph to Visual Studio Automated Tests?

We are evaulating for using Oslo for "DSL for functional testing for web applications". what we are trying to do is to come up with our own language in which test cases can be written and we need to transfer them to Test which can be executed from Visual Studio (mstest.exe).

For example - below is an sample DSL text

Scenario "Search Customer that exists"
    Given WebPage "http://yahoo.com"
    When type "a" in Textbox "txtName"
   Assert SomeCondition
End Scenario

We are able to define our Grammar(mGrammar) and MGrpah from this DSL text, But we "have no idea" how to generate a Test C# Code(or directly a DLL) from this graph. We do not want to write our custom application to run the test generated. We have to generate Code that can be run as test from Visual studio.

Regards

singhhome

Value in an entity referenced to another entity field

Tue, 06 Oct 2009 12:23:49 Z

Hello!

How value in an entity referenced to another entity field?

I have example type(s):

    type LocaleDictionary
    {
        id : PK => AutoNumber(); // type PK : Integer64;
        name : Text#40;
        displayname : Text#40;
    } where identity (id), unique(name);

    Locales: LocaleDictionary*;

    Locales
    {
        en { name => "en", displayname => "Angielski"},
        // ...
        de { name => "de", displayname => "Niemiecki"}
    }

type SimpleDictionary
{
  id : PK => AutoNumber();
  name : Text#40;
  displayname : Text#40;
  defaultLocale : LocaleDictionary where value in Locales;
  active : Logical => true;
  visible : Logical => true;
  usefrom : DateTime;
  useto : DateTime?;
} where identity (id), unique(name);

type KindType : SimpleDictionary
{
  parent : KindType? where value in Kind;
};

    type LocaleKindType
    {
        id : PK => AutoNumber();
        displayname : Text#40;
        displaynameLocale : LocaleDictionary where value in Locales;
        idKind : KindType where value in Kind;
    } where identity (id), unique(displaynameLocale, idKind);

Kind : KindType*;
LocaleKind : LocaleKindType*;

// I define here Kind with displayname ='Root' and default locale == 'en'
Kind {KindRoot {name => "Root", displayname => "Root", defaultLocale => Locales.en, visible => false, usefrom => 2000-01-01T00:00:00}}

// [1]
// This work. But is not elegant, see displaynameLocale.
//LocaleKind {LocaleKindRoot {displayname => Kind.KindRoot.displayname, displaynameLocale => Locales.en, idKind => Kind.KindRoot}}

// [2]
// This does not work.
LocaleKind {LocaleKindRoot {displayname => Kind.KindRoot.displayname, displaynameLocale => Kind.KindRoot.defaultLocale, idKind => Kind.KindRoot}}

Take a look at [1] and [2].
Displayname field in LocaleKindType is referenced to displayname field in KindRoot. But, displaynameLocale in LocaleKindType can't reference defaultLocale field in KindRoot.

How to reference value in LocaleKindRoot to defaultLocale in KindType entity (KindRoot)?

More precisely: how to reference fields in LocaleKindRoot (displaynameLocale) and in KindRoot (defaultLocale) to the same value?

Thanks and Regards

Executing a Grammar from C#

Mon, 12 Oct 2009 17:38:37 Z

How can I call a grammar ( using m Engine ) developed in M from C#
Best Regards

Luis Diego Rojas. http://icomparable.blogspot.com

MCP, MCTS Biztalk Server

Problem: Quadrant doesn't starts

Thu, 24 Sep 2009 07:21:05 Z

Hello,
I've got problem with running Quadrant after installing Oslo. During installation everything looks fine, there are no errors. But after installation, when I'm trying to run Quadrant, I've got "Quadrant Repository Connection Failure" and info that it was unable to connect to quadrant repository with 'DeployRepository.SqlUtil' exception. So I've tried to create repository manualnny using command line:

mx.exe create /database:Repository2

and I've got error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)”

I've checked all points in msdn documentation that could cause that issue and everything looks fine.

I've got new Windows XP installation with SP3 on virtual machine with Windows Installer 4.5, MS SQL Server 2008 Express.

Any ideas what can be wrong?

How to Implement Syntax Lists?

Wed, 30 Sep 2009 07:23:04 Z

Hi,

I am, so far, very impressed with the toolset provided by the OSLO project. I had been working with ANTLR to date, and found that OSLO is far simpler to implement - and do hope that this will go to a production release.

Firstly I would like to say that I'm not an expert in language design, so please forgive me if this is a little fundamental. Here goes ...

When implementing lists (such as argument lists), this is the common template which appears to be used ...

syntax ArgList
        =   a:Argument=> [a]
        |   list:ArgList "," a:Argument => {valuesof(list), a }
        ;

However, I have started to use this template ...

syntax  ArgList
       = a:Argument b:("," b:Argument=> b)* => {a,valuesof(b)}
       ;

They both return the same AST, but I was wondering if there is any difference "under-the-covers" ?

Your comments are welcome.

Is there a way to parse a T-SQL select statement with the M runtime?

Tue, 22 Sep 2009 23:58:57 Z

Searching around the Microsoft.M assembly I found the SourceParser class and whole set of classes in the Microsoft.TSQL10 namespace that seem related to parsing SQL but I cannot find examples of how to use it.

I know the you can generate T-SQL easily enough, but can you consume it, manipulate the data structure and re-output a modified version of the SQL select?

Thanks,

Darrel