Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > ORM Profiler Section > Bugs & Issues> Copy to clipboard exception
 

Pages: 1
Bugs & Issues
Copy to clipboard exception
Page:1/1 

  Print all messages in this thread  
Poster Message
findev
User



Location:

Joined on:
07-Jun-2017 19:22:12
Posted:
1 posts
# Posted on: 07-Jun-2017 19:33:50.  
Hi,

clicking on the "Copy to clipboard" button with inline parameters checked causes the following exception:

Code:

Specified cast is not valid.

ORM Profiler version 1.5. Build July 15th, 2015
-----[Core exception]--------------------
at SD.Tools.OrmProfiler.Client.Core.CoreUtils.ConvertParameterValueToString(Parameter parameter, String quoteChar) in c:\Myprojects\VS.NET Projects\OrmProfilerv1.5_hg\SD.Tools.OrmProfiler.Client.Core\CoreUtils.cs:line 466
at SD.Tools.OrmProfiler.Client.Core.CoreUtils.InlineParameters(String sqlQuery, Command command, DatabaseType typeOfDatabase) in c:\Myprojects\VS.NET Projects\OrmProfilerv1.5_hg\SD.Tools.OrmProfiler.Client.Core\CoreUtils.cs:line 287
at SD.Tools.OrmProfiler.Client.Controls.CommandViewer.HandleCopyToClipBoard() in c:\Myprojects\VS.NET Projects\OrmProfilerv1.5_hg\SD.Tools.OrmProfiler.Client\Controls\CommandViewer.cs:line 322
at SD.Tools.OrmProfiler.Client.Controls.CommandViewer._copyToClipBoardButton_Click(Object sender, EventArgs e) in c:\Myprojects\VS.NET Projects\OrmProfilerv1.5_hg\SD.Tools.OrmProfiler.Client\Controls\CommandViewer.cs:line 335
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Query:

Code:

SELECT TOP(@p2) [LPA_L2].[Id],
                [LPA_L1].[Name]
FROM ((([XYZ].[dbo].[Orders]
         INNER JOIN [XYZ].[dbo].[OrderDetails]
             ON [XYZ].[dbo].[Orders].[Id] = [XYZ].[dbo].[OrderDetails].[OrderId])
         INNER JOIN [XYZ].[dbo].[Products] [LPA_L2]
             ON [LPA_L2].[Id] = [XYZ].[dbo].[OrderDetails].[ProductId])
        INNER JOIN [XYZ].[dbo].[Entities] [LPA_L1]
            ON [LPA_L1].[Id] = [LPA_L2].[Id])
WHERE (((((((([LPA_L2].[IsDeleted] = @p3
             AND [LPA_L2].[IsPublic] = @p4)
             AND [LPA_L2].[IsPublished] = @p5)
             AND [LPA_L2].[DatePublishFrom] <= @p6)
            AND [LPA_L2].[DatePublishUntil] >= @p7)
         AND [XYZ].[dbo].[Orders].[Status] = @p8)
     AND [XYZ].[dbo].[OrderDetails].[PricePerItem] > @p9)))
GROUP BY [LPA_L2].[Id],
         [LPA_L1].[Name]
ORDER BY SUM([XYZ].[dbo].[OrderDetails].[Quantity]) DESC


Parameters:

Code:

Name    DbType    Value
@p2    Int64    10
@p3    Boolean    False
@p4    Boolean    True
@p5    Boolean    True
@p6    DateTimeOffset    12.4.2017 17:28:17 +00:00
@p7    DateTimeOffset    12.4.2017 17:28:17 +00:00
@p8    Byte    4
@p9    Int32    0


Thank you!
  Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
613 posts
# Posted on: 09-Jun-2017 09:46:29.  
Strange! We'll look into it.

Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
613 posts
# Posted on: 09-Jun-2017 11:30:08.  
Reproduced
Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Otis
ORM Profiler Team



Location:
The Hague, The Netherlands
Joined on:
22-Aug-2011 10:26:38
Posted:
613 posts
# Posted on: 09-Jun-2017 12:47:50.  
Fixed. Please download the latest orm profiler installer from the website. We also upgraded the UI controls to use a more recent DevExpress control set so they should be faster Regular Smiley

Frans Bouma
ORM Profiler / LLBLGen Pro Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.09082011 Final.