Possible bug in Schema Modeler 7

Data Abstract
1

Reproducing the bug…

Open a schema file
Click ‘Commands’ - Add New Command
Click ‘Statements’ - Add New Statement
Enter the statement (e.g. SELECT * FROM Table WHERE ID = :ID)
Click on Target Table, message appears "The Statement code contains Parameters, but no parameters… etc."
Click 'Yes’
Error appears

2

Hello,

this error can depend on particular connection driver. What connection driver are you using? Also can you provide details of this error, error message or (and) call-stack?

Thanks for the report!

3

Hi Alex,

The error message: Object reference not set to an instance of an object.
Using MSSQL.NET driver.

Stack (messages are in Dutch):

2012 nov wo 28 12:56: Unhandled exception occurred:

Message: De objectverwijzing is niet op een exemplaar van een object ingesteld.
Callstack: bij RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.UpdateParametersForSQL(String sql)
bij RemObjects.DataAbstract.SchemaModeler.ViewModel.StatementViewModel.SQLEditor_FocusLostCmd(Object arg)
bij RemObjects.DataAbstract.SchemaModeler.Commands.RelayCommand.Execute(Object parameter)
bij AttachedCommandBehavior.CommandExecutionStrategy.Execute(Object parameter)
bij AttachedCommandBehavior.CommandBehaviorBinding.Execute()
bij (CommandBehaviorBinding , Object , RoutedEventArgs )
bij System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
bij System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
bij System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
bij System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
bij System.Windows.UIElement.OnLostFocus(RoutedEventArgs e)
bij System.Windows.UIElement.IsFocused_Changed(DependencyObject d, DependencyPropertyChangedEventArgs e)
bij System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
bij System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
bij ICSharpCode.AvalonEdit.Editing.TextArea.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
bij System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
bij System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
bij System.Windows.DependencyObject.ClearValueCommon(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata)
bij System.Windows.DependencyObject.ClearValue(DependencyPropertyKey key)
bij System.Windows.Input.FocusManager.OnFocusedElementChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
bij System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
bij System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
bij System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
bij System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
bij System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
bij System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
bij System.Windows.Input.FocusManager.SetFocusedElement(DependencyObject element, IInputElement value)
bij System.Windows.Input.KeyboardNavigation.UpdateFocusedElement(DependencyObject focusTarget)
bij System.Windows.FrameworkElement.OnGotKeyboardFocus(Object sender, KeyboardFocusChangedEventArgs e)
bij System.Windows.Input.KeyboardFocusChangedEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
bij System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
bij System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
bij System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
bij System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
bij System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
bij System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
bij System.Windows.Input.InputManager.ProcessStagingArea()
bij System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
bij System.Windows.Input.KeyboardDevice.ChangeFocus(DependencyObject focus, Int32 timestamp)
bij System.Windows.Input.KeyboardDevice.TryChangeFocus(DependencyObject newFocus, IKeyboardInputProvider keyboardInputProvider, Boolean askOld, Boolean askNew, Boolean forceToNullIfFailed)
bij System.Windows.Input.KeyboardDevice.Focus(DependencyObject focus, Boolean askOld, Boolean askNew, Boolean forceToNullIfFailed)
bij System.Windows.Input.KeyboardDevice.Focus(IInputElement element)
bij System.Windows.UIElement.Focus()
bij System.Windows.Controls.ComboBox.OnMouseButtonDown(Object sender, MouseButtonEventArgs e)
bij System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
bij System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
bij System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
bij System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
bij System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
bij System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
bij System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
bij System.Windows.Input.InputManager.ProcessStagingArea()
bij System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
bij System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
bij System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
bij System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
bij System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
bij MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
bij MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
bij System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
bij MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
bij System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
bij MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
bij MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
bij System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
bij System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
bij System.Windows.Threading.Dispatcher.Run()
bij System.Windows.Application.RunDispatcher(Object ignore)
bij System.Windows.Application.RunInternal(Window window)
bij System.Windows.Application.Run(Window window)
bij System.Windows.Application.Run()
bij RemObjects.DataAbstract.SchemaModeler.App.Main()

Regards,

Filip

4

Hi Filip,

aha got it! There was a bug in previous Fall12 release, which was already fixed.
Can I ask you to try our latest beta or gamma builds?

Thanks!