Retrieve columns problem
Retrieve columns problem
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.
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
Any idea? Anyone?
Retrieve columns problem
Hello,
We are working on the problem. We will let you know when the solution is available.
Thank you.
We are working on the problem. We will let you know when the solution is available.
Thank you.
Retrieve columns problem
Hello,
We add an option for selecting the method of getting columns.
Please check the prerelease build on this week.
Thank you.
We add an option for selecting the method of getting columns.
Code: Select all
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;
Thank you.
Retrieve columns problem
Hi,
tnx for replay, I will test and let you know if working properly.
Thank you, B
tnx for replay, I will test and let you know if working properly.
Thank you, B
Retrieve columns problem
Hello,
Ok.
Let us know if you need any additional help.
Thank you.
Ok.
Let us know if you need any additional help.
Thank you.
Retrieve columns problem
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.
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
Hello,
You can set this options from code:
Or from OptionsHelper.exe
Thank you.
You can set this options from code:
Code: Select all
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;
Thank you.
- Attachments
-
- 1369.Capture.PNG (74.07 KiB) Viewed 3725 times
Re: Retrieve columns problem
I have the same problem on version 2015.1.
When I'm running OptionsHelper and setting that option for any value -> OptionsHelper fires exception:
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.
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Retrieve columns problem
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.
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.