Page 1 of 3
Retrieve columns problem
Posted: Wed Jul 27, 2011 1:59 am
by Bolex
Hello,
we have a problem retrieving columns in data source from #table (temporary table) with last version 2011.1.
SQL Example in Edit data source:
select a.*,b.* into #temp_table from data a left join /..../
select * from #temp_table
drop table #temp_table
When I click view query, i get data table, but then after click on field retrieve columns it throw exception -> Message: Invalid object name #temp_table ; Source: .Net SqlClient Data Provider
This was working without problems in previous versions.
Thanks in advance.
Retrieve columns problem
Posted: Thu Jul 28, 2011 4:17 am
by Bolex
Any idea? Anyone?
Retrieve columns problem
Posted: Thu Jul 28, 2011 7:30 am
by Alex K.
Hello,
We are working on the problem. We will let you know when the solution is available.
Thank you.
Retrieve columns problem
Posted: Wed Aug 03, 2011 1:09 am
by Alex K.
Hello,
We add an option for selecting the method of getting columns.
Code: Select all
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;
Please check the prerelease build on this week.
Thank you.
Retrieve columns problem
Posted: Thu Aug 04, 2011 7:55 am
by Bolex
Hi,
tnx for replay, I will test and let you know if working properly.
Thank you, B
Retrieve columns problem
Posted: Thu Aug 04, 2011 7:58 am
by Alex K.
Hello,
Ok.
Let us know if you need any additional help.
Thank you.
Retrieve columns problem
Posted: Mon Oct 17, 2011 2:10 am
by wangqiang
Hello,
I got the same problem too.I'm using the Stimulsoft Reports.Net 2011.2.1100.
As the columns are returned by temporary table, after click on "retrieving columns", I got the failed info->"Invalid object name #tmp_table".
But I can't find the option for selecting the method of getting columns which is metioned above. Is it not added to this editon?
Thank you.
Retrieve columns problem
Posted: Mon Oct 17, 2011 4:53 am
by Alex K.
Hello,
You can set this options from code:
Code: Select all
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;
Or from OptionsHelper.exe
Thank you.
Re: Retrieve columns problem
Posted: Fri Aug 03, 2018 3:57 pm
by VaDRo
I have the same problem on version 2015.1.
When I'm running OptionsHelper and setting that option for any value -> OptionsHelper fires exception:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at OptionsHelper.StiOptionsHelperForm.SetNewValue(String customPropertyName, Object newValue)
at OptionsHelper.StiOptionsHelperForm.propertyGrid1_PropertyValueChanged(Object s, PropertyValueChangedEventArgs e)
at System.Windows.Forms.PropertyGrid.OnPropertyValueChanged(PropertyValueChangedEventArgs e)
at System.Windows.Forms.PropertyGridInternal.PropertyGridView.CommitValue(GridEntry ipeCur, Object value)
at System.Windows.Forms.PropertyGridInternal.PropertyGridView.OnListClick(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ListBox.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3131.0 built by: NET472REL1LAST
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
OptionsHelper
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports.Net%202015.1/Bin/OptionsHelper.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Stimulsoft.Report
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Report/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Report.dll
----------------------------------------
Stimulsoft.Base
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Base/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Base.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3110.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Stimulsoft.Editor
Assembly Version: 2015.1.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Stimulsoft.Editor/v4.0_2015.1.0.0__ebe6666cba19647a/Stimulsoft.Editor.dll
----------------------------------------
StiAssembly
Assembly Version: 0.0.0.0
Win32 Version: 2015.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Stimulsoft%20Reports.Net%202015.1/Bin/OptionsHelper.exe
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Drawing.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Re: Retrieve columns problem
Posted: Sun Aug 05, 2018 9:58 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue.
Please try to remove the settings folder by the following path:
[C]:\Users\[UserName]\AppData\Local\Stimulsoft\
Also, you can set all options in your project and save it
StiOptions.Save()
Thank you.